updating objectsto change the attributes of


Updating Objects:

To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows:

BEGIN

UPDATE persons p SET p.home_address = '341 Oakdene Ave'

WHERE p.last_name = 'Brody';

...

UPDATE persons p SET p = Person('Beth', 'Steinberg', ...)

WHERE p.last_name = 'Steinway';

...

END;

 

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: updating objectsto change the attributes of
Reference No:- TGS0172977

Expected delivery within 24 Hours