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

10 votes218 views2 answers
Mysql drop database if exists
SQL
-1 vote238 views1 answer
Mysql faster insert
SQL
0 vote231 views1 answer
Unique element in sql
SQL
0 vote223 views1 answer
Connecting mySQL to STS
SQL
0 vote214 views1 answer
Database traccar
SQL
2 votes203 views1 answer
Date conversion in mysql column
SQL
0 vote214 views1 answer
Cast float mysql
SQL
0 vote207 views1 answer
Sql auto_increment syntax
SQL
0 vote241 views1 answer
Sp help text in postgresql
SQL
0 vote288 views1 answer
Postgresql conectar
SQL