How can i assign an select statement into a variable?

rdhanek · #1 (**permalink**) 09-09-2009

I am trying to assign an select statement into a variable. Can someone hel me with this.

Code:

example :
a='select * from dual'
 
echo $a should give me select * from dual

Franklin52 · #2 (**permalink**) 09-09-2009

Quote the variable:

Code:

a='select * from dual'
 
echo "$a"

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
using SELECT sql statement in shell script	hcclnoodles	Shell Programming and Scripting	4	06-18-2009 05:19 AM
::select statement return value with correct field size::	ryanW	Shell Programming and Scripting	10	04-23-2009 03:38 AM
Oracle Select IN statement	benefactr	UNIX and Linux Applications	1	03-26-2009 04:15 PM
Want to use the output of Select statement in Unix script	akhilgoel9	Windows & DOS: Issues & Discussions	4	05-27-2005 10:52 AM
Pipe SQL select statement results to script	houtakker	UNIX for Dummies Questions & Answers	6	10-31-2003 01:20 PM

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