Suppose you have a table named employee with the following columns:
- employee_id
- last_name
- job_id
- commission_pct
- department_id
And you want to create new table named contract_workers with the same columns as employee table, the fastest way to chieve this is to run the following DDL statement:
CREATE TABLE contract_workers AS (SELECT * FROM employees where 1=2);