Skip to Main Content

SQL Developer

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!

write a query display the in seprate columns type of id and values

Jaytamil eniyanNov 29 2022

Input:
'PAN~AAAAA4564B|VOTER_ID~VDD11111111111|RATION~1234566'
Expected Output:
ID_type Values
------- ------
PAN AAAAA4564B
VOTER_ID VDD11111111111
RATION 1234566

Comments
Post Details
Added on Nov 29 2022
1 comment
102 views