Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 26, 2011 09:50 PM by Lannie
Nov 23, 2011 11:37 PM|LINK
I'm using Oracle SQL and I have one query like this select bin_num as BINARY_NUMBER from table1
this bin_num will display binary number with 25 digits like "0001000000100001000000000" and I want to display the result based on the location of "1"s in my result.
For example, "1"s is locate at number 4, 11 & 16. So my result will display as below table:
Please guide me how to do this in SQL.
Thanks in advance.
Nov 26, 2011 09:50 PM|LINK
use PLSQL loop and advance your INSTR pointer not to exceed 25