|
|
|
|
|
|
by siddboots
4307 days ago
|
|
|
I completely agree that this is one of the major lackings of SQL. Most databases offer the WITH syntax, but, bizarrely, the SQL standard specifies that the WITH block should materialised separately, which prevents it from being used as a device for abstraction. Oracle is the only database I'm aware of that allows the WITH block, but doesn't impose the optimiser fence. |
|
|