Never use this reserved word ( current_date ) when you define a column .
If you do so , you will end up in unexpected behavior : when you will select from the table, you will get always the current date , not the data which is actual in the table .
The new FILTER clause in Aggregations
-
Oracle 26.1 introduces the new FILTER clause that can be used in
aggregations.
Thus, for example, *in a SUM aggregation you can use FILTER WHERE ...*
...
Acum 6 zile
Niciun comentariu:
Trimiteți un comentariu