Home » Infrastructure » Unix » Need a shell script for sql query with into clause
Need a shell script for sql query with into clause [message #257402] Wed, 08 August 2007 04:50 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi ,

How to write a shell script for query which is having into clause.

select date1,date2,date3 into v1,v2,v3 from tab1;

v1,v2,v3 is an output that shellscript should produce.

Thanks in advance

Report message to a moderator

Re: Need a shell script for sql query with into clause [message #257435 is a reply to message #257402] Wed, 08 August 2007 06:35 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
v1,v2,v3 is an output that shellscript should produce.


Do you mean that output should be in these variables?
Do you mean these are shell variables? or are they PL/SQL variables?
What shell do you use?

Regards
Michel

Report message to a moderator

Previous Topic: Convert Unix time
Next Topic: Display 256 problem !!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 04:13:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.