OCM 11g -Finally complete

Hello everybody....
Many thanks to god....... finally my OCM exam result is out and I got a mail ..and I have successfully cleared the Oracle Certified Master exam and I have been awarded OCM status by Oracle Corp.....It was the most awaited email which i got couple of hours back................Cheers !!!

Hello Everyone,

I was a bit busy from last couple of months and was away from writing, I got a new laptop yesterday and i am planning to be in action again. Thanks all for your support and your encouraging comments.

Thanks and Regards
Sandeep Panchal.

rename column example in 11g database

SQL> desc emp;


Name Null? Type

----------------------------------------- --------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)

SQL> alter table emp rename column sal to salary;
Table altered.

SQL> desc emp;

Name Null? Type

----------------------------------------- -------- ------------------------

EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SALARY NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
SQL>