Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query?
e.g.
echo "enter value"
read value
insert into tablename where col=$value /*something like this*/
Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query?
e.g.
echo "enter value"
read value
insert into tablename where col=$value /*something like this*/
Yes you can..and search this forum you will find more similar to this.
#!/bin/ksh
echo "enter value"
read value
sqlplus -s uname/passwd@DBSID <<EOF
set feedback off;
insert into tablename where col=$value /*something like this*/
exit;
EOF