INSERT与ORA-00936、ORA-00928

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);