Compress while wrting to a file using a unix pipe

booyena1 · #1 (**permalink**) 10-25-2005

I would like to know if the following can be done.

route output from an sql select directly to a pipe and compress it at the same time.

regards
Albert

jim mcnamara · #2 (**permalink**) 10-25-2005

Oracle example:

Code:

# file = sql.sh
sqlplus -s username/passwd <<EOF
select count(*) from uzrutrf;
exit
EOF

usage

Code:

sq.sh | compress > sql.Z

booyena1 · #3 (**permalink**) 10-26-2005

Thanks Jim you are a star

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
unix script to takes the old data from a TXT file and compress them into new file	vpandey	Shell Programming and Scripting	2	03-05-2008 11:10 AM
splitting a pipe delimited file in unix	ddedic	Shell Programming and Scripting	4	03-20-2007 01:16 AM
compress a file in unix	rujupriya	UNIX for Dummies Questions & Answers	5	05-24-2006 09:05 AM
Compress in Unix	Sasuke	UNIX for Dummies Questions & Answers	1	10-10-2003 08:18 AM
Unix compress-Wintel uncompress	rampart1	UNIX for Advanced & Expert Users	3	09-07-2003 05:33 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