0

How could I write this "SELECT COLUMN, * FROM TABLE" in Oracle. I don't have any problem when I use that syntax on Sql Server or MySQL, but on Oracle appears the message "ORA-00936"

Oracle DataBase

SELECT COLUMN, * FROM TABLE 

ORA-00936
Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
Brian
  • 3
  • 1
  • 2

1 Answers1

4

Alias the column name and the '*'

MPOWEL01> Select empid empno, a.* from t1 a;

 EMPNO      EMPID CORR_ACTION_TYPE CORR_ACTI

  7654       7654              123 18-FEB-19
  7654       7654              456 07-APR-19
  7654       7654              789 07-MAY-19
  7521       7521              123 10-MAR-19
  7521       7521              256 18-JUN-19

5 rows selected.

Mark D Powell
  • 184
  • 2