4 ms·
Using SQL Server exclusively has given me a Never-Oracle mindset. Some of these differences sound insane. and > any functions in the order by clause must be mo
by michannne 7y ago
Using SQL Server exclusively has given me a Never-Oracle mindset. Some of these differences sound insane. and
> any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))
I'd pull the hair outta my head
- hobs 7y agoBut functions in the where clause are an unsargable mess :(
- alexis_fr 7y agoMy top 1 is this one: > Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different Any programmer who doesn’t distinguish NULL and "" has not passed the 2-year experience. Being generous. How did this make it to production?
- irrational 7y agoDo you mean why does Oracle treat NULL and empty string as the same thing? Internally Oracle changes empty string to NULL values. Oracle won't let you insert an empty string.