Sponsored Content
Top Forums Shell Programming and Scripting insert values into sqlplus database using shell script Post 302302468 by pradeept on Tuesday 31st of March 2009 05:09:10 AM
Old 03-31-2009
Data 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

Shell Script And SQLPLUS

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

Shell Script: want to insert values in database when update script runs

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

shell script to insert data from gps.txt to mysql database

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

SQLPLUS within shell script

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

sqlplus in shell script

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

Korn shell program to parse CSV text file and insert values into Oracle database

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

Shell script for insert multiple records into a Database

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

Sqlplus in shell script

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

Need help on Insert data to phpMyAdmin mySQL database from Shell Script

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

Intelligent Script to Insert Records in Database Table

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
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)
All times are GMT -4. The time now is 08:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy