samedi 25 avril 2015

Query to get number of stars = length of string in the next row in Oracle 10g


is there any SQL query in Oracle10G which can give the desired output as given required in below sample. Query should print the name first and in the second row it should print the stars equal in number with the length of the string.

Could you please help?

Below is the sample of table column

JIM JOHN MICHAEL

and the output should come like below :

JIM


JOHN


MICHAEL



Aucun commentaire:

Enregistrer un commentaire