PL/SQL (MOSC)

MOSC Banner

how to take first letter of 1 column and the whole word of another columns

edited Jul 13, 2017 2:57PM in PL/SQL (MOSC) 9 commentsAnswered ✓

Hi

please advice or give an example i want to a table with columns  First_name and Last_name and i want to create insert it in a third different column DB_USER

example

Table  - columns   First_name  Last_name    

                             Jesus           Gutierrez

and the function or code insert it into a third column

                             DB_USER

                             JGUTIERREZ  

Please advice

Jesus

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center