03-18-2014
Thak you all for the wonderful input. It sings like a bird. But here comes the major problem.
Whenever i use IFS in my script, sqlplus doesnot run and throws me an error saying that no such file or directory.
I i remove IFS, sqlplus runs without any problem.
So i was wondering if there is any other way like awk or anything else, however bad or long programming it may be...thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello All,
I am novice on Shell Scripting. Any help on this is highly appreciated.
I have a variable
$VARIABLE="$some1|$some2|$some3"
I need sub variables $SUBVAR1,$SUBVAR2,$SUBVAR3 which must be equal to $some1 , $some2 and $some3 respectively.
It works fine with
$SUBVAR1 =... (6 Replies)
Discussion started by: jingi1234
6 Replies
2. Shell Programming and Scripting
Hello experts,
This might prove to be a stupid question to some of you, but I have tried to tackle it in different ways. Being new to shell scripting, I am requesting your help in coming up with an elegant solution. I am using Korn shell.
We have a directory with file names with the pattern:... (2 Replies)
Discussion started by: prashk15
2 Replies
3. Shell Programming and Scripting
Hi,
I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Discussion started by: gupt_ash
6 Replies
4. Shell Programming and Scripting
Hi,
My inputfile contains field separaer is ^.
12^inms^
13^fakdks^ssk^s3
23^avsd^
13^fakdks^ssk^a4
I wanted to print only 2 delimiter occurence i.e
12^inms^
23^avsd^ (4 Replies)
Discussion started by: Jairaj
4 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a string say "whateverCluster".
I need everthing apart from the string "Cluster"
Input:
whateverCluster
Desired output:
whatever (5 Replies)
Discussion started by: mohtashims
5 Replies
6. Shell Programming and Scripting
Hi,
for fd in $(grep "/tmp/" hello.properties)The grep gives me the below output:
deploydir=/tmp/app1/dfol
prodir= /tmp/hello/prop
......
Now i want to store /tmp/app1/dfol then /tmp/hello/prop in a variable so that i can check if those folders files exists or not.
The delimiter would... (4 Replies)
Discussion started by: mohtashims
4 Replies
7. Shell Programming and Scripting
Hi,
Variable1 = MKT1,MKT2,MKT3,MKT4
Now i want to store each of these value seperated by comma to a array and access each of the values. Also find out number of such values seperated by comma.
Variable1 can have any number of values seperated by comma.
Thanks :) (3 Replies)
Discussion started by: arghadeep adity
3 Replies
8. Shell Programming and Scripting
Hi guys!
First time poster on here, was wondering if someone could help with a problem which I'm facing.
Is it possible to use awk or sed to separate the below output based on TRANSACTION_DATE? The output would then feed into DataStage.
Contents of CSV file:... (5 Replies)
Discussion started by: Jimmy_the_tulip
5 Replies
9. UNIX for Dummies Questions & Answers
i have a snippet from server log delimited by forward slash.
/a/b/c/d/filename
i need to cut until last delimiter. So desired output should look like:
/a/b/c/d
can you please help?
Thanks in advance. (7 Replies)
Discussion started by: alpha_1
7 Replies
10. Programming
Hi,
I am working in Visual studio 2008 in which i have written the code in c++,qml,qt.Its a simulator application.
I would like to create a simulator with certain changes. In order to do that i have modified the code with few changes based on the preprocessor condition.
#define... (4 Replies)
Discussion started by: SA_Palani
4 Replies
LEARN ABOUT PHP
oci_set_client_info
OCI_SET_CLIENT_INFO(3) OCI_SET_CLIENT_INFO(3)
oci_set_client_info - Sets the client information
SYNOPSIS
bool oci_set_client_info (resource $connection, string $client_info)
DESCRIPTION
Sets the client information for Oracle tracing.
The client information is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL
statement is executed.
The client information can subsequently be queried from database administration views such as V$SESSION.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $client_info
- User chosen string up to 64 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the client information
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the client information
oci_set_client_info($c, 'My Application Version 2');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the client
// information:
sqlplus system/welcome
SQL> select client_info from v$session;
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
SEE ALSO
oci_set_module_name(3), oci_set_action(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_CLIENT_INFO(3)