OraFAQ Forum: Precompilers, OCI & OCCI » shell script for sql queries

Home » Developer & Programmer » Precompilers, OCI & OCCI » shell script for sql queries (9.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

shell script for sql queries [message #321755]

Wed, 21 May 2008 04:30

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.

Report message to a moderator

Re: shell script for sql queries [message #321759 is a reply to message #321755]

Wed, 21 May 2008 04:34

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why is this in "Precompilers, OCI & OCCI" forum?

Regards
Michel

Report message to a moderator

Re: shell script for sql queries [message #321763 is a reply to message #321759]

Wed, 21 May 2008 04:44

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....

Report message to a moderator

Re: shell script for sql queries [message #321776 is a reply to message #321759]

Wed, 21 May 2008 05:17

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.

Report message to a moderator

Re: shell script for sql queries [message #321790 is a reply to message #321759]

Wed, 21 May 2008 05:54

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 08:23:44 CDT 2025