Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  


IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,


How to change sql*plus system settings?

0 Answers  


What are variables in pl sql?

0 Answers  


How many sql databases can you have on one server?

0 Answers  






what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,


What are the parameter modes supported by pl/sql?

0 Answers  


What is the syntax to add a record to a table?

0 Answers  


Can you call pl/sql package functions from within a fast formula?

0 Answers  


What type of database is sql?

0 Answers  


When do we use triggers?

0 Answers  


What is the difference between unique and primary key constraints?

0 Answers  






Categories