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
- 13230 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
Why is a primary key important?
What do you mean by stored procedures? How do we use it?
What is sap sql?
Is sql easier than java?
What is the difference between nested table and varray?
What is string join?
Can instead of triggers be used to fire once for each statement on a view?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
what is cursor. write example of it. What are the attributes of cursor.
Which is better stored procedure or query?
What is the advantage of nosql?
What is the use of %rowtype?
What is difference between stored procedure and trigger?
What is full form of rtm?
What is dynamic sql in pl sql?
