How do I escape a reserved word in Oracle?

by

From a quick search, Oracle appears to use double quotes (", eg "table") and apparently requires the correct case—whereas, for anyone interested, MySQL defaults to using backticks (`) except when set to use double quotes for compatibility.

More Related Contents:

  1. Maximum Number of times we can query an oracle database [closed]
  2. Place to store PL/SQL block [closed]
  3. How to put more than 1000 values into an Oracle IN clause [duplicate]
  4. ORA-30926: unable to get a stable set of rows in the source tables
  5. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  6. Fetch Oracle table type from stored procedure using JDBC
  7. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  8. “Safe” TO_NUMBER()
  9. When or Why to use a “SET DEFINE OFF” in Oracle Database
  10. error: ORA-65096: invalid common user or role name in oracle
  11. Oracle insert if not exists statement
  12. Error : ORA-01704: string literal too long
  13. Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
  14. Oracle client ORA-12541: TNS:no listener [closed]
  15. Reason why oracle is case sensitive?
  16. Create an Excel Spreadsheet from a Oracle Database
  17. How do I turn off Oracle password expiration?
  18. ORACLE IIF Statement
  19. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  20. SQL Fiddle Output Error
  21. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  22. Oracle Age calculation from Date of birth and Today
  23. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  24. How to list active / open connections in Oracle?
  25. ORA-12705: Cannot access NLS data files or invalid environment
  26. jboss 7 oracle datasource configuration
  27. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  28. Why cannot I create triggers on objects owned by SYS?
  29. Query to search all packages for table and/or column
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment