Sqlplus Set Heading not Working Post: 302735849

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Hi All, I needed to get the result of two sqlplus queris into shell variables. After days of looking for the ultimate solution to this problem.. i found this... sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ", $1);}' | read VAR1 VAR2 set head off...

2. Shell Programming and Scripting

set -x not working

Hi, even after i am setting the trace on(set -x), trace is not printed. can you please tell me what is the error. below is the code & output. Thanks in advance, Harish ------------------------------------------------- test.sh ------------------------------------------------- #!...

3. Shell Programming and Scripting

Multiple SQLPLUS background processes not working properly

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...

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Can someone tell me why I'm getting error when I try to run this? #!/bin/csh -f source ~/.cshrc # set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus # set count=`$SQLPLUS -s ${DB_LOGIN} << END select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;...

5. UNIX for Dummies Questions & Answers

set -o vi not working in Solaris 9

Hi Got 2 solaris boxes - one uses set -o vi happily (put it in .profile) The other reports: -o: bad option(s) Both are solaris 9 and both users have $SHELL set to /bin/ksh Any ideas?? Thanks

6. Shell Programming and Scripting

sqlplus @ not working sqlplus \@ working..

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...

7. AIX

SQLPLUS -S option not working

Hi All, 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...

8. Shell Programming and Scripting

Working with UTF char sqlplus

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...

9. Shell Programming and Scripting

Sqlplus not working through ssh

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

10. UNIX for Beginners Questions & Answers

"SQLPLUS -S " is not working in one environment where same code is working in another

"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...

LEARN ABOUT MOJAVE

iofileb.d

iofileb.d(1m)							   USER COMMANDS						     iofileb.d(1m)

NAME

       iofileb.d - I/O bytes by file and process. Uses DTrace.

SYNOPSIS

       iofileb.d

DESCRIPTION

       This  prints  a	summary  of  requested	disk  activity	by pathname, providing totals of the I/O events in bytes. It is a companion to the
       iofile.d script - which prints in terms of I/O wait time, not bytes.  I/O wait time  is	a  better  metric  for	understanding  performance
       issues.	Both disk and NFS I/O are measured.

       Since this uses DTrace, only users with root privileges can run this command.

EXAMPLES

       Sample until Ctrl-C is hit then print report,
	      # iofileb.d

FIELDS

       PID    process ID

       CMD    process name

       KB     kilobytes of disk I/O

       FILE   file pathname

DOCUMENTATION

       See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
       bose descriptions explaining the output.

EXIT

       iofileb.d will sample until Ctrl-C is hit.

SEE ALSO

       iofile.d(1M), iosnoop(1M), dtrace(1M)

version 1.00							   Feb 20, 2006 						     iofileb.d(1m)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Discussion started by: pranavagarwal

2. Shell Programming and Scripting

set -x not working

Discussion started by: harish.madu

3. Shell Programming and Scripting

Multiple SQLPLUS background processes not working properly

Discussion started by: rawat_me01

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Discussion started by: gregrobinsonhd