What can be a size of a pl/sql block? Is there any limit?
- 2 Answers
- 11982 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
What's the difference between inner join and left join?
What are the two types of cursors in pl sql?
what is meant by urlencode and urldocode? : Sql dba
What is the difference between in and between in sql?
What is sql used for?
What is rowid in sql?
what is a join? : Sql dba
Explain the rollback statement?
what is a foreign key ? : Sql dba
What is range partitioning?
Can you have a foreign key without a primary key?
Is sql procedural language?
What is informix sql?
What are procedures used for?
Name three sql operations that perform a sort.
