I'm really new on oracle db. I'm trying to update specific column on this table.
CREATE TYPE ABSTRACT_SALARY AS OBJECT (
startDate DATE,
endDate DATE,
salary NUMBER );
CREATE TYPE SALARY_TYPE AS TABLE OF ABSTRACT_SALARY;
CREATE TABLE Person(
---
---
---
---
salaryType SALARY_TYPE
)
NESTED TABLE salaryType STORE AS person_salaryTypes;
How can I update salary column %10 higher. Thanks in advance.