Shell Programming and Scripting

Hi All,

****************************************************************
File1:

CREATE TABLE "TESTIHUB"."CINEMA"
( "NAME" VARCHAR2(20),
"ACTOR" VARCHAR2(20),
"YEAR" NUMBER
);

/

CREATE TABLE "TESTIHUB"."PANT"
( "CNAME" VARCHAR2(20),
"AMOUNT" NUMBER,
"STOCKNO" NUMBER
);

/


*****************************************************************
File2:

CREATE TABLE "TESTIHUB"."CINEMA"
( "NAME" VARCHAR2(20),
"ACTOR" VARCHAR2(20),
"YEAR" NUMBER
"PRODUCER VARCHAR2(20)
);

/

CREATE TABLE "TESTIHUB"."PANT"
( "CNAME" VARCHAR2(20),
"AMOUNT" NUMBER,
"STOCKNO" NUMBER
);

/

*********************************************************************

I want to compare these two files with respect to blocks I mean to say I want to compare entire create statments as one unit. Incase of any difference out-put the difference

into a file with both create statements and difference element. As here in file2 in create statment CINEMA in file2 producer is added.

Thanks
Naree

I recommend the following programmatic solution.

A.) Build a program that splits the paragraphs out into files named with the table_nm: table_nm.sch. For each file1, file2, store these schema files in a separate directory.

B.) Build another program to diff each file individually and then report in whatever format you like.

Give it your best shot. We'll assist in any debugging.