Difference between Bind and Lexical parameters?
- 3 Answers
- 34653 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / oracleapps_learner
BIND VARIABLE :
-- are used to replace a single value in sql, pl/sql
-- bind variable may be used to replace expressions in
select, where, group, order by, having, connect by, start
with cause of queries.
-- bind reference may not be referenced in FROM clause (or)
in place of reserved words or clauses.
LEXICAL REFERENCE:
-- you can use lexical reference to replace the clauses
appearing AFTER select, from, group by, having, connect by,
start with.
-- you can?t make lexical reference in a pl/sql statmetns.
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / alladi venkateswarlu
1)BIND PARAMETERS ARE USED TO PASS NUMERIC VALUES TO THE
QUERY AT RUN TIME.INCLUDING DATE TYPE ALSO
LEXICAL PARAMETERS ARE USED TO PASS ANY TYPE OF
PARAMETERS.
2)BIND PARAMETERS ARE STARTED WITH :(COLON) SYMBOL
WHERE LEXICAL PARAMETERS START WITH &(AMPERSAND) SYMBOL
3)BIND PARAMETERS ARE USED IN ANY CLAUSE(SELECT,ORDER
BY,GROUP BY,..) OTHER THAN FROM CLAUSE IN THE QUERY
WHERE AS LEXICAL PARAMETERS ARE USED IN ALL CLAUSES EVEN
IN FROM CLAUSE
4)BIND PARAMETERS AE USED IN BOTH SQL AND PL/SQL
WHERE LEXICAL PARAMETERS ARE USED IN ONLY SQL
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sam
Bind references are used to replace a single value in SQL
or PL/SQL. 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 used in a FROM clause.
An example is:
SELECT ORDID,TOTAL
FROM ORD
WHERE CUSTID = :CUST
Lexical references are placeholders for text that you embed
in a SELECT statement, when you want the parameter to
substitute multiple values at runtime. 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 PL/SQL.
Before you reference a lexical parameter in a query you
must have predefined the parameter and given it an initial
value.
An example is:
SELECT ORDID, TOTAL
FROM &ATABLE
| Is This Answer Correct ? | 8 Yes | 6 No |
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
how to change the logo in template dynamically?
What is the concept of soa governance?
what is meant by anchoring?
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
Can u give the Documentation of Custom.pll in oracle apps
What is workflow?Explain with a example?
How many parameters we can pass through pl/sql program in Oracle apps
what are the different types of triggers in reports
how to find the custom directory in front end.
1 Answers IBM, Sierra Atlantica,
Oracle Apps Technical 
