DBA Hub

📋Steps in this guide1/1

managing columns of table

-- Add column

oracle configurationintermediate
by OracleDba
14 views
1

managing columns of table

-- Add column -- Drop column -- Rename column -- set column unused -- Drop unused columns from a table

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
alter table scott.emp add( empname varchar2(20));
alter table scott.emp add( empid number,deptid number);
alter table scott.emp drop (empname);
alter table scott.emp drop (empid,deptid);
alter table scott.emp rename column empname to asocname;
alter table scott.emp set unused (empname);
alter table scott.emp drop unused columns.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!