Friday, May 22, 2009

Oracle DB Data Dictionary Views

select * from DICTIONARY;

use following query from sys user

select kqfvinam name from x$kqfvi order by kqfvinam;
select * from PUBLICSYN where sname like 'V$%' order by 3,1;

No comments:

Post a Comment

Followers