it should be...
create table DEF as (select * from ABC);
Type: Posts; User: aparna.kumbhar; Keyword(s):
it should be...
create table DEF as (select * from ABC);
Dual table is generally used for the completeness of SELECT clause syntax, cause select and from clauses are mandatory but many calculations do not need to select from actual table.
e.g. select 5*9 ...