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 |
How to convert a date to char in oracle? Give one example.
what is primary key?
How can we find the size of a database?
What is the difference between $oracle_base and $oracle_home?
What is Undo Management Advisor in Oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain what are the characteristics of data files?
How to call a trigger inside a stored procedure?Give an example.
Can a formula column be obtained through a select statement ?
What are the various constraints used in oracle?
What does ROLLBACK do ?
What is catalog in Oracle?