Update Oracle table with a period (.)

[barnard90]

I have an employee table with Employee names

All the Employees are supposed to end with a Full Stop (.)

The data should be like

Empno Empname
-----------------------

101 John Williams.
102 Tracy Roberts.
103 Alice Hilton
104 Joseph Fowler.


But there are some records which are not ended with a Full stop

How do I a write an update query in Oracle to convert all the records to end with a Full Stop(.)

Thanks

 

[LKBrwnDBA]

Try:

Update EMP
   Set Empname = Empname||'.'
 Where SUBSTR(Empname,-1,1) != '.';

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb