How to Use SQL for Create Table By Select

How to Use SQL for Create Table By Select

How to Use SQL for Create Table By Select by use below sql.

Create table <<<Table Name>>>
TABLESPACE HRAPP STORAGE (INITIAL 40000 NEXT 100000
MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PCTUSED 80
as
(select * from <<<Table Name>>>
)

Example 1 :

create table course_backup
TABLESPACE HRAPP
as
select * from course;

Example 2 :

Create table ps_jl_wo_tbl_2020
TABLESPACE HRAPP STORAGE (INITIAL 40000 NEXT 100000
MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PCTUSED 80
as
(select * from ps_jl_wo_tbl )

Posted in SQL.