Single quote output in sql

Question

Table values

CNAME

Firstname
Amount
PostalCode
Lastname
Account Number

REQUIRED O / P

CNAME

'Name'
'Amount'
'' PostalCode
'LastName'
"Account Number"

Answer 1

In mysqlyou can use the function concat():

SELECT CONCAT("'", CNAME, "'") FROM yourTable

In oracleyou can use the same function as above concat()or concatenation operator:

SELECT '''' || CNAME || '''' FROM yourTable;
SELECT CONCAT('''', CNAME, '''') FROM yourTable;