Convert string to rows/table

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Convert string to rows/table

Post by admin »

select * from table(apex_string.split('1,2,3',','))

select * from table(apex_string.split('1:2:3',':'))

Output will be
1
2
3
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest