SQL Plus Question:
Explain How do we replace a comma (,) with a blank in a select statement?
Answer:
select empno||' '||ename from emp;
select replace (column name,',','') from table name.
select replace (column name,',','') from table name.
| Previous Question | Next Question |
| Explain What are the data types allowed in a table? | Explain Can a view be updated/inserted/deleted? |