SELECT to_date(‘19700101′,’yyyymmdd’) + (TIMESTAMP_VALUE/1000/24/60/60) AS date_time FROM TABLENAME;

Conditions 1. blob not save too much content, and text 2. backup blob text to clob 3. oracle v11 blob to clob –Add new clob column ALTER TABLE TABLENAME ADD (CLOB_COLUMN CLOB); –copy blob value to clob UPDATE TABLENAME SET CLOB_COLUMN = UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(BLOB_COLUMN,2000)); –drop blob ALTER TABLE TABLENAME DROP COLUMN BLOB_COLUMN; –rename clob column, name […]

24hours SELECT TO_CHAR(date_column,’YYYY-MM-DD HH24:MI:SS’) FROM tablename

1. When you access sqlplus with sysdba withought password to check system tables sqlplus / as sysdba 2. When you access sqlplus with anonymous, only use sqlplus command without any privileges sqlplus /nolog 3. To check sid information we need to check tnsnames.ora file in network folder 4. Display cache commands: l or run 1) […]