SQL> create table bogus (to varchar2(2));
create table bogus (to varchar2(2))
*
ERROR at line 1:
ORA-00904: : invalid identifier
SQL> CREATE TABLE bogus AS
2 SELECT dummy "TO", dummy "FROM" FROM DUAL;
Table created.
SQL> desc bogus
Name Null? Type
----- ----- --------------------------
TO VARCHAR2(1)
FROM VARCHAR2(1)
SQL> select * from bogus;
TO FROM
-- ----
X X
SQL>
I started up SQL Developer to see what the CREATE TABLE statement would be for the BOGUS table:
CREATE TABLE "BOGUS"
("TO" VARCHAR2(1),
"FROM" VARCHAR2(1));
To select from the BOGUS table:
SQL> select "TO", "FROM" from bogus;
TO FROM
-- ----
X X
SQL>
There it is.
No comments:
Post a Comment