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
- 13257 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 inner join in sql?
What is the use of desc in sql?
Is mariadb nosql?
Is t sql a programming language?
What is the least restrictive isolation level? : Transact sql
What is autocommit sql?
What is t-sql? : Transact sql
how to drop an existing index in mysql? : Sql dba
What does count (*) do in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Where can I learn sql for free?
How to know the last executed procedure?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Which version of sql do I have?
How many times can we commit in a loop?
