What can be a size of a pl/sql block? Is there any limit?
Answers were Sorted based on User's Feedback
Answer / pavan_1981
not more 32KB
|Is This Answer Correct ?||2 Yes||0 No|
Answer / akshata kamat
The maximum parsed/compiled size of a PL/SQL block is 64K
and the maximum code size is 100K.You can run the following
select statement to query the size of an existing package or
procedure. SQL> select * from dba_object_size where name =
|Is This Answer Correct ?||2 Yes||1 No|
What are character functions in sql?
Can function return multiple values in sql?
how to start mysql server? : Sql dba
what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?
What does pl sql developer do?
Can we use the cursor's to create the collection in PL/SQL?
discuss about myisam index statistics collection. : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is the differnce between view and materialized view
What is union and union all keyword in sql and what are their differences?
what is the use of HASH, LIST partitions?
How do you delete data from a table?