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>
Subscribe to:
Post Comments (Atom)
This comment has been removed by a blog administrator.
ReplyDeletejordan 1 off white
ReplyDeletemoncler outlet
adidas yeezy
longchamp handbags
off white jordan 1
hermes belts
yeezys
supreme outlet
lebron james shoes
authentic jordans