Oracle Tips and Techniques

Oracle SQL Command: ALTER TABLE

ALTER TABLE is a very powerful and versatile command in Oracle. It is a DDL (data definition language) command as it changes the definition of a table or  it’s columns behaviour.

Suppose we create table called emp as below:

create table emp
(empno NUMBER,
ename VARCHAR2(10),
salary NUMBER);

The command ALTER TABLE can be used to do the following to the table:

Continue reading →