I am using the following script to run some sql on database but i am not getting the result. When i tried the same by removing "-s" option it is working fine but getting other things as well with my input as shown below. Can anyone please suggest why "-s" option is not working in AIX and reply an alternate option if available.
This is my code without sqlplus -s option
and the ouput is as below:
How to remove all other data in the ouput apart from the values i actually required from sql
How can I use the 'ps' command to view current sessions but only for a given process/user, with the -u parm?
In older versions of Unix, this used to work, but not in Sun Solaris.
Thanks (4 Replies)
:confused: In the following, when I enter a valid, existing directory,why am I getting Not Found when the Dir DOES exist?
read auser
echo "You entered $auser"
wait 2
cd /home
if
then
echo "Dir Exists"
sleep 2
else
echo "/home/$auser Not Found"
sleep... (2 Replies)
Hi All,
I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time.
These 25 process creates 25 different files.
When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25... (1 Reply)
Running HP 11.31 on a HP3600. But when I log in as a user the who command works but if I use an option like "who -m" I get nothing. Any thoughts on what is causing this problem. (11 Replies)
Hi All,
I am facing a strange problem on one of my unix servers.
When i try to login using the standard method:
it fails with below message
>sqlplus REF1SSTDBO1/REF1SSTDBO1@TKS3N10G
> TKS3N10G
ksh: TKS3N10G: not found
But it works perfectly when i escape with ;\
>sqlplus... (3 Replies)
Hello,
Could someone tell me why this still returns headings?
echo "SELECT columnA from tableA group by columnA;" |
sqlplus -s ${DB_CONNECT}
set heading OFF |
while read line
do
arr="$line"
echo ${arr}
let i=$i+1
done (2 Replies)
In solaris, i m trying to find the files having a particulat extension and then from the list i want to exclude those files which is present in a file.
But it seems the -f and -v option are not working
find $source -type f -name $extn | /usr/xpg4/bin/grep -F -v -f $exclude | while read... (7 Replies)
I have below SQL that I wasnt to run from a solaris machine using sqlplus
select * from TABLE_NAME where regexp_like(field_value, 'Α|Β|Γ|Δ|Ε|Ζ|Η|Θ|Ι|Κ|Λ|Μ|Ν|Ξ|Ο|Π|Ρ|Σ|Τ|Υ|Φ|Χ|Ψ|Ω|α|β|γ|δ|ε|ζ|η|θ|ι|κ|λ|μ|ν|ξ|ο|π|ρ|σ|τ|υ|φ|χ|ψ|ω');
When I cat the file UTF char shows perfect however when i run... (1 Reply)
Hi Gurus,
I was trying to execute sqlplus command remotely like
ssh -q IP venkat@"which sqlplus"
am getting error as which: no sqlplus in (/usr/local/bin:/bin:/usr/bin)
if i connect manually and executing which sqlplus it working fine.
Please help to fix the issue.
Regard's
Venky (7 Replies)
"SQLPLUS -S " is not working in one environment where same code is working in another
getting below error
===================================
SQL*Plus: Release 11.2.0.3.0 Production
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus... (1 Reply)
Discussion started by: yogendra.barode
1 Replies
LEARN ABOUT PHP
oci_server_version
OCI_SERVER_VERSION(3)OCI_SERVER_VERSION(3)oci_server_version - Returns the Oracle Database versionSYNOPSIS
string oci_server_version (resource $connection)
DESCRIPTION
Returns a string with the Oracle Database version and available options
PARAMETERS
o $connection
-
RETURN VALUES
Returns the version information as a string or FALSE on error.
EXAMPLES
Example #1
oci_server_version(3) example
<?php
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
echo "Server Version: " . oci_server_version($conn);
// Displays:
// Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
// With the Partitioning, OLAP, Data Mining and Real Application Testing option
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ociserverversion(3) instead. This old name still can be used. However it is deprecated
and not recommended.
SEE ALSO oci_client_version(3).
PHP Documentation Group OCI_SERVER_VERSION(3)