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 for renaming a column to an Oracle table using "alter table" SQL:
    
   ALTER...

2. Oracle Rename Table - Example Syntax and Dependencies

   Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax: 1 ALTER TABLE current_table_name RENAME...

3. Copy Table Columns and Data

   As you may know, in Oracle the syntax from creating a table that is the same as another is: 1...

4. Oracle SUBSTR with INTSR Function - SQL Syntax Examples

   Oracle SUBSTR and INSTR SQL functions are typically used together in practice for parsing a string. Following are...

5. Oracle TO_DATE Function - SQL Syntax Examples

   The Oracle TO_DATE SQL function is used to convert a TEXT or NTEXT representation of a date into an Oracle...

6. SQL LIKE - Oracle LIKE Operator - SQL Syntax Examples

   The reserved word LIKE in Oracle SQL represents an operator that performs some basic matching on text. LIKE provides a...

7. Oracle IdM - SAML SSO with Google Apps

   We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against...