Oracle SQL

Administration

JDBC Connection String

jdbc:oracle:thin:@<host>:<port>:<SID>
jdbc:oracle:thin:@<host>:<port>/<sevice_name>

Queries

Insert a date

INSERT INTO emp (empno, ename, job, sal, comm, deptno, creationdate)
   VALUES (4160, 'STURDEVIN', 'SECURITY GUARD', 2045, NULL, 30, TO_TIMESTAMP('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'));

Replace a string in a column ("from" --> "to")

UPDATE ZDMS_RECORDS SET path=REPLACE(path, 'from', 'to');

Tools

To monitor the requests made from C# code : EFProfiler or DBMonitor.

Print/export