Home  >  Article  >  Database  >  How to modify column name in oracle

How to modify column name in oracle

hzc
hzcOriginal
2020-06-09 11:27:169927browse

How to modify column name in oracle

Oracle method to modify column names:

1. Use tools to edit new column names directly in the visualization panel.

2, Modify column name syntax: alter table table name rename column rename old column name to new column name

alter table table name rename column rename textpass to password

Execute the above statement to modify your column name! !

Related introduction to Oracle:

Oracle Corporation, the full name of Oracle Corporation (Oracle Software Systems Co., Ltd.), is the world's largest enterprise software company, headquartered in Redwood Beach, California, USA. . Officially entered the Chinese market in 1989. In 2013, Oracle surpassed IBM and became the world's second largest software company after Microsoft.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to modify column name in oracle. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn