Database Topics
ORA-00936: missing expression
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 be verified in the Oracle SQL query, and the missing
ORA-28002: the password will expire within 7 days
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 is set to change the password on a regular basis,
ORA-28001: the password has expired
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 to reset the user password on a regular basis and
ORA-00054: resource busy and acquire with NOWAIT specified or timeout
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 Oracle connections attempt to lock a resource such as a
ORA-12514, TNS:listener does not currently know of service requested in
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 connecting to the database.The service name you used to connect
ORA-00979: not a GROUP BY expression
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. The GROUP BY clause must be specified for any SELECT
ORA-12505, TNS:listener does not currently know of SID given in
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 to the database.The database connection Sid you used is either
ORA-00933: SQL command not properly ended
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 syntax. The error is thrown when a clause is added
ORA-01722: invalid number
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 or character fields containing numeric data are allowed. Dates may
How to Execute Stored Procedure in Oracle SQL Developer with
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 in SQL Developer with parameters. The value from the stored