SQL & PL/SQL

Hi All,

Can anyone please tell me how can I format my output with replacing a column value with a specific value which actually depends on the present value of the column

I am executing the following SQL statement

select state,count(id) from <table_name> where composite_dn= <composite_dn_name> group by state;
My Present output is:

State No.Of Instance
1 3
3 28

I want to replace the value in the column state as follows

State No.OfInstances
Completed 3
Faulted 28

I want "1" to be reppaced by "Completed" and "3" to be replaced by "Faulted"

Is is possible with SQL or PL/SQL , if it is then how can I achieve this required result. Please help!!

Thanks in Advance!!

Edited by: Roshni Shankar on Oct 27, 2012 12:38 AM