<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>
lunedì 31 gennaio 2011
Iscriviti a:
Commenti sul post (Atom)
Nessun commento:
Posta un commento