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…
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…
The PLS-00103: Encountered the symbol “END” when expecting one of the following: error occurs when the keyword “END” is encountered when the PL/SQL code is expected to have a valid…
The PLS-00103: Encountered the symbol “BEGIN” when expecting one of the following: error occurs when the keyword “BEGIN” is encountered due to an error just before BEGIN keyword. When Oracle…
The error PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following occurs when oracle encounters the end of file while the PL/SQL code is expected to have a…
The PLS-00308: this construct is not allowed as the origin of an assignment error occurs when an index is used to change the value of a variable on which indexing…
The PLS-00222: no function with name exists in this scope oracle error occurs occurs when an index is used to change the value of a variable on which indexing is…
The PLS-00320: the declaration of the type of this expression is incomplete or malformed error occurs when a variable declaration is missing, incomplete, malformed, or incorrect, or when it throws…
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…
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.…
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 – 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…
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 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 error occurs when the not null variable is assigned a null value or when the assigned numeric value is greater than the allowed numeric…
ORA-06502: PL/SQL: numeric or value error: character string buffer too small error occurs when the length of the character string exceeds the length of the declared character type variable,. The…
ORA-06502: PL/SQL: numeric or value error: character to number conversion error occurs when a character value is assigned to a numeric variable in the oracle PL/SQL code. When a non-numeric…
ORA-06502: PL/SQL: numeric or value error: number precision too large error occurs when the numeric value exceeds the declared numeric data type size. The number of digits in the value…
ORA-01788: CONNECT BY clause required in this query block error occurs when a query is created without a CONNECT BY clause and attempts to access the sql query’s pseudo column…
ORA-30009: Not enough memory for CONNECT BY operation error occurs when the memory size was not sufficient to process all the levels of the hierarchy specified by the query. The…
PLS-00215: String length constraints must be in range (1 .. 32767) error occurs when the varchar2 datatype length is not set or an invalid length is specified in the string…