Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: hi alll......How can i connect to oracle9i db and fetch the data from specific tables using shell script

From: sybrandb <sybrandb_at_gmail.com>
Date: 4 Dec 2006 22:49:45 -0800
Message-ID: <1165301385.865350.38720@80g2000cwy.googlegroups.com>

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 DBA
Received on Tue Dec 05 2006 - 00:49:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US