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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Convert Unix time
Next Topic: Display 256 problem !!!
Goto Forum:
  


Current Time: Thu Mar 28 10:14:00 CDT 2024