How to concatenate oracle sql output from a select query

Question

Unable to concatenate output from SELECT statement query.

But I want something like:

SS = "start_" + [ID] from [Start Order = 1] ','  "ExecutionT" + [Start_Wait]

SELECT 
    ID, Name, SName, Start_Order, Start_Wait
FROM
    File
WHERE 
    ZONE IN ('west') AND SNAME = 'DA'
ORDER BY 
    START_ORDER

This is my current output:

ID                     SName      Name   Start_Order       Start_Wait
----------------------------------------------------------------------
i-001c9e54bc5a5fabc     DA      DevApp1     1                  3
i-03136748c823abdef     DA      DevApp2     2                  0
i-03c07d9e63eb53fgh     DA      DevApp3     3                  3

Popeye · Accepted Answer · 2019-10-18 15:16:08Z

1

You can concate the column valies as following:

Select col1 || col2 || 'some string' 
from your_table

|| is the concatanation operator in oracle.

Your query should look something like following. Please adjust the constant strings, if not according to your requirement.

SELECT 'SS = start_' 
|| ID 
|| ' from [Start Order = '
|| start_order
|| '] '',''  ExecutionT ['
|| Start_Wait
|| ']'
        from File
           WHERE ZONE IN ('west') AND SNAME = 'DA'
        ORDER BY START_ORDER

Cheers!!

edited Oct 18, 2019 at 15:16

answered Oct 18, 2019 at 15:09

Popeye

36k4 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to concatenate oracle sql output from a select query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related