Home » Developer & Programmer » Precompilers, OCI & OCCI » shell script for sql queries (9.0.4.0)
shell script for sql queries [message #321755] Wed, 21 May 2008 04:30 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi All,

I have written 4 sql queries. Now I want to write Shellscripting for these queries (All queries hould mentioned in only one shell scripting file.). Can any one please help me in this issue.

1. select * from emp;
2. select * from dept;
3. delete from emp;
4. delete from dept;
these are the queries..
Thank you.
Re: shell script for sql queries [message #321759 is a reply to message #321755] Wed, 21 May 2008 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why is this in "Precompilers, OCI & OCCI" forum?

Regards
Michel
Re: shell script for sql queries [message #321763 is a reply to message #321759] Wed, 21 May 2008 04:44 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
I am not sure where I have to post this Thread.... excuse me....
So i have posted here....
Re: shell script for sql queries [message #321776 is a reply to message #321759] Wed, 21 May 2008 05:17 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
michel,

I have created pro*c file(.pc) . now I want to convert .pc file to .sh (shell script). SO please let me know how it is ?

Thank you.
Re: shell script for sql queries [message #321790 is a reply to message #321759] Wed, 21 May 2008 05:54 Go to previous message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Michel ,

I have created .sql script in unix.this script contains 4 sql queries. Now I want to craete .sh file based on .sql script. So please let me know the steps to craete .sh file

Thank you.
Previous Topic: how to write PRO*C program for SQL queries
Next Topic: PLS-S-00201, identifier 'TABLE' must be declared
Goto Forum:
  


Current Time: Thu Mar 28 13:52:55 CDT 2024