I am using a PIVOT to combine two rows with the same ID into a single row: SELECT B1_ALT_ID, B1_CHECKLIST_1, B1_CHECKLIST_2 FROM B1PERMIT A JOIN BCHCKBOX B ON A
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
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