Link to home
Start Free TrialLog in
Avatar of ebizsupport
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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

What tool/language?

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.
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.
Avatar of ebizsupport

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.
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:

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;
/

Open in new window

Hi,

What is the database characterset ?
You can get it with:
select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

Then are you sure that ascii code is 188 for the tick character in that character set ?

Regards,
Franck.
The following is the character set

SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

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.
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
Avatar of Franck Pachot
Franck Pachot
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Not gor the proper solution just took a work around...