= Oracle =

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

JDBC driver for JDK 1.6 (ojdbc6.jar): http://download.oracle.com/otn/utilities_drivers/jdbc/11204/ojdbc6.jar

== Maven local repository install ==
mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.3 -Dpackaging=jar -Dfile=ojdbc6.jar -DgeneratePom=true

{{{#!highlight xml
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>
</dependency>
}}}

== 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';

SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='AAA';
}}}

== 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;
}}}

== Partinioning ==
http://www.orafaq.com/wiki/Interval_partitioning

http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin005.htm

http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin002.htm

{{{#!highlight sql
select table_name,partition_name,num_rows
from user_tab_partitions
where table_name='TEST';
}}}

Other views:
 * DBA_TAB_PARTITIONS
 * ALL_TAB_PARTITIONS
 * USER_TAB_PARTITIONS

== Sequence creation ==
{{{#!highlight sql
CREATE SEQUENCE sample_seq  START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE sample_seq2 MINVALUE 1 START WITH 1 INCREMENT BY 1;
}}}