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.
Download the book in PDF, ePub, Kindle for a complete version.
add ( test-col2 char(1O))
10.02 How to change the data type?
The data type which has been already created as char(2), and need to be changed as number with width and precision,
MODIFY the column test-col2 char (1O) as Test-col2 number (16, 2)
Through obJect Browser
Through sql command
Window
→ Tables
alter table testtable