What can be a size of a pl/sql block? Is there any limit?
- 2 Answers
- 12226 Views
- I also Faced
- E-Mail Answers
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
how to analyze tables with 'mysqlcheck'? : Sql dba
What is varchar sql?
Is join same as left join?
What is a constraint? Tell me about its various levels.
How can you create an empty table from an existing table?
How would you pass hints to the sql processor?
How can the performance of a trigger be improved?
what are integrity rules?
Why do we create views in sql?
What is foreign key and example?
How to run pl sql program in mysql?
Explain the the delete statements in sql?
What is sharding in sql?
How to change the order of columns in Oracle SQL Plus ?
Name the operator which is used in the query for pattern matching?
