Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36

    Unanswered: Ora Data Comparison

    Hi How can i campare the Data of two oracle tables directly?
    (I'm not asking for comparing two schemas)
    Is there any tool for this?

    Thanks for ur time.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Ora Data Comparison

    Don't know of a tool as such. You can easily compare using SQL though, e.g.

    SELECT a,b,c FROM table1
    MINUS
    SELECT a,b,c FROM table2

    shows rows that are in table1 but not in table2

  3. #3
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36
    Hi thanks for ur suggestion....
    But,what i need exactly is,
    If suppose i'm having a table T1 with some data.
    Then i'm creating snapshot ST1 for this T1 table.
    Next,i'm passing some SQL queries to modify some data of Table T1.
    Now,i've to campare the Data of these two tables T1 & ST1 to check the data modification.
    How can i do this???

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    Try using Outter Joins.
    SATHISH .

  5. #5
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36

    array in pl/sql

    Hi,
    How can i use array type inside pl/sql block??

    Actually,i want to fetch values of a column first.then,i've to store the values into an array.
    how can i do this?
    thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •