OraFAQ Forum: SQL & PL/SQL » Select u'' from dual; What does u mean? in this sql.

Home » SQL & PL/SQL » SQL & PL/SQL » Select u'' from dual; What does u mean? in this sql. (Oracle 11G, 2.0.1)

Fri, 01 September 2017 05:15

chrisindya
Messages: 33
Registered: July 2017

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.

Fri, 01 September 2017 05:28

Alien
Messages: 291
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

Tue, 05 September 2017 04:11

chrisindya
Messages: 33
Registered: July 2017

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: Fri Apr 19 20:42:26 CDT 2024