result

How do i display the following:

select count(*) from student;

count(*)
--------
12345

but i would like to display the result like this,like adding "*" before the result.

count(*)
-------
*12345

how do i do that

Pls help

SELECT '*' || TO_CHAR(COUNT(*)) FROM student;

thanks

A very strange requirement!

If you're really looking at padding out a field with *'s (as is done on cheques) then look at LPAD.