Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good morning
I'm connected to an oracle database, however the table I need to use is associated with the date, that is:
the name of the table today is A190214, the day will be generated tomorrow the table A190215 and so on
There is some way to generate a type of wildcard so that you can use the table all existing tables with associated date, without having to manually load by table
regards
Something like this:
let vDate = right(year(today()),2) & num(month(today()),'00') & num(day(today()),'00');
load .....from A($(vDate);