SQL: Oracle - Parameters in query SQL: Oracle - Parameters in query sql sql

SQL: Oracle - Parameters in query


Oracle SQL parameters are specified using :

SELECT col1, col2 FROM tbl WHERE col3=:myParam

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