> Returns not empty string but NULL:
The two are equivalent in Oracle. Try select 'a' || null || 'b' from dualand compare it to postgres.
-Jonathan