lunedì 31 gennaio 2011

Oracle objects determine creation date

<code type="sql">
select OWNER, OBJECT_NAME, to_char(CREATED,'MM/DD/YYYY HH24:MI:SS')
created, status from dba_objects
where OWNER in ('MYSCHEMA') and OBJECT_TYPE='VIEW'
order by OWNER,OBJECT_NAME
</code>

Nessun commento:

Posta un commento