Sample Header Ad - 728x90

How do I exclude unchanged fields in Flashback query resultset?

0 votes
1 answer
62 views
Is it possible to exclude unchanged fields in Flashback query resultset? Consider I have following table
create table first_table
(
    id int generated as identity,
    name NVARCHAR2(1024),
    age smallint,
    notebook nclob,
    userpic clob,
    salary float
)
If the table has very frequent updates (e.g. on notebook field) following versioned query
select ROWID, VERSIONS_OPERATION, VERSIONS_STARTSCN, VERSIONS_STARTTIME, VERSIONS_XID, id, name, age, notebook, userpic, salary
from FIRST_TABLE versions between scn 1469193 and 1482882;
will pull heavy userpic value for every row even though it's the same. Can I somehow avoid that and instead get NULLs for unchanged values ?
Asked by expert (285 rep)
Oct 3, 2020, 08:03 AM
Last activity: Oct 3, 2020, 12:31 PM