I have a table column declared like this:
file_id number(10) generated always as identity primary key,
Is it possible to programatically get a currval/nextval from its backing sequence without actually looking into the SYS. tables to obtain the name of the sequence and then using execute immediate on that name?