How do I write a Oracle SQl query for this tricky question...
Posted
by atrueguy
on Stack Overflow
See other posts from Stack Overflow
or by atrueguy
Published on 2010-06-05T16:36:20Z
Indexed on
2010/06/05
16:42 UTC
Read the original article
Hit count: 241
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
© Stack Overflow or respective owner
