/SQL/Rename column ORACLE

Rename column ORACLE

Rename column ORACLE

alter table sales rename column order_date to date_of_order;

4

Oracle rename table

ALTER TABLE table_name RENAME TO new_name;

1

Source: oracletutorial.com

PL SQL MODIFY COLUMN NME

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;

1

Similar codes

0 vote313 views1 answer
How to combine rows in sql server procedure
SQL
2 votes276 views1 answer
Latest record in sql
SQL
0 vote319 views2 answers
Update all columns in one update
SQL
3 votes348 views1 answer
Laravel paginate raw sql
SQL
0 vote317 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote342 views1 answer
Postgresql like
SQL
0 vote318 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote302 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote329 views1 answer
What does leave do in mysql
SQL
9 votes343 views2 answers
Convert data type in sql
SQL

Share