How to update column value of a subtype?
Code like this can't access the grade attribute of student:
update persons set grade = 'graduated';
CREATE OR REPLACE TYPE person (
name varchar2(20),
age number,
address varchar2(20)
) NOT FINAL;
CREATE OR REPLACE TYPE student UNDER person (
grade varchar2(20)
) NOT FINAL;
CREATE TABLE persons OF person;
INSERT INTO persons VALUES (student('Jon', 'undergraduate'));
How I change student grade to 'graduated'?
I found a answer to my problem.
This is the code to update subtype attributes: