What can be a size of a pl/sql block? Is there any limit?
Answer Posted / 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 View All Answers
What does pl sql stand for?
How can you load multi line records? : aql loader
What are the different types of database management systems?
What are triggers and its types?
What operating systems are supported by oracle sql developer?
Name three sql operations that perform a sort.
How to combine two stored procedures in sql?
What is a ddl command?
what is difference between delete and truncate commands? : Sql dba
Why we use joins in sql?
Is sql dba a good career? : SQL DBA
Why commit is not used in triggers?
What is the use of sqlerrd 3?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What sql does db2 use?