Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: hi alll......How can i connect to oracle9i db and fetch the data from specific tables using shell script
mahesh wrote:
> Hi allll,
> I'm new to shell scripting. and i want to fetch the data
> from oracle 9i database in some shell
> script variables.So how can i proceed.
> Thanks in advance.
>
>
>
> Thanks and Regards
> mahesh
If you know Unix shell scripting, you must be aware you can use <env var>=`sqlplus username/password_at_service @script`
provided you have
set newpage 0 pagesize 0 feedback off
in your script.
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Dec 05 2006 - 00:49:45 CST