|
|
|
|
|||||||
| Forums | Portal | Register | Rules & FAQ | Contribute | Members List | Arcade | 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 here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Running UNIX commands remotely in Windows box from Unix box – avoid entering password | D.kalpana | UNIX for Dummies Questions & Answers | 1 | 04-20-2007 02:24 AM |
| How to use unix commands in awk | jerome Sukumar | Shell Programming and Scripting | 7 | 12-26-2006 04:15 AM |
| Need help on Unix commands. | adngu3 | High Level Programming | 1 | 03-09-2005 06:21 AM |
| Maingrame to UNIX sending UNIX commands | skammer | UNIX for Dummies Questions & Answers | 2 | 06-27-2002 09:19 AM |
| Unix Commands | smdakram | UNIX for Dummies Questions & Answers | 2 | 01-13-2002 04:12 PM |
 |
|
|
LinkBack | Thread Tools | Display Modes |
05-19-2006
|
|||
|
|||
|
SQL Commands in Unix
Hi gurus,
Being a newbie not sure whether iam asking the right question? can we use oracle commands in unix for ex: to read a count on a table. if so, what needs to be configured and etc.. any kind of help is appreciated. Thanks sish 
|
| Forum Sponsor | ||
|
|
|
05-19-2006
|
|||
|
|||
|
Code:
sqlplus -s <<EOF $user/$passwd@oracle_instance select count(*) from mytable; exit EOF
|
|
05-25-2006
|
|||
|
|||
|
It worked well before
but when i try to execute the above shell script(as given by jim) it encounters the following error as 'sqlplus not found' may be some one removed the path of sqlplus. how should i configure the path and in which file should i configure the path the shell type is : ksh any mind of help is appreciated regards sish
|
|
05-25-2006
|
|||
|
|||
|
If you are using CSH then you'll want to invoke a different script:
source /usr/local/bin/coraenv and yes, you will want to put it in your .cshrc but you'll have to set your ORACLE_SID variable and ORAENV_ASK=N prior to sourcing the script.
|
|||
| Google UNIX.COM |
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
