• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2751
  • Last Modified:

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
0
ebizsupport
Asked:
ebizsupport
1 Solution
 
slightwv (䄆 Netminder) Commented:
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.
0
 
jgiordanoCommented:
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...

0
 
Franck PachotCommented:
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.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
ebizsupportAuthor Commented:
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.
0
 
riazpkCommented:
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

0
 
Franck PachotCommented:
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.
0
 
ebizsupportAuthor Commented:
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.

0
 
Franck PachotCommented:
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.
0
 
ebizsupportAuthor Commented:
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.
0
 
Franck PachotCommented:
Hi,
I don't think that you can get characters that are not in the database characterset.
Regards,
Franck.
0
 
ebizsupportAuthor Commented:
Not gor the proper solution just took a work around...
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now