What can be a size of a pl/sql block? Is there any limit?
Answer Posted / pavan_1981
not more 32KB
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is out parameter used for eventhough return statement can also be used in pl/sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What are the features of pl sql?
What is data type in database?
Is primary key clustered or nonclustered?
What is orm in sql?
what is try_catch block in procedure
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...
how to analyze tables with 'mysqlcheck'? : Sql dba
What are data types in pl sql?
how do you control the max size of a heap table? : Sql dba
What is the purpose of primary key?
Why do we need view in sql?
Does truncate remove indexes?
What are different types of triggers?