+ 1

Do we can use superscript and subscript in oracle and sql? If yes then what is the query for it.

superscript and subscript in Oracle and sql

18th Jan 2017, 7:28 AM
Deepika Behera
Deepika Behera - avatar
1 Réponse
+ 2
In unicode,there are superscripts for 1,2,3 only. Also some other superscript characters are available like ™. So, we cannot directly store other superscript characters in SQL. For that, you will need a "mapping function". And instead of varchar, use nvarchar as your data type. For Oracle database, it is nvarchar2. Query (oracle) create table Mytable ( n number, sup nvarchar2(10) ) insert into Mytable (n, sup) values ( 1, 'x' || SYS.utl_raw.cast_to_nvarchar2(hextoraw('00b9')) )
18th Jan 2017, 8:12 AM
Sourabh Deoghare
Sourabh Deoghare - avatar