Monday, July 5, 2010

ERROR.sql

  1. ORA-00903: invalid table name
  2. ORA-00904: "SMITH": invalid identifier
  3. ORA-00907: missing right parenthesis
  4. ORA-00909: invalid number of arguments
  5. ORA-00911: invalid character
  6. ORA-00920: invalid relational operator
  7. ORA-00923: FROM keyword not found where expected
  8. ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
  9. ORA-00933: SQL command not properly ended
  10. ORA-00936: missing expression
  11. ORA-00938: not enough arguments for function
  12. ORA-00939: too many arguments for function
  13. ORA-00942: table or view does not exist
  14. ORA-00972: identifier is too long
  15. ORA-00979: not a GROUP BY expression
  16. ORA-01031: insufficient privileges
  17. ORA-01400: cannot insert NULL into ("A"."BRANCH_MSTR"."BRANCH_N")
  18. ORA-01481: invalid number format model
  19. ORA-01722: invalid numbers
  20. ORA-01756: quoted string not properly terminated
  21. ORA-01785: ORDER BY item must be the number of a SELECT-list expression
  22. ORA-01820: format code cannot appear in date input format
  23. ORA-01830: date format picture ends before converting entire input string
  24. ORA-01840: input value not long enough for date format
  25. ORA-01843: not a valid month
  26. ORA-01847: day of month must be between 1 and last day of month
  27. ORA-01854: julian date must be between 1 and 5373484
  28. ORA-02263: need to specify the datatype for this column
  29. ORA-30001: trim set should have only one character
  30. ORA-04043: object test does not exist
  31. ORA-06502: PL/SQL: numeric or value error: character string buffer too smallness
  32. .......................................................................................

No comments:

Post a Comment