Select name from TAB1;
output: RAJA
RAMU
SIVA
Sanjay
So my requirement is to display these data in string(With in single Quotes) like below.
'RAJA'
'RAMU'
'SIVA'
'Sanjay'
Answer
------
SELECT ''''||NAME||'''' FROM TAB1;
outout: 'RAJA'
'RAMU'
'SIVA'
'Sanjay'
No comments:
Post a Comment