Shell Programming and Scripting

Hi all,

I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data from data base
3. how to process the data retrieved from database (i.e result set)
4. how to update the data base in turn.

Please help me out in solving this.

Thanks in advance

sincerely
satya

1. how to connect to the data base(oracle) using shell script
Look at this post

2. how to retrieve data from data base
Post

3. how to process the data retrieved from database (i.e result set)
Post

4. how to update the data base in turn.
Post

Use the search to look through previous postings. They could help.

Vino

Hi,

Like in windows we click the pl/sql icon and we write our code or any sql query to execute.Like wise how to write in unix environemnt and execute .

Hope someone will help me out.

Thanks ...

Hi,

Suppose u hav written a script for scheduling job using "crontab",and u r doing ur job.
But according to requirement u need to change the execution of that job to some other time.What is the solution of that.

Actually in an interview someone asked me.I told ,i will change value for time in the crontab.

Waiting for ur reply...

Thanks ....

First set up the oracle environment variables, normally by . oraenv or similar.

Code:

$ORACLE_HOME/bin/sqlplus

I want to know in details that what exactly we need to do to connect , retrieve and to work around the data.

I have seen several reply but no one makes me satisfied .
Please definitive.

sqlplus -s Username/Password@schemaname