|
-
You will have to edit the previous example.
Try to play with someting like this:
chr(34)||'PPLI'||chr(39)||','||chr(39)||'PPNC'||chr(34)
Example of output
1* select chr(34)||'PPLI'||chr(39)||','||chr(39)||'PPNC'||chr(34) argument from dual
SQL> /
ARGUMENT
-------------
"PPLI','PPNC"
or something like this:
'PPLI'||chr(39)||','||chr(39)||'PPNC'
Example of output
SQL> select 'PPLI'||chr(39)||','||chr(39)||'PPNC' argument from dual;
ARGUMENT
-----------
PPLI','PPNC
Look up Orcle chr() function. Post additional question here if you need more help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|