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|
Can you select everything, but 1 or 2 fields, without writer's cramp?
IF i write before / after insert / update trigger and i do rollback what will happen?
How to change sql*plus system settings?
What are variables in pl sql?
How many sql databases can you have on one server?
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
What are the parameter modes supported by pl/sql?
What is the syntax to add a record to a table?
Can you call pl/sql package functions from within a fast formula?
What type of database is sql?
When do we use triggers?
What is the difference between unique and primary key constraints?