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 lexical and bind varible.



Difference between lexical and bind varible...

Answer / Munesh Singh

In Oracle D2K, there are two types of variables: Lexical Variables and Bind Variables. Lexical variables are static variables that have a fixed value throughout the program, and they are declared at the time of creation. On the other hand, bind variables are dynamic variables whose values can be changed during runtime by the user. The main difference lies in their scope and lifetime: lexical variables have a global scope while bind variables have a local scope.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle D2K Interview Questions

What are the system variables can be set by users? Explain them

1 Answers  


What is oracle d2k?

1 Answers  


how can you pass values to-and-fro from foreign function?

1 Answers  


Have you used lexical parameters in reports?

0 Answers  


Explain how to convert a report into excel sheet.

1 Answers  


What are the new features in release 11i?

1 Answers  


Difference between lexical and bind varible.

1 Answers  


What is oracle forms system.currentblock?

1 Answers  


how to dynamically change the page size of d2k reports?

1 Answers  


Explain the use of dde package in d2k.

1 Answers  


How to get / select the nth row from the table?

1 Answers  


How is mapping of name of dll and function done?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)