ddl - How to add a new column with foreign key constraint in a single statement in oracle -


how add new column foreign key constraint in single statement in oracle.can 1 give example query.

alter table tab1 add c1 number(20) constraint tab1_c1_fk references tab2(c2) ; 

c1 - new column in table tab1 fk tab1_c1_fk on table tab2 column c2


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -