Database

PLS-00172: string literal too long error occurs when an Oracle PL/SQL code contains a string literal that exceeds the maximum allowed character length of 32767. The Oracle PL/SQL code includes…

ORA-01704: string literal too long error occurs when a string literal with more than 32767 characters is used in an Oracle SQL query. Oracle supports string literals with a maximum…

ORA-00928: missing SELECT keyword error occurs when the select or values keyword is missing in the insert statement. If the SELECT keyword is missing while creating a view, the “ORA-00928:…

ORA-02291: integrity constraint violated – parent key not found error occurs when a foreign key value in the child table does not have a matching primary key value in the…

ORA-02449: unique/primary keys in table referenced by foreign keys error occurs when you try to drop the parent table without removing the foreign key in a parent-child relationship established between…

ORA-02286: no options specified for ALTER SEQUENCE error happens when you attempt to alter a sequence without supplying any parameters, or when you give incorrect parameters. The sequence options are…

When to use a semicolon or a slash in Oracle SQL? It’s difficult to know when to use a semicolon and when to use a slash in Oracle script. Oracle…

How to Execute Stored Procedure in Oracle SQL Developer with Parameters The Oracle PL/SQL code block’s IN and OUT parameters / arguments can be used to execute the stored procedure…

ORA-01722: invalid number error occurs when attempting to convert a number from a character string that is not a valid numeric literal. In arithmetic functions or expressions, only numeric fields…

ORA-00933: SQL command not properly ended error occurs when an Oracle SQL command is ended with an inappropriate clause. The DML commands INSERT, UPDATE, DELETE, and SELECT should use oracle’s…

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor error occurs when the listener cannot find any matched SID with the provided SID, preventing it from connecting…

ORA-00979: not a GROUP BY expression error occurs when the Oracle SQL GROUP BY clause does not contain all of the expressions specified in the SELECT clause of the SQL.…

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor error occurs when the listener cannot find any matched service with the provided service name, preventing it from…

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired error occurs when you try to lock a resource that is already locked and busy with execution. If two…

ORA-28001: the password has expired error occurs when the Oracle user account password expires and the user attempts to login to the account. If the password expiry policy is set…

ORA-28002: the password will expire within 7 days error occurs when the Oracle user password is about to expire and the password needs to be changed. If the user profile…

ORA-00936: missing expression error occurs when a required part of a clause or expression in the Oracle SQL query is omitted or incomplete. The syntax of the missing expression should…

The error ORA-08004: sequence MYSEQUENCE.NEXTVAL exceeds MAXVALUE and cannot be instantiated occurs when the sequence NEXTVAL returns a value that is greater than the sequence maximum value. The sequence’s next…

ORA-08002: sequence MYSEQUENCE.CURRVAL is not yet defined in this session error occurs If you call the CURRVAL of a sequence that doesn’t have a last value. The NEXTVAL of the…

The ORA-02289: sequence does not exist error occurs when the sequence does not exist, the sequence name is wrong, or the user does not have the necessary permissions to execute…