Interested to Buy Any Domain ? << Click Here >> for more details...
What can be a size of a pl/sql block? Is there any limit?
- 2 Answers
- 13382 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 is the best sql course?
What is the use of sqlerrd 3?
What are the two types of cursors in pl sql?
How do you modify a column in sql?
what is 'mysqld'? : Sql dba
What is the difference between left and left outer join?
What is an escape character in sql?
Differentiate between syntax and runtime errors.
What are instead of triggers?
how do you control the max size of a heap table? : Sql dba
What is clustered index sql?
What types of commands can be executed in sql*plus?
Is grant a ddl statement?
How to combine two stored procedures in sql?
what is a database lock ? : Sql dba
