I'm particularly fond of this line: [quote]if(pass=="Th!s!sMyPa$$W0rD" && pass!=null)[/quote]

http://img178.imageshack.us/img178/3021/netfilerm3.png Do you think if I try 'null' as my pin it will work?

ammoQ: Beware of those side effects: length('') returns NULL (not 0 ) So wait... you give Oracle a string of zero characters in length, and ask it the length, and instead of saying zero, it says "hmmm?" Even some parrots and 4 year old children can grasp the concept of "zero". RIP Alex :(

Again, according to Oracle doc they're the same. Testing shows that DECODE regards NULLS as equal, while CASE (and all other statements involving NULL) do not. SELECT CASE NULL WHEN NULL THEN 0 ELSE 1 END AS test FROM dual; SELECT DECODE(NULL, NULL, 0, 1) AS test FROM DUAL; The first returns 1, since...

Try this: SELECT COALESCE(2,1/0) FROM DUAL; SELECT NVL(2, 1/0) FROM DUAL; According to Oracle documentation, both should yield the same results. However, while COALESCE evaluates all branches until it finds one that is not NULL, NVL allways evaluates both branches, resulting in an error on the second...

ammoQ: Beware of those side effects: length('') returns NULL (not 0 ) rpad('', 5) returns NULL which equals '' (not ' ' ) (rpad normally pads the string to the given length) Or let's say you're manipulating strings. You replace some substring, concatenate another string, do some more replacing... If...

Thief^: I have linux dual-booting with XP on my pc at home, and I regularly use both. It's just a pity that wine isn't yet finished enough to run most Windows-only games. Though for software (and console) development, it's hard to beat Visual Studio. Oh dear... Im sure that " it's hard to beat Visual...

See anything strange about this scrennshot of the tag cloud?

this is an amusing read!