Oracle Cheat Sheet

  • Post author:
  • Post category:Oracle

1. Ping Oracle.

tnsping SID

2. Get the SID.

SHOW PARAMETER instance_name;

3. JDBC driver.

oracle.jdbc.OracleDriver

4. JDBC driver URL pattern.

jdbc:oracle:thin:@HOST:PORT:SID

5. Date greater than clause.

date_col > TO_DATE('2015-01-01','yyyy-MM-dd')
date_col > '01-Jan-2015'