Posted On: Feb 22, 2018
As of now a compiled/ parsed block of PL/SQL has a maximum size limitation of 64K and max. code size being 100K. The statement for querying existing procedure or the package size is as follows:
SQL> select * from dba_object_size where name = 'procedure_name'
Never Miss an Articles from us.
Oracle is a database server that is used to handle data in a structured manner. It lets its users to retrieve and to st..
An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit...
Each operating Oracle database is associated with an Oracle instance. As soon as a database server starts the database,..