02 February, 2010

Extra Oracle command?

1.select *from tab;
---output all table name;
2.select OWNER,NAME,TYPE from dba_source
group by OWNER,NAME,TYPE order by OWNER,NAME,TYPE;
--owner=user name
--name= package name
--type=package type(TRIGGER, PROCEDURE, FUNCTION etc)

No comments:

Post a Comment