SQL Plus Interview Question:

Explain How do we replace a comma (,) with a blank in a select statement?

Submitted by: Administrator

select empno||' '||ename from emp;

select replace (column name,',','') from table name.
Submitted by: Administrator