SQL Error: ORA-00904: "STP": invalid identifier in Oracle SQL Developer

Viewed 45

I have a simple query that's giving an error.

Does anyone know why this would give an error?

select stp as "Stype"

FROM DAAN.ABC001100;

The error I get is this:

Error starting at line : 1 in command - select stp as "Stype"

FROM DAAN.ABC001100 Error at Command Line : 1 Column : 8 Error report

  • SQL Error: ORA-00904: "STP": invalid identifier
  1. 00000 - "%s: invalid identifier" *Cause:
    *Action:
0 Answers
Related