Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

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

How is indexing done in search engines?

0 Answers  

Is sql a case sensitive language?

0 Answers  

What is the example of procedure?

0 Answers  

Can we edit a view in sql?

0 Answers  

What are two virtual tables available during database trigger execution ?

2 Answers  

How does postgresql compare to "nosql"?

0 Answers  

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

what is normalization? : Sql dba

0 Answers  

What is a sql schema used for?

0 Answers  

What is delimiter sql?

0 Answers  

What is trigger and how to use it in sql?

0 Answers  

Why are aggregate functions called so?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories