Category "oracle12.1"

Change Two Rows Into Two Columns

Oracle newbie here just trying to learn something. I have a query that returns two rows per ID: SELECT B1_ALT_ID, B1_CHECKLIST_COMMENT FROM PERMIT WHERE (B1_CHE

can we pass parameter to the JSON_VALUE in Oracle

I have a query which fetches json format data from a column. i want to fetch the data of json by passing a field_name dynamically from the column. for example S