Parameterized SQL text for Oracle?

[Q. John Chen]

When using SQL Sever, you can do:
string sql = "SELECT abc FROM mytable WHERE abe > @ABC";

I am wondering if this works for Oracle.

 

[W.G. Ryan eMVP]

Oracle doesn't use the @ to identify a parameter but you can still use named
paramaters.
http://msdn.microsoft.com/library/d...dataoracleclientoracleparameterclasstopic.asp

 

[Siva M]

"SELECT abc FROM mytable WHERE abe > :ABC"

The idea is to use ':' instead of '@'

When using SQL Sever, you can do:
string sql = "SELECT abc FROM mytable WHERE abe > @ABC";

I am wondering if this works for Oracle.

 

[Q. John Chen]

That what I want to know.

I guess the parameter name will be "ABC" without the quote rather than
":ABC."

Thanks

John

 

[Q. John Chen]

Just for people out there see this:

The parameter name is :ABC

Yes, with the column.