8. 8
v$sqlやってみた
Select a.username,s.first_load_time,s.sql_fulltext from v$sql s,all_users a
where a.user_id=s.PARSING_USER_ID
and lower(sql_fulltext) like ‘%emp%’;
USERNAME
-----------------------------------------------------------------------------------------FIRST_LOAD_TIME
----------------------------------------------------------------------------------------------SQL_FULLTEXT
-----------------------------------------------------------------------------------------------------XPRT
2011-10-12/11:35:39
insert into EMP(EMPNO,ENAME,JOB,HIREDATE,SAL,DEPTNO) values
(9999,'KISHIMOTO','CONS',TO_DATE('20030501','YYYYMMDD'),5000000,
10)