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...

what is meant by lexical parameter

Answer Posted / jay

Lexical parameters are used to substitute multiple values
at runtime and are identified by a preceding ‘&’. Lexical s
can consist of as little a one line where clause to an
entire select statement

Lexical parameter is a feature used for building a dynamic
query.

Example: An example of a lexical parameter usage in a
select statement is as follows

select *
from emp
where &L_EMP; (Report can assign a value as :L_EMP:=
emp.dept = 20 and salary > 20000)

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

do you know is it possible to run the interface without using oracle apps?

1163


What is oracle soa suite?

1297


What is oracle soa suite and what are its different components?

1281


What are the different components of soa suite?

1264


How many schemas we have? how many you have used?

2109


what are the balancing segments in AR?

2149


What is the concept of soa governance?

1316


How is choreography different from orchestration?

1174


tell me the scenarios of the independent in reports

2656


What are the different components you should consider while defining a responsibility in oracle apps?

1125


Which oracle apps version you are very confident in?

1251


can we get profile values in report without using user exists is it possible how?

2933


How do you register report in oracle apps?

1130


what is the difference between request group and request security in oracle apps?

5974


q)what are the validations in sql*loader

2454