SQL Performance (MOSC)

MOSC Banner

sql formatting

edited May 7, 2015 10:03AM in SQL Performance (MOSC) 3 commentsAnswered

SELECT report_id, NODE_HIERARCHY,TEST_STATUS, TEST_VERDICT, TEST_COMMENTS, TEST_TYPE FROM TESTFLOW_TEST_RESULTS   WHERE TEST_TYPE = 'fip' and report_id=1304;

SELECT report_id, NODE_HIERARCHY,TEST_STATUS, TEST_VERDICT, TEST_COMMENTS, TEST_TYPE FROM TESTFLOW_TEST_RESULTS   WHERE TEST_TYPE = 'iolm' and report_id=1304;

SELECT report_id, NODE_HIERARCHY,TEST_STATUS, TEST_VERDICT, TEST_COMMENTS, TEST_TYPE FROM TESTFLOW_TEST_RESULTS   WHERE TEST_TYPE = 'iolm' and report_id=1304;

1st return 18 raws, 2nd return 3 raws, 3rd retun 3 raws.

I need below output..

1st sql result                                                                           2nd sql result                                                                           3rd sql result

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

OVP1|ToOVP2|Alpha|Alpha-OVP1-ToOVP2-A                     

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