Author: Dev

ORA-30483: window functions are not allowed here Oracle PL/SQL error message: ORA-30483: window functions are not allowed here. Cause: Window functions are allowed only in the SELECT list of a query. A window function cannot be a group function. Solution: Correct the syntax, then retry the operation. Course table COURSE_ID NAME PRICE 1 SQL 1…(Continue Reading)

ORA-01481: invalid number format model Oracle PL/SQL error message: ORA-01481: invalid number format model. Cause: An invalid format parameter was used with the TO_CHAR or TO_NUMBER function. Solution: Correct the syntax, then retry the operation. Example 1: SELECT TO_NUMBER(SYSDATE,’HH24′) FROM DUAL; Output: ORA-01481: invalid number format model Correct: SELECT TO_CHAR(SYSDATE,’HH24′) FROM DUAL; Output: 10 Oracle…(Continue Reading)

ORA-30076: invalid extract field for extract source Oracle PL/SQL error message: ORA-30076: invalid extract field for extract source. Cause: The extract source does not contain the specified extract field. Solution: Specify a valid extract field for the extract source. Example 1: SELECT EXTRACT (HOUR FROM SYSDATE) FROM DUAL; Output: ORA-30076: invalid extract field for extract…(Continue Reading)

ORA-01818: ‘HH24’ precludes use of meridian indicator Oracle PL/SQL error message: ORA-01818: ‘HH24’ precludes use of meridian indicator. Cause: A date specification contained both a 24-hour time format code and a meridian indicator code. If hours are specified using the 24-hour time format (HH24), a meridian indicator, AM or PM, may not be specified. Solution:…(Continue Reading)

ORA-01830: date format picture ends before converting entire input string Oracle PL/SQL error message: ORA-01830: date format picture ends before converting entire input string. Cause: A valid date format picture included extra data. The first part of the format picture was converted into a valid date, but the remaining data was not required. Solution: Check…(Continue Reading)