drop table my_table purgeORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table my_table as select table_name from all_tables where rownum <= 10Table created.
select * from my_table| TABLE_NAME | DUAL | USER_PRIVILEGE_MAP | SDO_CS_CONTEXT_INFORMATION | DR$THS | DR$THS_PHRASE | DR$NUMBER_SEQUENCE | SALES | SDO_ST_TOLERANCE | SDO_PROJECTIONS_OLD_SNAPSHOT | SDO_ELLIPSOIDS_OLD_SNAPSHOT |
|---|
with
my_table as
(
select dummy from dual
)
select *
from my_table | DUMMY | X |
|---|
with
mytable as
(
select dummy from dual
)
select *
from my_table | TABLE_NAME | DUAL | USER_PRIVILEGE_MAP | SDO_CS_CONTEXT_INFORMATION | DR$THS | DR$THS_PHRASE | DR$NUMBER_SEQUENCE | SALES | SDO_ST_TOLERANCE | SDO_PROJECTIONS_OLD_SNAPSHOT | SDO_ELLIPSOIDS_OLD_SNAPSHOT |
|---|