![]() |
|
|
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 |
| Need Unix script for executing oracle query | ravi gongati | Shell Programming and Scripting | 14 | 03-24-2008 05:53 AM |
| How to execute multiple(batch) oracle script in unix mechine | ravi gongati | Shell Programming and Scripting | 2 | 03-21-2008 07:37 AM |
| $HOME Not Getting Set for Oracle Scheduler Script at Runtime | shew01 | Shell Programming and Scripting | 4 | 12-14-2007 08:31 AM |
| Perl script variable passed to Oracle query | rahulrathod | Shell Programming and Scripting | 1 | 05-30-2007 09:57 AM |
| Can Unix (Solaris) execute a dos .bat script? | BCarlson | UNIX for Dummies Questions & Answers | 4 | 08-26-2006 09:52 PM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
Execute oracle query determined at runtime from a unix script
Hi
I am trying to run a SQL statement from a unix script determined at runtime. It is throwing me an error. Please advise some solution to this. echo "Enter username for the database" read username echo "Enter password for the database" read password echo "Enter SQL stmt" read sqlstatement sqlplus ${username}/${password} <<EOF spool output.lst; execute immediate '$sqlstatement'; spool off; EOF |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|