Howto compare the columns of 2 diff tables of 2 different schemas in UNIX shell script | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

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

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 03-26-2013
Rajkumar Gopal Rajkumar Gopal is offline
Registered User
 
Join Date: Mar 2013
Last Activity: 28 March 2013, 6:30 AM EDT
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Howto compare the columns of 2 diff tables of 2 different schemas in UNIX shell script

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
Sponsored Links
    #2  
Old 03-26-2013
PikK45 PikK45 is offline
Registered User
 
Join Date: Jul 2012
Last Activity: 10 July 2014, 12:57 PM EDT
Location: Chennai
Posts: 567
Thanks: 43
Thanked 74 Times in 72 Posts
@Rajkumar: Give us more information.

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

Example schema will also help. Your query is very vague.
Sponsored Links
    #3  
Old 03-27-2013
Rajkumar Gopal Rajkumar Gopal is offline
Registered User
 
Join Date: Mar 2013
Last Activity: 28 March 2013, 6:30 AM EDT
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
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

Last edited by Rajkumar Gopal; 03-27-2013 at 08:52 AM..
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Shell script to compare ,diff and remove betwen 2 files ajayram_arya Shell Programming and Scripting 3 02-20-2013 04:39 PM
compare/diff two directory in two different linux/unix machine chuikingman Red Hat 3 09-24-2009 10:37 AM
edit columns in unix shell script kingpeejay Shell Programming and Scripting 10 06-22-2009 08:01 PM
compare two tables using shell script dtidke Shell Programming and Scripting 1 06-25-2008 05:34 AM
Converting tables of row data into columns of tables justthisguy Shell Programming and Scripting 7 07-16-2007 04:42 PM



All times are GMT -4. The time now is 02:39 PM.