Problem: Write an SQL query to convert a given decimal number to its binary equivqlent.
Solution:
select
reverse(max(replace(sys_connect_by_path(sign(bitand(&num,power(2,level-1))),','),','))) from dual
connect by power(2,level-1)<=&num
Posts
sqlite3
-
I just tried sqlite. It is ultra-light and support SQL commands. Just try
this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter
".help" fo...
3 weeks ago
1 comment:
Hmm it looks like your website ate my first comment (it was super long)
so I guess I'll just sum it up what I submitted and say, I'm thoroughly enjoying
your blog. I too am an aspiring blog writer but I'm still new to everything. Do you have any tips for beginner blog writers? I'd
genuinely appreciate it.
Look at my webpage ... Sac A Main Louis Vuitton
Post a Comment