What can be a size of a pl/sql block? Is there any limit?
Answers were Sorted based on User's Feedback
Answer / pavan_1981
not more 32KB
|Is This Answer Correct ?||2 Yes||0 No|
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 =
|Is This Answer Correct ?||2 Yes||1 No|
What are the different dml commands in sql?
What are string functions in sql?
Mention what plvcmt and plvrb does in pl/sql?
What is record in pl sql?
Write a query to display the current date in sql?
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
how do you login to mysql using unix shell? : Sql dba
what is definer rights invoke rights?
How can we solve sql error: ora-00904: invalid identifier?
What is the difference between microsoft sql and mysql?
what does myisamchk do? : Sql dba
What is the usage of when clause in trigger?