Hi guys,
How would I go about implementing MySQL's BIN() function easily in PL/SQL.
mysql> SELECT BIN(12);
-> '1100'
Basically it converts a bigint to a string containing 1's and 0's.
I've tried messing about with bit() types, but those types lack casts to
text, etc. And they are left padded with many zeros.
Any ideas?
Chris
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
