09-28-2010
Thanks to all...
Tried the spool and it works. I guess I just learned a valuable lesson... My co-workers
pretendto know UNIX. Next time I won't take what they say as gospel and try it for myself, which is what i usually do. I don't know what came over me.
![Embarrassment Smilie](https://www.unix.com/images/smilies/redface.gif)
This User Gave Thanks to dortoh For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
All,
I have a shell script which executes the below command
find $1 -name $2 -print > ${Backup}/FileFind.txt
I have $2 sometimes coming with the below values.
.*
When I go to the log after the execution of the script, .* gets expanded to .developer.adm instead of searching for all... (5 Replies)
Discussion started by: njoshi
5 Replies
2. Shell Programming and Scripting
Hi,
I have a script that at one point prints to a file as follows:
printf -- $2 > ~/.mydir/$1
The idea is to print to a hidden directory .mydir in my home directory. I've already sanitized the inputs and $1 is in the format path1/path2/filename and $2 is some user input.
When I run this... (2 Replies)
Discussion started by: Rledley
2 Replies
3. UNIX for Dummies Questions & Answers
Hi there,
Can anyone explain me the following behavior?
hfserver:~# ls -l /home/cronlogs/mysqldump*
-rw-r--r-- 1 root root 10658464 2009-01-18 03:00 /home/cronlogs/mysqldump_20090118030002
-rw-r--r-- 1 root root 10651035 2009-01-19 03:00 /home/cronlogs/mysqldump_20090119030001
-rw-r--r-- 1... (4 Replies)
Discussion started by: chebarbudo
4 Replies
4. Shell Programming and Scripting
I have a script that takes an option for server pools to run the script against. The option is given as a comma separated list (ie, -p 201,204,301).
I'm using eval and brace expansion to get those pool numbers into an array. It works fine unless only 1 pool number is given. Here's the code:
... (5 Replies)
Discussion started by: mglenney
5 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am facing issues converting white spaces and tabs together in a file I am reading. Here is the command I am trying:
tr -s ' '@ | sort -t@ +1n filename
I guess the problem is that it is not converting the tabs to another delimiter. Also, I am supposed to accomplish this only using... (5 Replies)
Discussion started by: sh_kk
5 Replies
6. Shell Programming and Scripting
Hi ,
could anyone help me out with this problem.
sample.txt has this content :
u001- this is used for project1 ||
u002- this is used for p2|| not to be printed
u003- this is used
for project3 ||
u004- this is
used for p4 ||
u005- this is used for project5 ||
u006- this is used for p6... (9 Replies)
Discussion started by: Balaji PK
9 Replies
7. UNIX for Dummies Questions & Answers
Hi
I have an input file which have random file in between.I have to manipulate each line and replace the character from position 5-10 with XXXXXX.
But when I am writing this to on output file the tabs in between gets converted to normal space.
Input file :
14207531131040896334R108 ... (4 Replies)
Discussion started by: akashtcs
4 Replies
8. UNIX for Dummies Questions & Answers
I have a bunch of files which I need to transfer to another location... and some of these I need to skip.
For e.g. let us say the files are:
cust_abc.dat
cust_xyz.dat
cust_def.dat
and I only want to move the first two.
I want to do something like:
cp cust_.dat <target>
... (1 Reply)
Discussion started by: jawsnnn
1 Replies
9. Shell Programming and Scripting
(Using Bash 4.4)
When I write something like dir="~/dox"
ls $dir then I get the message that the directory '~/docs' does not exist. I understand that the tilde is not expanded at the time of the above assignment because of the quotes. But why is it not expanded at the time when the ls command is... (2 Replies)
Discussion started by: Ralph
2 Replies
10. Shell Programming and Scripting
Hello All,
Could you please do help me here as I would like to perform parameter expansion in shell over a parameter expansion.
Let's say I have following variable.
path="/var/talend/nat/cdc"
Now to get only nat I could do following.
path1="${path%/*}"
path1="${path1##*/}"
Here... (8 Replies)
Discussion started by: RavinderSingh13
8 Replies
LEARN ABOUT PHP
oci_parse
OCI_PARSE(3) OCI_PARSE(3)
oci_parse - Prepares an Oracle statement for execution
SYNOPSIS
resource oci_parse (resource $connection, string $sql_text)
DESCRIPTION
Prepares $sql_text using $connection and returns the statement identifier, which can be used with oci_bind_by_name(3), oci_execute(3) and
other functions.
Statement identifiers can be freed with oci_free_statement(3) or by setting the variable to NULL.
PARAMETERS
o $connection
- An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $sql_text
- The SQL or PL/SQL statement. SQL statements should not end with a semi-colon (";"). PL/SQL statements should end with a semi-
colon (";").
RETURN VALUES
Returns a statement handle on success, or FALSE on error.
EXAMPLES
Example #1
oci_parse(3) example for SQL statements
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
// Parse the statement. Note there is no final semi-colon in the SQL statement
$stid = oci_parse($conn, 'SELECT * FROM employees');
oci_execute($stid);
echo "<table border='1'>
";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo "<tr>
";
foreach ($row as $item) {
echo " <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>
";
}
echo "</tr>
";
}
echo "</table>
";
?>
Example #2
oci_parse(3) example for PL/SQL statements
<?php
/*
Before running the PHP program, create a stored procedure in
SQL*Plus or SQL Developer:
CREATE OR REPLACE PROCEDURE myproc(p1 IN NUMBER, p2 OUT NUMBER) AS
BEGIN
p2 := p1 * 2;
END;
*/
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$p1 = 8;
// When parsing PL/SQL programs, there should be a final semi-colon in the string
$stid = oci_parse($conn, 'begin myproc(:p1, :p2); end;');
oci_bind_by_name($stid, ':p1', $p1);
oci_bind_by_name($stid, ':p2', $p2, 40);
oci_execute($stid);
print "$p2
"; // prints 16
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
This function does not validate $sql_text. The only way to find out if $sql_text is a valid SQL or PL/SQL statement is to execute
it.
SEE ALSO
oci_execute(3), oci_free_statement(3).
PHP Documentation Group OCI_PARSE(3)