Database Topics
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. The exception to this is not caused by the error.
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 base objects such as type, package, table, cursor may contain
PLS-00320: the declaration of the type of this expression 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 an error in oracle PL/SQL declaration. When a variable is
PLS-00222: no function with name exists in this scope
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 not permitted. If a variable is declared with a datatype
PLS-00308: this construct is not allowed as the origin of
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 is not permitted. If a variable is declared with a
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the
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 valid literal value. When oracle scans the PL/SQL code while
PLS-00103: Encountered the symbol “BEGIN” when expecting one of the
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 compiles PL/SQL code, it detects the “BEGIN” symbol rather than
PLS-00103: Encountered the symbol “END” when expecting one of 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 literal value. When oracle scans the PL/SQL code while compiling,
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 data dictionary views such as tab, user_tables, all_tables, and dba_tables.
How to limit the number of rows returned by a
There are two approaches to limit the number of rows returned by an Oracle query. Using the rownum value to limit the number of rows, as well as the OFFSET and FETCH keywords to limit the number of rows. The