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.

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

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

Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers   TCS,

---

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

---

wht r the basetables of customer interface?

2 Answers  

---

What is a flexfield? List out its types.

0 Answers  

---

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

---

what are the error tables in AP?

6 Answers  

---

link between po and ap modules

5 Answers   ERP Solutions,

---

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

---

how to customize the report,please tell me customization steps

5 Answers   Accenture,

---