Search This Blog

Total Pageviews

Tuesday, 5 October 2010

Quotes in Strings ----- Oracle Q-quote

select q'[dfdsfhgdaskghfkdskhdasfhfkjhasfsaf]' from dual;


Q'[DFDSFHGDASKGHFKDSKHDASFHFKJHASF
----------------------------------
dfdsfhgdaskghfkdskhdasfhfkjhasfsaf




SQL> select q'[What ever stuff you'd like to see, just as you'd like to see it.]' string from dual;

STRING
----------------------------------------------------------------
What ever stuff you'd like to see, just as you'd like to see it.



select q'[dfdsfhgda'fdhf'hdjasdkjhsakd'klsadjlsd'''ksjadljd''']' from dual
2 /

Q'[DFDSFHGDA'FDHF'HDJASDKJHSAKD'KLSADJLSD'''KSJADLJD
----------------------------------------------------
dfdsfhgda'fdhf'hdjasdkjhsakd'klsadjlsd'''ksjadljd'''

No comments:

Oracle DBA

anuj blog Archive