Re: Oracle's query parameter syntax equivalent to @ in SQL's

On Tue, 03 May 2005 15:19:06 -0700, sunny076 interested us by writing:

> Hi,
>
> I am new to Oracle and wonder if anyone can enlighten me. I am looking
> for the syntax for parameter equivalent to @ in SQL, for example, in
> "SELECT * FROM EMPLOYEES WHERE EmpID = @EmpID".
>
> Thank you in advance,
>
> Sunny

That syntax is dependant on the tool / environment you use.

Please tell us a bit more - are you using SQL*Plus or some other DB access language? (If SQL*Plus, I highly recommend reading the SQL*Plus User's Manual, as there are literally hundred of neat things you can do! It's available at http://docs.oracle.com)

/Hans

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***