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;
1.4m articles
1.4m replys
5 comments
57.0k users