Renaming a column using oracle from version 9i

ALTER TABLE <TABLE_NAME> RENAME COLUMN <CURRENT_COLUMN_NAME> TO<NEW_COLUMN_NAME>;

TO_DATE Oracle Function

Syntax: TO_DATE (date, format) 

 

Example: TO_DATE('11/11/2010 13:00:00', 'dd/MM/YYYY HH24:MI:SS')  - in this case for 24 hours. For 12 hours, you should also specify AM or PM.

 

Find out more in this website (another one that I hope lasts forever) - http://www.techonthenet.com/oracle/functions/to_date.php

 

 

Oracle JDBC string Connection for thin driver

Simple, simple (I took too much time trying to find this string)…

 

jdbc:oracle:thin:[user/password]@//[host][:port]/SID