CLOB Comparison Test Data

CREATE TABLE COMPARE_FILE_TEST
(
  id       NUMBER NOT NULL,
  old_file CLOB,
  new_file CLOB
);

INSERT INTO COMPARE_FILE_TEST
(id,
old_file,
new_file
)
VALUES
(1,
 'A
A
A
This part of the
document has stayed the
same from version to
version.  It shouldn''t
be shown if it doesn''t
change.  Otherwise, that
would not be helping to
compress the size of the
changes.

This paragraph contains
text that is outdated.
It will be deleted in the
near future.

It is important to spell
check this dokument. On
the other hand, a
misspelled word isn''t
the end of the world.
Nothing in the rest of
this paragraph needs to
be changed. Things can
be added after it.
Z
Z
Z',
'A
A
A
This is an important
notice! It should
therefore be located at
the beginning of this
document!

This part of the
document has stayed the
same from version to
version.  It shouldn''t
be shown if it doesn''t
change.  Otherwise, that
would not be helping to
compress anything.

It is important to spell
check this document. On
the other hand, a
misspelled word isn''t
the end of the world.
Nothing in the rest of
this paragraph needs to
be changed. Things can
be added after it.

This paragraph contains
important new additions
to this document.
Z
Z
Z');

INSERT INTO COMPARE_FILE_TEST
(id,
old_file,
new_file
)
VALUES
(1,
'1
2
3
9
8
2
3
4
5
6',
'1
2
3
4
5
6
7
8
9
10');