Need help with formating 2

[rogers42]

Hi,

Sample Data:
============
AAAAA
BBBB
CCCC

Desired Output:
================
'AAAAA',
'BBBBB',
'CCCCC'

My query looks as follows

select '''||distinct(MAC_ADDR)||'','
from MAC;

The compiler keeps complaining about the strings being not properly terminated.

Can somebody please revise my query ?

Thanks in advance

rogers42

 

[SantaMufasa]

Rogers,

You are soooooo close:

select ''''||name||'''' from s_region;

''''||NAME||''''
----------------------
'North America'
'South America'
'Africa / Middle East'
'Asia'
'Europe'
'Australia'

Notice that the first and last characters of a literal (in Oracle) must be single quotes. Then, if you want to embed within a string literal a single quote, you must use two successive single quotes (apostrophes). Thus, if you want a string that contains one single quote, you achieve it with four successive single quotes.

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[rogers42]

Thanks, this makes sense. However, the compiler is complaining about the "distinct" keyword

select ''''|| distinct(MAC_ADDR)||''','
from MAC;

ERROR at line 1:
ORA-00936: missing expression

Thanks

rogers42

 

[LKBrwnDBA]

Distinct is not a function, try:

select distinct ''''||MAC_ADDR|''','
  from MAC;

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