difference between bind variable and variable

Question Posted / nishi.swain@gmail.com

difference between bind variable and variable..

Answer / ravi gali

bind variables created in SQL prompt for testing purpose

variable created inside the prcedures/functions/packages...
etc

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

What are different Oracle database objects?

What is set operator oracle?

Explain what are the uses of rollback segment?

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

What is the relation of a user account and a schema in oracle?

How to retrieve values from data fields in record variables?

who is the father of oracle and send chodd rules

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

Difference between cartesian join and cross join?

After using set unused can we enable the column again to use? Please give me some answers....

Explain the difference between a procedure and a function?

What is merge in oracle?

For more Oracle General Interview Questions Click Here