SQL in shell script

Shell Programming and Scripting
1

Hi,

I am able to insert the values into a database table from a flat file using SQL loader. Now can I do the same using only shell script.Can this be done without using sql loader and only with shell scripting(ie use of awk). Please put some light on this.

Thanks in advance

2

There is no such direct option. What you can do is you can use a UTL file utility and go for insert. You can not do insert directly.. You can also make use of passing values as parameter to SQL insert but tht required lots of coding as reading line assigning each values in a varible and then pass it to ur sql function which is not recomended..

As far my opinion goes use either SQl-Loader or UTL pacakage..

3

Ifyou want to create a lot of 'INSERT INTO table values (,....); statements;' you do what you want as well.

However, sqlldr is the most efficient way Oracle provides, according to the doc set.

4

SQL LOADER or if you are using 9i or above external tables