10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I am trying to create a shell script to insert in to oracle table
so far insert happens with out an issue,
but i cant pass message variable to sqlplus script insert. i have highlighted the variable in red.
thanks in advance.
df -H | grep -vE... (3 Replies)
Discussion started by: LPK
2. Shell Programming and Scripting
$ echo $SHELL
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
$ cat output.sh
.... (7 Replies)
Discussion started by: a1_win
3. Shell Programming and Scripting
I need immediate help in creating shell script to call archivebkup.ksh script when archive file system capacity reaches threshold value or 60%
Need to identify the unique file system that reaches threshold value.
... (4 Replies)
Discussion started by: sasikanthdba
4. Shell Programming and Scripting
I am new to this unix world...I need your help to walk through.
I want to learn shell scripting..... The shell script which can be able to use with oracle pl/sql...
So please suggest me which shell is good.
Which Unix/Linux version is good for this to Install to get practice the... (8 Replies)
Discussion started by: GaneshAnanth
5. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
6. Shell Programming and Scripting
I want to connect to oracle db using unix shell script. And i want to retrieve data from db through shell script.
Please help me as soon as possible.
J.P. Das (1 Reply)
Discussion started by: jyotidas
7. Shell Programming and Scripting
in shell script I have one problem while inserting into oracle table .
while read record
X=`sqlplus -s STN/errrmddb20@MAHFDR <<eof
insert into STN.STN_ERROR_TABLE values($record);
eof`... (12 Replies)
Discussion started by: Gopal_Engg
8. Shell Programming and Scripting
I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB).
I have to create a shell script to execute that procedure for each txt... (5 Replies)
Discussion started by: renatoal
9. Shell Programming and Scripting
For connecting to oracle my script is using the command
sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command
sqlplus... (4 Replies)
Discussion started by: DILEEP410
10. Shell Programming and Scripting
I am new to unix.
I need a shell script to load a datafile in to oracle.
I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table.
Control file : PAY0001.ctl
Datafile : mon_grs_det.dat
log file :... (3 Replies)
Discussion started by: raghuraja_r