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

How do we tune the code?

2 Answers  


What are the various levels of constraints?

0 Answers  


What is database sql?

0 Answers  


what is data integrity

3 Answers   Fidelity, TCS,


Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  


how to connect oracle in unix prompt?

4 Answers   Polaris,


What is union and union all keyword in sql?

0 Answers  


What is procedure and function in sql?

0 Answers  


What does an inner join do?

0 Answers  


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  


Explain what is sql*plus?

0 Answers  


Categories