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/de...classtopic.asp

"Q. John Chen" <qj****@email.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

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

I am wondering if this works for Oracle.

[Siva M]

"SELECT abc FROM mytable WHERE abe > :ABC"

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

"Q. John Chen" <qj****@email.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
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.