Answer Posted / venkat reddy

1 select e.*,
2 case
3 when
4 comm is null then '0'
5 when
6 comm is not null then
7 to_char(comm) end as comm
8* from emp e
SQL> /

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO COMM
---------- ---------- --------- ---------- --------- ---------- ---------- ---------- ------
7839 KING PRESIDENT 17-NOV-81 5000 10 0
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 0
7782 CLARK MANAGER 7839 09-JUN-81 2450 10 0
7566 JONES MANAGER 7839 02-APR-81 2975 20 0
7788 SCOTT ANALYST 7566 19-APR-87 3000 20 0
7902 FORD ANALYST 7566 03-DEC-81 3000 20 0
7369 SMITH CLERK 7902 17-DEC-80 800 20 0
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 300
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 500
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 1400
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 0
7876 ADAMS CLERK 7788 23-MAY-87 1100 20 0
7900 JAMES CLERK 7698 03-DEC-81 950 30 0
7934 MILLER CLERK 7782 23-JAN-82 1300 10 0

14 rows selected.

what are integrity rules?

1022

---

What are the events on which a database trigger can be based?

1180

---

What is the syntax and use of the coalesce function?

1168

---

How do I view tables in sql developer?

935

---

what is the difference between delete and truncate statement in sql? : Sql dba

1239

---

What is trigger types of trigger?

1066

---

what is a cursor? : Sql dba

1021

---

Is sql a microsoft product?

946

---

What does where 1/2 mean in sql?

1065

---

explain advantages of innodb over myisam. : Sql dba

1126

---

What is where clause in sql?

1037

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1425

---

How do I debug a stored procedure?

1111

---

What is the command used to fetch the first 5 characters of a string?

1207

---

What is null in pl/sql?

1067

---