Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[4.2EA] Formatter removes space to the right of the keyword, 'PRIOR'

Patrick BaconOct 3 2016 — edited Oct 4 2016

When I format this hierarchacal query, the space to the right of the "prior" keyword is removed:

    SELECT

        level,

        prod_fmd.formula_id,

        prod_fmd.organization_id,

        prod_fmd.inventory_item_id prod_inventory_item_id,

        ing_fmd.inventory_item_id ing_inventory_item_id

    FROM

        apps.fm_matl_dtl prod_fmd

        JOIN

            apps.fm_matl_dtl ing_fmd

        ON

            1 = 1

        AND

            prod_fmd.formula_id = ing_fmd.formula_id

        AND

            prod_fmd.line_type = 1

        AND

            ing_fmd.line_type =-1

        JOIN

            apps.fm_form_mst_b fm

        ON

            ing_fmd.formula_id = fm.formula_id

        AND

            fm.formula_status = 700

    WHERE

        1 = 1

    START WITH

        ing_fmd.inventory_item_id = (

            SELECT

             MAX(inventory_item_id)

            FROM

                apps.mtl_system_items_b

            WHERE 1=1

               AND

            enabled_flag = 'Y'

              AND

            segment1 =:item_name

        )

    CONNECT BY

        ing_fmd.inventory_item_id = PRIOR prod_fmd.inventory_item_id

it becomes:

PRIORprod_fmd.inventory_item_id

This post has been answered by Vadim Tropashko-Oracle on Oct 4 2016
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 1 2016
Added on Oct 3 2016
1 comment
228 views