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

10-00 HOW TO ALTER TABLE PROPERTIES

At the time of creation or on change of system design one may require to rectify the table properties.

=>Home        →      SQL Workshop         →

=>create a test_table

=> "create table test_table (test_col number (16, 2))"

10.01    How to add another column on the existing table.

In the above created table test-Table has got only one column and want to add another column test-col2 as below:

=>ADD one column as test-col2 with a data type char

(10)

Through obJect Browser

Through sql command Window

→ Tables

Alter table test-table