Syntax

Basic Date format

July 30, 2012 admin Oracle, Syntax

select to_char(sysdate,’DD/MM/YYYY HH24:MI:SS’) from dual;

ALTER TABLESPACES

July 30, 2012 admin Oracle, Syntax

alter database datafile ‘xxx.dbf’ resize 1042308K;

Kill Sessions

July 30, 2012 admin Oracle, Syntax

Alter system kill session ‘,‘;