Get a List of all Tables In Oracle

How to show all tables in Oracle? Oracle offers a list of all tables using data dictionary. To get a list of all tables in an Oracle database, use the…

PLS-00302: component must be declared

The PLS-00302: component must be declared error occurs when the component of an object is used in the PL/SQL code but not declared in the oracle database object. The data…

ORA-06550: line n column m

The ORA-06550: line n column m error happens as part of another exception stack, which displays the line and column numbers where the error happened in the oracle PL/SQL code.…

PLS-00201: identifier must be declared

The PLS-00201: identifier must be declared error happens when the identifier is used without being declared in the PL/SQL code. Oracle Variables and other identifiers must either be declared or…

DBMS_OUTPUT.PUT_LINE not printing

DBMS_OUTPUT.PUT_LINE not printing – The dbms_output.put_line command is used to print the output of PL/SQL code in the console window in oracle sql developer and sql plus. The dbms_output.put_line command…

ORA-06530: Reference to uninitialized composite

The ORA-06530: Reference to uninitialized composite error occurs when an object, LOB, or other composite was referenced as a left hand side without having been initialized. When a reference to…

ORA-06512: at line

ORA-06512 error message specifies the line number where the exception occurred in the oracle code, but not the cause of the exception. When troubleshooting, the ORA 06512 error is really…

ORA-06502: PL/SQL: numeric or value error

ORA-06502: PL/SQL: numeric or value error error occurs when the not null variable is assigned a null value or when the assigned numeric value is greater than the allowed numeric…