Rename a column in Oracle

Renaming a column in Oracle is done by using the construct below

ALTER TABLE <Table name>
RENAME COLUMN <old column name> TO <new column name>

Note: Text within <> indicate the parameters that need to be replaced.

Comments

Post a Comment

Popular posts from this blog

Configuring DB2 Connect Server

The following is the process to configure DB2 Connect Server to communicate with DB2 Server, Connect to DB2 CLI (or) use DB2 Configuration Assistant using the DB2 Connect User credenitals used when installing the product. Configure TCPIP node between DB2 Connect Server and the DB2 Database server using the statement below, "CATALOG TCPIP NODE REMOTE SERVER " Catalog the database via an alias name on to the TCPIP node created in step 2 using the statement below, "CATALOG DATABASE AT NODE "
Read more

Concatenate files using MS-DOS

One or more files can be concatenated and saved to a single file using the very helpful copy command available in MS-DOS. The usage of it as follows, copy <multiple file names separated by the plus(+) operator> <resulting file name > Ex: copy File1.txt+File2.txt File3.txt copy *.* File3.txt
Read more