What can be a size of a pl/sql block? Is there any limit?




Answers were Sorted based on User's Feedback



What can be a size of a pl/sql block? Is there any limit?..

Answer / pavan_1981

not more 32KB

Is This Answer Correct ?    2 Yes 0 No

What can be a size of a pl/sql block? Is there any limit?..

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 =
'procedure_name'

Is This Answer Correct ?    2 Yes 1 No

Post New Answer




More SQL PLSQL Interview Questions

What are character functions in sql?

0 Answers  


Can function return multiple values in sql?

0 Answers  


how to start mysql server? : Sql dba

0 Answers  


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)?

3 Answers   TCS,


What does pl sql developer do?

0 Answers  






Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,


discuss about myisam index statistics collection. : Sql dba

0 Answers  


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  


What is the differnce between view and materialized view

4 Answers   TCS,


What is union and union all keyword in sql and what are their differences?

0 Answers  


what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,


How do you delete data from a table?

0 Answers  






Categories