Re: bsh => pl/sql

["Tom Metro-12" <user=71@nabble.blu.org>]

 Eric Chadbourne wrote: 
> ...how could I combine them into one? 
> 
> VAR1="$1" 
> VAR2="$2" 
> ... 
> /some/path/here/sqlplus $USR/$PASSWORD@ID 

Does sqlplus accept SQL via STDIN? If so, you can echo the statements 
and pipe them to the command or use heredoc syntax. 

If you want to see a very large bash script that interacts with MySQL in 
this way, have a look at mythnuv2mkv: 
http://web.aanet.com.au/auric/?q=node/6

  -Tom 

-- 
Tom Metro 
Venture Logic, Newton, MA, USA 
"Enterprise solutions through open source." 
Professional Profile: http://tmetro.venturelogic.com/

-- 
This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. 

_______________________________________________ 
Discuss mailing list 
[hidden email] 
http://lists.blu.org/mailman/listinfo/discuss