Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Difference between Bind and Lexical parameters?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create tables in apps schema?

1080


List the various types of value set.

1019


In oracle application how do you debug or trace errors?

1047


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2970


How can you achieve loose coupling in soa framework?

1174


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2567


Do you know where we can check the status of po?

1187


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3566


please send me forms, xml pulisher questions,answers

2066


Can you explain the difference between architecture followed in 10g & 11g?

1017


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1061


How to move the one file from one instance to another instance? And your scripts also?

1066


What is sca and how is it useful?

1048


What are the different components of soa suite?

1145


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2573