ebizsupport
asked on
How can we print tick mark in SQL prompt using SELECT Statement
How can we print tick mark in SQL prompt using SELECT Statement.like as i have attached image for refence.
TICK.bmp
TICK.bmp
you can import your sql statement into a spreadsheet and run it from there. Then set up conditional formatting for certain conditions. such as highlighting cells, different text etc...
Hi,
You can generate HTML with sqlplus, and have an <img href="http://filedb.experts-exchange.com/incoming/2010/09_w38/347427/TICK.bmp"/> in it.
Regards,
Franck.
You can generate HTML with sqlplus, and have an <img href="http://filedb.experts-exchange.com/incoming/2010/09_w38/347427/TICK.bmp"/> in it.
Regards,
Franck.
ASKER
No,I I just want to print tick in SQL plus like
as we do for select chr('188') from dual;
and output comes as 1/4
No I just want to print tick mark.
as we do for select chr('188') from dual;
and output comes as 1/4
No I just want to print tick mark.
You can use chr(248) to print our the tick mark symbol but it is very small and may not be of any use to you.
You can use below code to generate ascii table:
You can use below code to generate ascii table:
declare
i number;
j number;
k number;
begin
for i in 2..15 loop
for j in 1..16 loop
k:=i*16+j;
dbms_output.put_line((to_char(k,'000'))||':'||chr(k)||' ');
end loop;
end loop;
end;
/
Hi,
What is the database characterset ?
You can get it with:
select * from nls_database_parameters where parameter='NLS_CHARACTERSE T'
Then are you sure that ascii code is 188 for the tick character in that character set ?
Regards,
Franck.
What is the database characterset ?
You can get it with:
select * from nls_database_parameters where parameter='NLS_CHARACTERSE
Then are you sure that ascii code is 188 for the tick character in that character set ?
Regards,
Franck.
ASKER
The following is the character set
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSE T';
PARAMETER VALUE
-------------------------- ---- -------------------------- ---------- ----
NLS_CHARACTERSET WE8ISO8859P1
and
SQL> select chr(188) from dual;
C
-
¼
The above are the output is there any further suggetion,i will highly appreciate the effort.
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSE
PARAMETER VALUE
--------------------------
NLS_CHARACTERSET WE8ISO8859P1
and
SQL> select chr(188) from dual;
C
-
¼
The above are the output is there any further suggetion,i will highly appreciate the effort.
Hi,
In WE8ISO8859P1 the chr(188) is ¼:
http://en.wikipedia.org/wiki/ISO/IEC_8859-1
I don't think that you have the check mark 'tick' in WE8ISO8859P1
Regards,
Franck.
In WE8ISO8859P1 the chr(188) is ¼:
http://en.wikipedia.org/wiki/ISO/IEC_8859-1
I don't think that you have the check mark 'tick' in WE8ISO8859P1
Regards,
Franck.
ASKER
So as your answer suggest that i have to set nls_lang character set as UTF-8 and after that i will be able to get the required output.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Not gor the proper solution just took a work around...
using sql*plus, you can't display an image in the sql prompt.
Aside from displaying an image, what is your requirement? We might be able to come up with a work-around.