|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unix shell script Certification for oracle developer. | rdhaprakasam | UNIX for Dummies Questions & Answers | 1 | 07-09-2009 04:24 PM |
| Return value from oracle to unix shell | ravi214u | UNIX for Dummies Questions & Answers | 2 | 12-05-2008 08:01 AM |
| UNIX shell scripting for retrieving from oracle | sundar_ravi4 | Shell Programming and Scripting | 5 | 07-06-2006 01:06 PM |
| Connecting to Oracle through unix shell scripts | guptan | UNIX for Advanced & Expert Users | 1 | 07-04-2005 01:16 PM |
| Unix + oracle doubt....involving shell script | mexx_freedom | UNIX for Dummies Questions & Answers | 2 | 08-02-2001 10:48 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
07-17-2009
|
||||
|
||||
|
Getting value from oracle to unix shell
All, I am using Sun Solaris and Oracle 10g. I have a simple shell script returning a value. Code:
#!/usr/bin/ksh dummyvar=`sqlplus -s '/as sysdba' <<END set feedback off; set verify off; set serveroutput on; select num from scott.num1; END` echo $dummyvar For the above script - i am getting value as below Code:
NUM --------- 16-APR-09 i.e, i am getting field name and value. I don't want NUM-------- . I just want 16-APR-09. Can someone help me out. Next time use CODE-tags when posting code, data or logs to enhance readability and to keep formatting like indention etc., ty. Last edited by zaxxon; 07-17-2009 at 01:37 AM.. Reason: code tags |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
