Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    7

    Unanswered: Oracle view error

    I am trying to convert an Informix query to Oracle:

    The Informix query looks like this:

    from backlog_fact x0 ,sd_part_sale_dim x1
    ,sd_part_dim x2 ,time_dim x3 ,time_dim x4 ,outer(time_dim x5 ) ,outer(time_dim x6 ) ,outer(usap_time_dim x7 ) ,outer(eu_time_dim x8 ),
    sd_customer_dim x9 ,outer(oms_prod x10 ) ,outer(jp01_time_dim x11 ) ,sd_cust_sale_dim x12 ,outer(jp02_time_dim x13 )

    where (((((((((((((x0.curr_pln_gi_dt = x5.day_date ) AND (x0.part_sale_key = x1.part_sale_key ) )
    AND (x0.part_key = x2.part_key ) ) AND (x0.req_deliv_date = x3.day_date ) )
    AND (x0.created_on = x4.day_date ) ) AND (x0.forecast_firm_dt = x6.day_date ) )
    AND (x0.curr_pln_gi_dt = x8.day_date ) ) AND (x0.curr_pln_gi_dt = x7.day_date ) )
    AND (x0.sold_to_key = x9.customer_key ) ) AND (x1.part_num = x10.product ) )
    AND (x0.curr_pln_gi_dt = x11.day_date ) ) AND (x0.cust_sale_key = x12.cust_sale_key ) )
    AND (x0.curr_pln_gi_dt = x13.day_date ) )


    I am not sure how to join the these tables.

    Can any one help me?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    how is this problem different from one in URL below?

    http://www.dbforums.com/oracle/17011...iew-error.html
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2007
    Posts
    253
    First thing would be t learn the oracle syntax for building joins between tables.
    Here you go:
    Joins

Posting Permissions

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