Bind Parameters:
Bind references (or bind variables) are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH clauses of queries. Bind references may not be referenced in FROM clauses or in place of reserved words or clauses. You create a bind reference by entering a colon (:) followed immediately by the column or parameter name. If you do not create a column or parameter before making a bind reference to it in a SELECT statement, Report Builder will create a parameter for you by default.
Lexical Parameters:
Lexical references are placeholders for text that you embed in a SELECT statement. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH. You cannot make lexical references in a PL/SQL statement. You can, however, use a bind reference in PL/SQL to set the value of a parameter that is then referenced lexically in SQL.
Recent Comments
- The Journey into DevOPS as a Mindset, not a Project – Mark Reynolds on List of AIM Documents
- Nirabhra Das on CONCSUB Utility – Run Oracle Apps Concurrent Program from OS Level
- Adi Setio Nugroho on How to Solve Concurrent Program Output Post Processor(OPP) Issue in R12
- Santosh Mishra on How and When COGS account hit for transactions
- Santosh Mishra on How and When COGS account hit for transactions
Latest Posts
- How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
- AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
- R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am
- How to Find Duplicate Row in OAF Page?April 26, 2017 - 5:17 pm
- How to Create DBC file in oracle apps R12 EBS?March 15, 2017 - 2:54 pm
Leave a Reply
Want to join the discussion?Feel free to contribute!