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

1
2

ALTER TABLE [my_table_name]
RENAME COLUMN [current_column_name] TO [new_column_name];

A simple example would be:

1
2

ALTER TABLE employee
RENAME COLUMN f_name TO first_name;

Like renaming an Oracle table, you should be aware of any dependencies in code, etc. that reference a table column by name. Oracle does make the required changes within a database in many cases, but of course, you should ensure all is working and update any components that reside outside the database. You can use tools like TOAD to easily check dependencies on a table in a visual manner. Below is a screenshot within TOAD of the “Used By” tab that can be accessed when your table is selected in the schema browser:

Related Information:

1. 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...

2. alter table, add column - Oracle Example Syntax

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

3. Oracle Materialized View DDL

   Are you a TOAD fanatic when it comes to “anything-Oracle”? If so, you probably realized that TOAD will not show...

4. 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...

5. TOAD for Oracle 9 or TOAD 10 - 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

   I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x,...

6. 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...

7. 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...

8. 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...