Go Back

1. Used PL\SQL to print out a copy of the revised table FTable1a.
SQL> select * from FTable1a;

2. Used PL\SQL to print out a copy of the revised table FTable1b.
SQL> select * from FTable1b;

14 rows selected.

3. Used PL\SQL to print out a list of all constraints associated with Table FTable1a.
SQL> Select constraint_name from user_constraints where table_name = 'FTABLE1A';

CONSTRAINT_NAME
------------------------------
FTABLE1A_CODE_PK
FTABLE1A_TITLE_NN
FTABLE_NAME_NN
FTABLE_ZIP_NN

4. Uses PL\SQL to print out a list of all constraints associated with Table FTable1B.
SQL> Select constraint_name from user_constraints where table_name = 'FTABLE1B';

CONSTRAINT_NAME
------------------------------
FTABLE1B_CODE_FK
FTABLE1B_ITEM_NN
FTABLE_DESCRIPTION_NN
FTABLE_QTY_NN
FTABLE1B_PRICE_ITEM_NN