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

ddl, foreign-keys, oracle, sql

Solution

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

`c1` new column in the table `tab1` with the FK `tab1_c1_fk` on the table `tab2` column `c2`.

Problem

How to add a new column with `foreign key` `constraint` in a single statement in `oracle`?Can any one give an example query?

Original source