EXAMPLE:
CREATE TABLE hr.admin_emp_dept
PARALLEL COMPRESS
AS SELECT * FROM hr.employees
WHERE department_id = 10;
复制、拷贝表并创建新表。
相当于SQL SERVER的 SELECT * INTO new_table FROM old_table
使用CREATE...AS...语句创建新表时,原表上如果有显式非空约束会传递给新表,其它约束不会带到新表。
隐式NOT NULL如主键上的非空约束。
The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.