-- Create table create table test1 as ( select 2001 as keyvalue, 1 as counter, '+++ Input: My Name is ABC' as text from dual union all select 2001 as keyvalue, 2 as counter, '+++ Input: Cricket is my favourite sport' as text from dual union all select 2001 as keyvalue, 3 as co