Skip to Main Content

Object Types: modify_object_attribute() function

User_1871Apr 16 2022 — edited Apr 16 2022

Could Oracle consider creating a OOTB function that would let us assign an object type's attribute — within the SELECT clause of a query?
For example:

modify_object_attribute(object, attribute_name, new_val) returns object

modify_object_attribute(my_sdo_geom, sdo_gtype, 3306) returns sdo_geometry

More info here: Modify object attribute/property — without creating custom function
Yes, it's possible to do that kind of thing in a custom function or an inline function. But there are cases where we don't want to create a custom function or an inline function. An OOTB Oracle function would be simpler/preferred.
(I'm far from an expert. So I might have misunderstood something.)

Post Details
Added on Apr 16 2022
1 comment