Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

modify (test-col2 number(l6,2))

 

 

 

 

 

10.03      How to change the column name ?

 

=>      RENAME the column Test-col as Test-coll

 

Through obJect Browser

Through sql command

 

Window

 

Tables

 

TEST_TABLE

 

→ RENAME

 

Column

 

Test_col

 

 

alter table test-table rename column test-col to test-coll