1、錯誤描述
SQL> create table info_stu from select t.stu_id,t.stu_name,t.stu_age from info t; create table info_stu from select t.stu_id,t.stu_name,t.stu_age from info t ORA-00922: 選項缺失或無效
由於用數據庫表中某些字段創建一張新表,中間的連接是用AS,而不是用from
3、解決辦法
SQL> create table info_stu as select t.stu_id,t.stu_name,t.stu_age from info t; Table created