Hi Team,
I am trying to fetch data for a specific key from json type column from ADB.
I am able to fetch data for other keys those don't have special char in string. However below query does not work due to special “()” in the string. I have tried to escape it with “\” but that does not seems to working.
select d.j_data."the_details_of_jobs(dependent)" from table_name d where d.submit_time between TO_TIMESTAMP ('2024-03-28 14:05:00', 'RRRR-MM-DD HH24:MI:SS') and TO_TIMESTAMP ('2024-04-04 14:05:00', 'RRRR-MM-DD HH24:MI:SS') ;