Answer Posted / thanvi
Both compilation and execution happens at the time.It will be useful where we don't know (the value of col_name or table_name) till runtime.
-Compilation means checks for the syntax.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where is pl sql used?
What is scalar function?
Is join and inner join the same?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How do you modify a trigger?
Is it mandatory for the primary key to be given a value when a new record is inserted?
what are the nonstandard string types? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is not in sql?
does sql support programming? : Sql dba
What is the advantage of nosql?
State few characteristics of pl/sql?
Explain how can you save or place your msg in a table?
What is view? Can we update view
What is cost in sql execution plan?