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
- 13276 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 =
'procedure_name'
| Is This Answer Correct ? | 2 Yes | 1 No |
What are the parameter modes supported by pl/sql?
How One can easily select all even, odd, or Nth rows from a table using SQL queries?
Why is stored procedure faster than query?
What is difference between primary and secondary key?
What are the advantages of VIEW?
Is join and inner join the same?
How do temporal tables work?
Can you have a foreign key without a primary key?
What is sql injection owasp?
How does postgresql compare to "nosql"?
What is foreign key in sql with example?
how to add a new column to an existing table in mysql? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
