How to use the ‘as’ keyword to alias a table in Oracle?

by

You can use AS for table aliasing on many SQL servers (at least MsSQL, MySQL, PostrgreSQL) but it’s always optional and on Oracle it’s illegal.

So remove the AS :

SELECT G.Guest_ID, G.First_Name, G.Last_Name
FROM Guest G

More Related Contents:

  1. ORA – 00933 confusion with inner join and “as”
  2. SQL Command not properly ended?
  3. Receive an unexpected symbol error in my PLSQL query [closed]
  4. SQL Query to concatenate column values from multiple rows in Oracle
  5. Select First Row of Every Group in sql [duplicate]
  6. Oracle: how to UPSERT (update or insert into a table?)
  7. Get top results for each group (in Oracle)
  8. Comparing Dates in Oracle SQL
  9. Oracle Differences between NVL and Coalesce
  10. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  11. Is it possible to output a SELECT statement from a PL/SQL block?
  12. Oracle SQL, concatenate multiple columns + add text
  13. Oracle query to fetch column names
  14. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  15. SQL Error: ORA-01861: literal does not match format string 01861
  16. Determine Oracle null == null
  17. How to anticipate and escape single quote ‘ in oracle
  18. Oracle insert if row does not exist
  19. SELECT INTO using Oracle
  20. Display names of all constraints for a table in Oracle SQL
  21. `show create table` equivalent in oracle sql
  22. Does ‘Select’ always order by primary key?
  23. Query json dictionary data in SQL
  24. ORA-00972 identifier is too long alias column name
  25. How to insert a string which contains an “&”
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. Retrieve Oracle last inserted IDENTITY
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Why are aggregate functions not allowed in where clause
  30. Insert into from CTE

Leave a Comment