Results 1 to 4 of 4

Thread: help..output

  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Arrow Unanswered: help..output

    set head off;
    set pagesize 0;
    set linesize 200;
    set feedback off;
    set termout off;
    set pause off;
    spool /bistari/dw/sds2/rosrita/fahmi/ogbs01.txt;

    select distinct
    ptt.marketing_ptt_num||'|'||
    exchange.exchange_ident_name||'|'||
    exchange.exchange_ident_code||'|'||
    tel_profile.service_num||'|'||
    customer_profile.customer_name,
    tel_profile.apartment_num||'|'||
    tel_profile.lot_num||'|'||
    tel_profile.house_num||'|'||
    tel_profile.floor_level_code||'|'||
    tel_profile.building_name||'|'||
    tel_profile.street_num_code||'|'||
    tel_profile.street_type||'|'||
    tel_profile.street_name||'|'||
    tel_profile.postal_code||'|'||
    tel_profile.section_name||'|'||
    tel_profile.city_name||'|'||
    tel_profile.state_code||'|'||
    tel_profile.serv_class_code||'|'||
    customer_profile.customer_segment_code||'|'
    from
    temp_ogbs_fahmi,
    tel_profile,ptt,exchange,customer_accounts,custome r_profile
    where
    temp_ogbs_fahmi.service_num = tel_profile.service_num and
    temp_ogbs_fahmi.connect_date = tel_profile.connect_date and
    tel_profile.ptt_num = ptt.network_ptt_num(+) and
    tel_profile.exchange_ident_code = exchange.exchange_ident_code(+) and
    tel_profile.account_num = customer_accounts.account_num(+) and
    customer_accounts.customer_id = customer_profile.customer_id(+);

    set head off;
    set pagesize 0;
    set linesize 200;
    set feedback off;
    set termout off;
    set pause off;
    spool /bistari/dw/sds2/rosrita/fahmi/ogbz02.txt;

    select distinct
    ptt.marketing_ptt_num||'|'||
    exchange.exchange_ident_name||'|'||
    exchange.exchange_ident_code||'|'||
    tel_profile.service_num||'|'||
    customer_profile.customer_name||'|'||
    tel_profile.apartment_num||'|'||
    tel_profile.lot_num||'|'||
    tel_profile.house_num||'|'||
    tel_profile.floor_level_code||'|'||
    tel_profile.building_name||'|'||
    tel_profile.street_num_code||'|'||
    tel_profile.street_type||'|'||
    tel_profile.street_name||'|'||
    tel_profile.postal_code||'|'||
    tel_profile.section_name||'|'||
    tel_profile.city_name||'|'||
    tel_profile.state_code||'|'||
    tel_profile.serv_class_code||'|'||
    customer_profile.customer_segment_code||'|'
    from
    temp_ogbz_fahmi,
    tel_profile,ptt,exchange,customer_accounts,custome r_profile
    where
    temp_ogbz_fahmi.service_num = tel_profile.service_num and
    temp_ogbz_fahmi.connect_date = tel_profile.connect_date and
    tel_profile.ptt_num = ptt.network_ptt_num(+) and
    tel_profile.exchange_ident_code = exchange.exchange_ident_code(+) and
    tel_profile.account_num = customer_accounts.account_num(+) and
    customer_accounts.customer_id = customer_profile.customer_id(+);

    exit;



    should be the data like this

    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx
    xxx xxxxxx xxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxx xx

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    First: this looks more like an Oracle script than MySQL, so this thread should probably be moved.

    Second: "should be the data like this" doesn't explain your problem.

    Are you getting an error message?
    Are you getting wrong data?
    Is the data incorrectly formatted?

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.

  4. #4
    Join Date
    Nov 2007
    Posts
    2

    Unhappy an data not the same

    wrong formatted data..how is it can be ??

Posting Permissions

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