Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select json_object(col..) into variable

3857119Feb 7 2019 — edited Feb 8 2019

I want to do something like this.

DECLARE

    v_jason_table   json_array_t;

BEGIN

    SELECT

        JSON_OBJECT(

            'role_id' IS role_id,

            'role_name' IS role_name,

            'role_index' IS role_index,

            'role_create_date' IS TO_CHAR(role_create_date, 'DD-MON-YYYY')

        )

    INTO v_jason_table

    FROM

        member_roles;

END;

Is this possible?

Thanks

This post has been answered by Sven W. on Feb 8 2019
Jump to Answer
Comments
Post Details
Added on Feb 7 2019
6 comments
1,284 views