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
Last activity: Oct 3, 2020, 12:31 PM