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 .
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu