| Author |
comparing data of 2 tables dynamically
|
|
| nycman 2005-07-21, 1:23 pm |
| Does anyone has a good script which will compare all the
fields of 2 tables dymically?
| |
| Rene Nyffenegger 2005-07-21, 8:23 pm |
| On 2005-07-21, nycman <lnlx@aol.com> wrote:
> Does anyone has a good script which will compare all the
> fields of 2 tables dymically?
What do you understand by dynamically compare the tables?
Rene
--
Rene Nyffenegger
http://www.adp-gmbh.ch/
| |
| DA Morgan 2005-07-21, 8:23 pm |
| nycman wrote:
> Does anyone has a good script which will compare all the
> fields of 2 tables dymically?
Script? Why? DBMS_RECTIFIER_DIFF built-in package.
Unless you are paid by the hour. ;-)
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
| nycman 2005-07-22, 1:23 pm |
| comparing 2 any tables
| |
| nycman 2005-07-22, 1:23 pm |
| comparing 2 any tables
| |
| pobox002@bebub.com 2005-07-22, 1:23 pm |
| What like these two?
SQL> desc t1
Name Null? Type
--------------------- -------- ----------------
STR VARCHAR2(100)
ID NOT NULL NUMBER
START_DATE DATE
SQL> desc t2
Name Null? Type
--------------------- -------- ----------------
C CLOB
CLOB_ID NUMBER
CREATED DATE
MODIFIED DATE
| |
| Jaap W. van Dijk 2005-07-23, 8:24 pm |
| On 22 Jul 2005 10:57:09 -0700, "nycman" <lnlx@aol.com> wrote:
>comparing 2 any tables
You mean you can specify the tables at runtime, so they are not
hardcoded in the script?
Jaap.
| |
| nycman 2005-07-25, 11:23 am |
| yes!
|
|
|
|