Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Combine Unix variable with Oracle variable
aman.oracle.dba wrote:
> Thank You for your responce and this code, but I want to do that in
> reverse mode.
> Means,
> I have one unix variable h.
> I want to store, how many rows in table temp1 in this unix variable
> (h), so that I can use that..........
Sybrand's response is right for you then.
You can also avoid to write a separate SQL script file if you wish:
h="`sqlplus -s username/password << __END__
set feedback off newpage 0 pagesize 0
select count(*) from temp1 ;
exit
__END__
'"
Kind regards,
-- Cris Carampa (spamto:cris119_at_operamail.com) All foreign wars I do proclaim Live on blood and a mother's painReceived on Fri Jun 16 2006 - 05:26:55 CDT