Howto compare the columns of 2 diff tables of 2 different schemas in UNIX shell script

Shell Programming and Scripting
1

HI All,

I am new to Unix shell scripts..

Could you please post the unix shell script for for the below request.,

There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).

Unix shell script to compare the columns of two different tables of two different schemas and provide whether the data in the tables are similar or not and count of the column with the status in the row( for eg: some rows have the status with "LOADED" and some with "ERROR")

The column in tables(sample1, sample2) are having the different data type.

Thanks in advance.

Regards,
Rajkumar Gopal

2

@Rajkumar: Give us more information.

OS:- ?
DB:- ?
Shell:- ?

Example schema will also help. Your query is very vague.

3

OS:- windows7
DB:- Oracle 10g DB, sqldeveloper-3.0.04.34
Shell:- UNIX SHELL SCRIPT

---------- Post updated at 12:31 PM ---------- Previous update was at 12:30 PM ----------

S_SCHEMA1 -> SCMIDDLEWARE
S_SCHEMA2 -> AQADM