Home » SQL & PL/SQL » SQL & PL/SQL » Select u'' from dual; What does u mean? in this sql. (Oracle 11G, 2.0.1)
Select u'' from dual; What does u mean? in this sql. [message #665356] Fri, 01 September 2017 05:15 Go to next message
chrisindya
Messages: 29
Registered: July 2017
Junior Member
Can anyone please clarify thie below sql.

Select u'' from dual;

What is is meaning of u? Since Opensource ERP used this sql in Views.
Re: Select u'' from dual; What does u mean? in this sql. [message #665357 is a reply to message #665356] Fri, 01 September 2017 05:28 Go to previous messageGo to next message
Alien
Messages: 275
Registered: June 1999
Senior Member
The u is a prefix that the string includes Unicode character strings:

SQL> select chr(222),u'\00DE' from dual;

C U
- -
Þ Þ

Regards,

Arian
Re: Select u'' from dual; What does u mean? in this sql. [message #665411 is a reply to message #665357] Tue, 05 September 2017 04:11 Go to previous message
chrisindya
Messages: 29
Registered: July 2017
Junior Member
Thanks for the timely response.. greatly helped me to convert oracle queries to postgresql... thanks again...
Previous Topic: the records with common cust_id should not be shown.
Next Topic: PLSQL Procedure to Grant Privs on Schema Objects
Goto Forum:
  


Current Time: Wed Dec 13 21:44:37 CST 2017

Total time taken to generate the page: 0.01250 seconds