Table Values
Firstname Amount Postalcode Lastname Accountnumber
'Firstname' 'Amount' 'Postalcode' 'Lastname' 'Accountnumber'
In mysql you can use the function concat():
mysql
concat()
SELECT CONCAT("'", CNAME, "'") FROM yourTable
In oracle you can use the same function as above concat() or the concatenation operator:
oracle
concatenation operator
SELECT '''' || CNAME || '''' FROM yourTable; SELECT CONCAT('''', CNAME, '''') FROM yourTable;
2.1m questions
2.1m answers
60 comments
57.0k users