Home > Database > Oracle > body text

How to modify column name in oracle

hzc
Release: 2020-06-09 11:27:16
Original
9974 people have browsed it

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!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template