+ 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
1 ответ
+ 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')) )