OraFAQ Forum: SQL & PL/SQL » Insert degree symbol?

Home » SQL & PL/SQL » SQL & PL/SQL » Insert degree symbol?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert degree symbol? [message #9752]

Wed, 03 December 2003 02:56

Jeffrey
Messages: 30
Registered: January 2003

Member

Is there a way to insert a degree symbol (the small o as in temperatures) into a oracle column of CHAR?

Report message to a moderator

Re: Insert degree symbol? [message #9753 is a reply to message #9752]

Wed, 03 December 2003 04:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Yes, it is no problem at all:

SQL> create table t(id number, val char(20));

Table created.

SQL> insert into t values (1,'�');

1 row created.

SQL> select * from t;

        ID VAL
---------- --------------------
         1 �

Are you having difficulties with it?
I advise you to use a VARCHAR2 instead of CHAR.

MHE

Report message to a moderator

Re: Insert degree symbol? [message #9754 is a reply to message #9752]

Wed, 03 December 2003 04:43

ramana
Messages: 51
Registered: December 2000

Member

SQL> create table rams ( c char(10));

Table created.

SQL> insert into rams values (chr(176));

1 row created.

SQL> select * from rams;

C
----------
�

SQL> insert into rams values ('146'||chr(176));

1 row created.

SQL> select * from rams;

C
----------
�
146�

SQL>

Report message to a moderator

Re: Insert degree symbol? [message #9765 is a reply to message #9754]

Wed, 03 December 2003 20:33

Jeffrey
Messages: 30
Registered: January 2003

Member

Thanks 4 ur fast reply. It was helpful. :)

Report message to a moderator

Re: Insert degree symbol? [message #9766 is a reply to message #9753]

Wed, 03 December 2003 20:34

Jeffrey
Messages: 30
Registered: January 2003

Member

Thanks for your suggestion. Will consider about changing it to varchar. For the degree symbol, i have a solution already. Anyway thanks for your input.

Report message to a moderator

Re: Insert degree symbol? [message #10404 is a reply to message #9752]

Wed, 21 January 2004 05:50

rhea
Messages: 1
Registered: January 2004

Junior Member

you can do a degree symbol by holding down the ALT key and with your NUMBER LOCK on, type, on the number keypad, 248. It works and is wonderful.

Report message to a moderator

Previous Topic:	PL/SQL - Formatting Table Data
Next Topic:	ROR at Line 1. Create Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:43:34 CDT 2024