Tables
select TABLE_NAME, OWNER from SYS.ALL_TABLES order by OWNER,
TABLE_NAME
The query can be filtered to return tables for a given schema by adding a where
OWNER = 'some_schema' clause to the query.
Schemas
select USERNAME from SYS.ALL_USERS order by USERNAME
Views
select VIEW_NAME, OWNER from SYS.ALL_VIEWS order by OWNER, VIEW_NAME
The query can be filtered to return views for a specific schema by adding a
where OWNER = 'some_schema' clause to the query.
Packages
select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where UPPER(OBJECT_TYPE) =
'PACKAGE' order by OWNER, OBJECT_NAME
To query for package bodies, substitute PACKAGE BODY for PACKAGE.
The query can be filtered to return packages for a specific schema by adding a
where OWNER = 'some_schema' clause to the query.
Procedures
select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) =
upper('PROCEDURE') order by OWNER, OBJECT_NAME
The query can be filtered to return procedures for a specific schema by adding
a where OWNER = 'some_schema' clause to the query.
Procedure Columns
select OWNER, OBJECT_NAME, ARGUMENT_NAME, DATA_TYPE, IN_OUT from SYS.ALL_ARGUMENTS
order by OWNER, OBJECT_NAME, SEQUENCE
Functions
select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) =
upper('FUNCTION') order by OWNER, OBJECT_NAME
The query can be filtered to return functions for a specific schema by adding a
where OWNER = 'some_schema' clause to the query.
Triggers
select TRIGGER_NAME, OWNER from SYS.ALL_TRIGGERS order by OWNER,
TRIGGER_NAME
The query can be filtered to return triggers for a specific schema by adding a
where OWNER = 'some_schema' clause to the query.
Indexes
select INDEX_NAME, TABLE_NAME, TABLE_OWNER from SYS.ALL_INDEXES order by
TABLE_OWNER, TABLE_NAME, INDEX_NAME
select TABLE_NAME, OWNER from SYS.ALL_TABLES order by OWNER, TABLE_NAME
The query can be filtered to return tables for a given schema by adding a where OWNER = 'some_schema' clause to the query.
select USERNAME from SYS.ALL_USERS order by USERNAME
select VIEW_NAME, OWNER from SYS.ALL_VIEWS order by OWNER, VIEW_NAME
The query can be filtered to return views for a specific schema by adding a where OWNER = 'some_schema' clause to the query.
select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where UPPER(OBJECT_TYPE) = 'PACKAGE' order by OWNER, OBJECT_NAME
To query for package bodies, substitute PACKAGE BODY for PACKAGE.
The query can be filtered to return packages for a specific schema by adding a where OWNER = 'some_schema' clause to the query.
select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) = upper('PROCEDURE') order by OWNER, OBJECT_NAME
The query can be filtered to return procedures for a specific schema by adding a where OWNER = 'some_schema' clause to the query.
select OWNER, OBJECT_NAME, ARGUMENT_NAME, DATA_TYPE, IN_OUT from SYS.ALL_ARGUMENTS order by OWNER, OBJECT_NAME, SEQUENCE
select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where upper(OBJECT_TYPE) = upper('FUNCTION') order by OWNER, OBJECT_NAME
The query can be filtered to return functions for a specific schema by adding a where OWNER = 'some_schema' clause to the query.
select TRIGGER_NAME, OWNER from SYS.ALL_TRIGGERS order by OWNER, TRIGGER_NAME
The query can be filtered to return triggers for a specific schema by adding a where OWNER = 'some_schema' clause to the query.
select INDEX_NAME, TABLE_NAME, TABLE_OWNER from SYS.ALL_INDEXES order by TABLE_OWNER, TABLE_NAME, INDEX_NAME
EmoticonEmoticon