Insert String Literal in SQL Output 1

[Michael42]

Hello,

In Oracle 9i sqlplus, if I have SQL that looks like this:
SELECT user,location FROM mytable and produces something like this:

user   location
------ --------
bjones Dallas
jsmith Miami

How can I insert text that will not replace a field output but add text description?

Example desired output:

    user       location
    ------     --------
ABC bjones XYZ Dallas
ABC jsmith XYZ Miami

Thanks,

Michael42

 

[LKBrwnDBA]

Use the concatenation operator:

SELECT 'ABC '||user,'XYZ '||location FROM mytable;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Michael42]

LKBrwnDBA,

Thanks!

Hey one more question on this please...

How can I output single quotes - example desired output:

    user         location
    ------       --------
ABC bjones 'XYZ' Dallas
ABC jsmith 'XYZ' Miami

Thanks,

Michael42

 

[PHV]

SELECT 'ABC '||user,'''XYZ'' '||location FROM mytable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886