一个insert多条数据,及查询表，列。

1.  insert into table_name1(col1,col2,col3....) select col1, col2,col3 .... from tabel_name2  where ........

 

2 select * from all_all_table where table_name like %表名(大写)%  and tablespace_name='表空间(大写)'

 

3 select * from all_col_comments where owner='表空间(大写)' and column_name='字段名(大写)'