How do I write a Oracle SQl query for this tricky question...
- by atrueguy
Here is the table data with the column name as Ships.
+--------------+
Ships |
+--------------+
Duke of north |
---------------+
Prince of Wales|
---------------+
Baltic |
---------------+
In the Outcomes table, transform names of the ships containing more than one space, as follows:
Replace all characters between the first and the last spaces (excluding these spaces) by symbols
of an asterisk (*). The number of asterisks must be equal to number