= Oracle =

http://docs.oracle.com/cd/B19306_01/index.htm

== Get schemas in DB ==
{{{#!highlight sql
SELECT DISTINCT USERNAME FROM DBA_USERS;
}}}

== Get columns from table ==
{{{#!highlight sql
SELECT * FROM ALL_IND_COLUMNS WHERE TABLE_NAME='XYZ';
}}}

== Get indexes from table ==
http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_1069.htm

{{{#!highlight sql
SELECT index_name, table_owner, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'XYZ';
SELECT index_name, table_owner, table_name, uniqueness FROM ALL_INDEXES WHERE table_name = 'XYZ';
}}}

== Get code from stored procedure ==
{{{#!highlight sql
SELECT * FROM all_source WHERE name = 'myprocedure'
ORDER BY owner,name,line
}}}

== Show schema and table ==
{{{#!highlight sql
SELECT distinct owner,table_name 
FROM all_tables
ORDER BY owner,table_name;
}}}