troubleshooting Question

String Validation using SQL!

Avatar of MIHIR KAR
MIHIR KARFlag for India asked on
Oracle DatabaseSQL
10 Comments1 Solution99 ViewsLast Modified:
Hi Expert,

How to convert the input string to given O/P? using Oracle Sql,

Table : Name

ENAME_iNPUT
--------------------
kalia
kalia  jag
kalia  jag  jagdish
kalia  jag  jagdish  acharya

Expected O/P-
-------------------
kali
kaja
kajj
kjja

It display according to words if one word then it display 1st 4 character and 2 word then display 2 char from 1st word and 2nd char from 2nd word and so on
Please share the select statement how to achieve this using SQL?

Thanks.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros