CODEWITHSUNDEEP
oracle-database
user3586734
user3586734

Reputation:

Oracle I can't alter table with a nested table

Why I get ORA-22913 when I want to alter table? ("must specify table name for nested table column or attribute")

DROP TYPE salaryRaise FORCE;
/
CREATE TYPE salaryRaise AS OBJECT(
   newSalary NUMBER,
   raiseDate DATE);
/
DROP TYPE salaryList FORCE;
/
CREATE TYPE salaryList IS TABLE OF salaryRaise;
/
ALTER TABLE emp ADD listOfSalaries salaryList;
NESTED TABLE listOfSalaries STORE AS salaryList_tab;

Upvotes: 0

Views: 2745

Answers (1)

user3586734
user3586734

Reputation:

I found the solution

ALTER TABLE emp ADD listOfSalaries salaryList NESTED TABLE listOfSalaries STORE AS salaryList_tab;

Upvotes: 1

Related Questions