SQL: Oracle - Parameters in query

Question

im trying to use the vs2008 query builder to create a query with a parameter. i know that in sql server it would work with: select col1,col2 from tbl where col3=@myParam

how would it be typed in oracle or is it pl/sql? i get the problem in the @myParam part.

Answer 1

Oracle SQL parameters are specified using ':'

SELECT col1, col2 FROM tbl WHERE col3=:myParam

You'll have to be careful when specifying this in an OracleParameter though, as some libraries miss off the :, and some require it to bind correctly.