alter table, add column – Oracle Example Syntax

Posted on Apr 28, 2009 in Technical Tips | 0 comments

Following is simple example syntax for adding a column to an Oracle table using “alter table” SQL:

1
2

ALTER TABLE [my_table_name]
ADD [my_column_name] [my_data_type];

A simple example would be:

1
2

ALTER TABLE employee
ADD tps_reports_completed NUMBER;

Related Information:

1. Oracle Rename Column – alter table, rename column Example SQL Syntax

   Following is simple example syntax...

2. Oracle Rename Table – Example Syntax and Dependencies

   Renaming a table in Oracle...

3. Copy Table Columns and Data

   As you may know, in...

4. Oracle SUBSTR with INTSR Function – SQL Syntax Examples

   Oracle SUBSTR and INSTR SQL...

5. SQL LIKE – Oracle LIKE Operator – SQL Syntax Examples

   The reserved word LIKE in...

6. Oracle TO_DATE Function – SQL Syntax Examples

   The Oracle TO_DATE SQL function...

7. Oracle SUBSTR Function – SQL Syntax Examples

   The Oracle SUBSTR SQL Function...

8. Oracle INSTR Function – SQL Syntax Examples

   The Oracle INSTR SQL function...