copy rows in Edit data

Kajman

Member²
For many years, I have noticed that rows are sometimes not copied correctly when editing a table.

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.

amk.png


 
Back
Top