sqlplus查询进程执行记录

1.根据查询某进程执行sql记录。
select sql_text,parsing_schema_name,module,first_load_time from V$SQL where parsing_schema_name=‘TEST’ and module=‘操作的软件名.exe’ order by first_load_time desc

2.查询数据库下的表是否存在
select * from all_tables where owner = ‘test’ and table_name = ‘test_fc’

3.查询某张表的列及列表
select column_id,column_name,data_type from user_tab_cols where table_name=‘test_fc’ order by column_id