For many years, I have noticed that rows are sometimes not copied correctly when editing a table.
An example of content that makes problems:
After copying the first row to a new row, I see this.
An example of content that makes problems:
SQL:
create table TEST_OF_COPY_ROWS
(
id number(4) not null,
text varchar2(200),
changed date default sysdate
)
;
insert into TEST_OF_COPY_ROWS
(id, text, changed)
values
(1,
'select 1 "Alias One",' || chr(10) ||
' ''two'' "Alias Two"' || chr(10) ||
'from dual',
to_date('18-06-2019 10:00:00', 'dd-mm-yyyy hh24:mi:ss'));
commit;
select t.*, t.rowid from TEST_OF_COPY_ROWS t;
After copying the first row to a new row, I see this.
