Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    30

    Unanswered: Oracle SQL Impact Analysis / Reverse Engineering Tool ?

    Hello,

    Can anyone recommend a proprietry tool that performs impact analysis / reverse engineering on hand-coded Oracle SQL statements, so that for each SQL script, it determines exactly how it performs, in terms of what tables / columns are accessed or affected, column mappings on INSERT statements, etc., into some sort of repository ? To give an example, if I had the below example SQL statement :

    INSERT INTO ordered_products
    ( product_id,
    product_name,
    store_id,
    store_name,
    number_ordered
    )
    SELECT /*+ PARALLEL (p 2) */
    p.product_id
    p.product_name,
    s.store_id,
    s.store_name,
    SUM(ol.order_quantity) number_ordered
    FROM
    products p,
    stores s,
    order_line ol
    WHERE
    p.product_id = ol.product_id
    AND ol.store_id = s.store_id
    GROUP BY
    p.product_id
    p.product_name,
    s.store_id,
    s.store_name

    -----------------------------------------------

    It would determine that :

    - ORDERED_PRODUCTS is being inserted into
    - PRODUCTS, STORES, ORDER_LINE is being selected from
    - Column Mappings are as :
    - ORDERED_PRODUCT.PRODUCT_ID > PRODUCTS.PRODUCT_ID
    - ORDERED_PRODUCT.PRODUCT_NAME > PRODUCTS.PRODUCT_NAME
    - ORDERED_PRODUCT.STORE_ID > STORES.STORE_ID
    - ORDERED_PRODUCT.STORE_NAME > STORES.STORE_NAME
    - ORDERED_PRODUCT.NUMBER_ORDERED > ORDER_LINE.ORDER_QUANTITY
    - Hint used is 2 PARALLEL slaves for the PRODUCTS table
    - What columns were used in the WHERE and GROUP BY clause

    So that I have a complete picture of what each SQL script actually does ?
    I have seen one tool, Quest SQL Impact, which performs most of these functions,
    but I was wondering if there were any other tools out there on the market..


    Thanks,
    Adam

  2. #2
    Join Date
    May 2009
    Posts
    3
    PITSS has a tool called Applicaiton Analysis that performs this kind of Analysis or SQL Impact. The tool is call PITSS.con and you can find more information at PITSS America LLC - Oracle Forms Migration Experts under the PITSS.con tab you will see Applicaiton Analysis

Posting Permissions

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