PL/SQL (MOSC)

MOSC Banner

Query result merge/ format

edited Mar 15, 2016 5:02AM in PL/SQL (MOSC) 4 commentsAnswered

I have four different SQL as below.. I want to merge in one SQL and display all records in below format.

          

TEST_INSTANCE_IDMAXSPLICELOSSWAVELENGTHTEST_INSTANCE_IDTEST_INSTANCE_IDWAVELENGTH_ELEMENT_EXTTEST_INSTANCE_IDAPPLYMINLINKLOSSTEST_INSTANCE_IDLINK_ORL_EXT
2812115502812LinkEnd, EndOfFiber, NotOnLink13102812TRUE281232.6
2812None1550 281232.52
2812LinkEnd, EndOfFiber, NotOnLink1550 281233.04
2812LinkEnd, EndOfFiber, NotOnLink1490
2812LinkStart1490
2812None1490

 

SELECT DISTINCT VET.TEST_INSTANCE_ID,

    VET.MAXSPLICELOSS,

    VET.WAVELENGTH

  FROM V_ECBIIOLM_ELETHRESHOLDSGRP VET

  WHERE VET.PARAM_GROUP_ID IN (1550,15502,15504,15508,155016,155032,155064,1550128,1233989949,1749708779)

  AND VET.TEST_INSTANCE_ID  = 2812;

 

  SELECT DISTINCT IED.TEST_INSTANCE_ID,

    IED.TYPE_ADD_INFO_ELEMENT,

    IED.WAVELENGTH_ELEMENT_EXT

  FROM IOLM_ELEMENT_DETAILS IED

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center