#!/bin/sh if [ "$1" = "" ]then	cat << EOFusage:		flat un/pw [tables|views]example:	flat scott/tiger emp deptdescription:	Select over standard out all rows of table or view with 		columns delimited by tabs.EOF	exitfiPW=$1shiftfor X in $*dosqlplus -s $PW << EOF > /tmp/flat$$.sqlset	wrap offset	feedback offset	pagesize 0set	verify offprompt	selectselect	lower(column_name)||'||chr(9)||'from	user_tab_columnswhere	table_name = upper('$X') and	column_id != (select max(column_id) from user_tab_columns where			 table_name = upper('$X'))order by column_id/select	lower(column_name)from	user_tab_columnswhere	table_name = upper('$X') and	column_id = (select max(column_id) from user_tab_columns where			 table_name = upper('$X'))order by column_id/prompt	from	$Xprompt	/prompt	exitexitEOFsqlplus -s $PW << EOFset	wrap offset	feedback offset	pagesize 0set	verify offset trimspool onset linesize 5000start /tmp/flat$$.sqlexitEOFrm /tmp/flat$$.sqldone