Oracle add column

-- ALTER TABLE <table> ADD <column> <type>  <constraint>;
ALTER TABLE members ADD age NUMBER;
ALTER TABLE members ADD birth_date DATE NOT NULL;
ALTER TABLE members ADD registering DATE DEFAULT sysdate;
ALTER TABLE members ADD member_id NUMBER UNIQUE;

Source: oracletutorial.com

Alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)

Add column table pl sql

ALTER TABLE table_name
  ADD column_name column_definition;

Oracle alter table add column

ALTER TABLE table_name 
	ADD column_name data_type constraint;

Similar codes

14 votes207 views3 answers
SQL trim
SQL
0 vote160 views1 answer
Mysql select top 2
SQL
1 vote220 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
1 vote195 views2 answers
Postgresql list columns
SQL
8 votes233 views2 answers
Replace string value in sql
SQL
0 vote219 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote219 views1 answer
Get initials name in sql
SQL
1 vote195 views1 answer
Show table columns
SQL
0 vote191 views1 answer
Create table Statement Syntax in SQL Server
SQL
2 votes199 views2 answers
Install sqlalchemy
SQL