Which of the following is the Correct syntax of Nested table?

Options
- CREATE TABLE employee (Name VARCHAR2(20), Addresses VARCHAR2(20));
- CREATE TABLE employee (Name VARCHAR2(20), addresses ADDRESS_TABLE_TYPE);
- CREATE TABLE employee (Name VARCHAR2(20), addresses ADDRESS_TABLE_TYPE) NESTED TABLE addresses STORE AS addresses_table;
- None of the Above

CORRECT ANSWER : CREATE TABLE employee (Name VARCHAR2(20), addresses ADDRESS_TABLE_TYPE) NESTED TABLE addresses STORE AS addresses_table;

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲