OraFAQ Forum: SQL & PL/SQL » How to Insert ' character with concatination

Home » SQL & PL/SQL » SQL & PL/SQL » How to Insert ' character with concatination - oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Insert ' character with concatination - oracle [message #10058]

Mon, 29 December 2003 20:14

Satish Bharadwaj
Messages: 8
Registered: December 2003

Junior Member

I have to select some of the column from a table, and
Columns are of datatype Varchars.

Sample Query
select 'USER NAME:' || USERNAME || ' PASSWORD "' || PASSWORD || '' from USER_SECURITY ;

Sample REQUIRED OUTPUT IS :

USER NAME:SYSTEM PASSWORD 'PASS1'

Please send me how to get the password in ' ' Quotes.

thanks

Report message to a moderator