03-31-2009
insert values into sqlplus database using shell script
hello all,
I am new to shell scripting and to unix... so the following is my assignment..
here i am trying to insert a values into sqlplus database using shell script.
the following is my shell script
InsertDelete.sh
#! /bin/sh
echo "*********The MENU********
1.Insert The Values Into DataBase
2.Delete The Values From DataBase
Enter Your Option:"
read choice
case "$choice" in
1)echo "The Insert Operation"
echo "Enter the Name"
read name
echo "Enter the age"
read age
sqlplus scott/tiger @secondScript.sql;;
2)echo "The Delete Operation";;
*)echo "Invalid Operation";;
esac
and this is my secondScript.sql
DEFINE name=$name
DEFINE age=$age
SPOOL secondScript.lst
SET LINESIZE 100
SET PAGESIZE 50
INSERT INTO PRADEEP_DATA (name,age) VALUES ('&name','&age');
commit
SPOOL OFF
The Problem is the values of name and age, is not passing to the .sql file ?
and when i check the database,
instead of values for name and age
$name and $age is inserting into the database!!
can anyone help me in this regard... ?
thanks in advance !!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;)
I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies
2. Shell Programming and Scripting
Hi ,
I am new to linux and also also to shell scripting.
I have one shell script which unpacks .tgz file and install software on machine.
When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder... (1 Reply)
Discussion started by: ring
1 Replies
3. Shell Programming and Scripting
Hi,
I have gps receiver, by using gpsd data i can read gps log data to my database(my sql).
Steps:
1. telenet localhost 2947 > gps.txt (press enter)
2. r (press enter) //then i will get the data like below in gps.txt file
Trying 127.0.0.1...
Connected to localhost.... (1 Reply)
Discussion started by: gudivada213
1 Replies
4. Shell Programming and Scripting
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
Discussion started by: gaurav_1711
4 Replies
5. Shell Programming and Scripting
Hi
When I use sqlplus in shell script, I get sqlplus: command not found.
ORACLE_HOME is not set. How to set ORACLE_HOME in unix?
Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies
6. Shell Programming and Scripting
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies
7. Shell Programming and Scripting
I have a table in an Informix DB into which I want to insert multiple records at a time. Data for one of the column should be unique & other column data may be the same for all the records I insert
Typical Insert Statement I use to insert one row :
insert into employee(empid, country, state)... (5 Replies)
Discussion started by: nisav
5 Replies
8. Shell Programming and Scripting
Hi All,
Please let me know what i am missing in the following code (part of my script)
Schemas=(AWQM WFCONTROLLER PROVCO PRISM)
for s in "${Schemas}"
do
sch="${s}_$tol"
if || ;then
echo "This is AD or TD region"
sqlplus -s $sch/$tpwd@$ttns <<EOF... (7 Replies)
Discussion started by: pvmanikandan
7 Replies
9. Shell Programming and Scripting
Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my... (4 Replies)
Discussion started by: aoiregion
4 Replies
10. Shell Programming and Scripting
Hello All Members,
I am new to this forum and to the shell scripting. I want to write a shell script to do the following:
Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)
Discussion started by: chetanojha
18 Replies
LEARN ABOUT OSF1
strclean
strclean(8) System Manager's Manual strclean(8)
NAME
strclean - Removes outdated STREAMS error log files
SYNOPSIS
/usr/sbin/strclean [-d logdir] [-a age]
FLAGS
Specifies a maximum age in days for the STREAMS error log files if this not the default age of 3. The value of age must be an integer
greater than or less than 3. Specifies a directory for the location of the STREAMS error log files to be removed if this is not the
default directory /var/adm/streams.
DESCRIPTION
The strclean command cleans the STREAMS error logger directory of log files (error.mm-dd) that contain error messages sent by the STREAMS
log driver (strlog). If no other directory is specified (the logdir argument), the command removes error log files in the /var/adm/streams
directory. If no other age is specified (the age argument), the command removes error log files that have not been modified in 3 days.
The strclean command is executed by the cron daemon on a periodic basis.
EXAMPLES
To remove the day-old error log files from a directory called /tmp/streams, enter: strclean -d /tmp/streams -a 1
FILES
One or more error log file or files on which strclean operates. The mm.dd in the filename indicates the month and day of the messages con-
tained in the file.
RELATED INFORMATION
Commands: strerr(8), cron(8).
Interfaces: strlog(7). delim off
strclean(8)