Oracle alter table

Alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)

Add column table pl sql

ALTER TABLE table_name
  ADD column_name column_definition;

Alter table oracle

ALTER TABLE table_name
ADD CONSTRAINT constraint_name
   FOREIGN KEY (column1, column2, ... column_n)
   REFERENCES parent_table (column1, column2, ... column_n);

Source: techonthenet.com

Oracle alter table

ALTER TABLE table_name 
ADD column_name data_type constraint;
Code language: SQL (Structured Query Language) (sql)

Source: oracletutorial.com

Alter table oracle

ALTER TABLE products
ADD CONSTRAINT fk_supplier
  FOREIGN KEY (supplier_id)
  REFERENCES supplier(supplier_id);

Source: techonthenet.com

Similar codes

0 vote222 views1 answer
SQL check if record exist
SQL
0 vote206 views1 answer
How we can perform acid Operations in sql with examples
SQL
5 votes191 views1 answer
AND OR NOT operators sql
SQL
0 vote217 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote184 views1 answer
Get records in sql according to month name and count
SQL
0 vote203 views1 answer
Mysql trigger to delete old data
SQL
1 vote193 views1 answer
Calculate age in sql postgresql
SQL
0 vote198 views1 answer
Get sum sqlite android
SQL
0 vote233 views1 answer
Sql pivot without aggregate
SQL
1 vote146 views1 answer
File /etc/init.d/mysql not exists
SQL