Home >> Oracle >> Alter Table in Oracle

Alter Table in Oracle

ALTER TABLE used to add, modify, drop or delete columns in a table. It is also used to rename a table.

Syntax

ALTER TABLE table_name ADD column_name;   

Example

ALTER TABLE students ADD (city varchar2(50));  

Post Your Comment

Next Questions
Create table AS
Global Temporary tables
SELECT Query
INSERT Query
INSERT ALL Query
UPDATE Query
DELETE Query
WHERE clause
AND Clause
OR Clause
LIKE clause
IN clause
ORDER BY Clause
GROUP BY Clause
HAVING Clause
BETWEEN
EXISTS
NOT EXITS
ANY
ALL
MAX
MIN
AVG
COUNT
SUM

Copyright ©2022 coderraj.com. All Rights Reserved.