Oracle Add Field To Table. ALTER COLUMN column_name datatype. The INSERT statement adds one or more new rows of data to a database table.
Keyword and Parameter Description. Create table t c1 number c2 number. Alter table customer add mobile_phone varchar2 20 null.
Alter table add column in Oracle.
We can add a table to hold the new data or add it to our current schema by adding a column to a current table. Select from it and everything looks fine. To add a new column to a table you use the ALTER TABLE statement as follows. Use alter table to add column for example.