OraFAQ Forum: Client Tools » temperature symbol required

Home » Other » Client Tools » temperature symbol required (oracle 10g, window Xp)

Wed, 23 May 2012 00:22

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

I need to print temperature along with its symbol.
how it is possible in oracle reports?
for example 45 (degree centigrade in symbol format.)

Wed, 23 May 2012 00:50

Littlefoot
Messages: 21783
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Find its ASCII code and display it as (for example 25 degrees)

SQL> select '25' || CHR(176) twenty_five_degrees from dual;

TWE
---
25°

SQL>

Wed, 23 May 2012 01:06

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

thanks a lot dear.
you are always a great help.

Wed, 23 May 2012 01:10

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Take care that this character may not have 176 as code point in your character set.
Check using:

select ascii('°') from dual;

Regards
Michel

Wed, 23 May 2012 01:27

Littlefoot
Messages: 21783
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's why I said "find its ASCII code and ...".

Wed, 23 May 2012 01:29

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, I understood but I'm not sure OP actually understood and did not directly take our 176.

Regards
Michel

Previous Topic:	SQL for saving the query result in a txt file (2 Merged)
Next Topic:	inserting a data with substitutuion variable

Goto Forum:

]

Current Time: Mon Oct 02 00:11:32 CDT 2023