Need shell script to extract data from oracle database

frns5 · #1 (**permalink**) 09-22-2008

shell script

jim mcnamara · #2 (**permalink**) 09-22-2008

What extract, from what table?

frns5 · #3 (**permalink**) 09-22-2008

need to extract table

jim mcnamara · #4 (**permalink**) 09-22-2008

You need to get all of the information in a table, into a file, then ftp it somewhere.
I hope this is not an important job thing....

Code:

var='SET HEAD OFF
SET LINES 512
SET FEED OFF
SPOOL t.dat
SELECT * FROM TABLE;
SPOOL OFF
EXIT;
' | sqlplus -s username/password
# remove trailing spaces
sed 's/ $//s' t.txt > newfile.txt
echo "
open remotenodename
USER username password
bin 
put newfile.txt
bye 
" |  ftp -n

frns5 · #5 (**permalink**) 09-22-2008

thanx jim

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Connecting to oracle database from shell script	satyakiran	Shell Programming and Scripting	8	07-03-2009 03:22 PM
extract data from xml- shell script using awk	nishana	Shell Programming and Scripting	5	07-16-2007 09:20 AM
Need Shell Script to upload data from Text file to Oracle database	chandrashekharj	Shell Programming and Scripting	6	03-26-2007 03:21 AM
How to write Flat Files by shell script using Oracle Database	coolbuddy	UNIX for Advanced & Expert Users	3	02-21-2006 02:50 PM
unix script to export data from csv file to oracle database	vinayagan	Shell Programming and Scripting	3	07-20-2005 04:16 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by