SQL> drop table t_insert;
Table dropped
SQL> create table t_insert as select table_name, num_rows from user_tables where 1=0 ;
Table created
SQL> insert into t_insert (table_name,num_rows)
2 values (select t.table_name ,t.num_rows from user_tables t where rownum<10);
insert into t_insert (table_name,num_rows)
values (select t.table_name ,t.num_rows from user_tables t where rownum<10)
ORA-00936: 缺失表达式
--insert 使用子查询不能使用values
SQL> insert into t_insert (table_name,num_rows)
2 (select t.table_name ,t.num_rows from user_tables t where rownum<10);
9 rows inserted
QL> insert into t_insert(table_name ,num_rows) ('ttt',11);
insert into t_insert(table_name ,num_rows) ('ttt',11)
ORA-00928: 缺失 SELECT 关键字
-- insert 具体的值时,必须指定values
SQL> insert into t_insert(table_name ,num_rows) values ('ttt',11);