str='xyz zyx'
select substr(str,5,7) ||substr(str,1, 3) as str from dual;
Regards
kishore ku Roul
User Profile
Collapse
-
How to exchange a string in oracle sql?
i have string like 'XYZ ZYX'.
I Want to display like 'ZYX XYZ'. -
kishore ku Roul started a topic How to get 1st two characters and last two characters from a column in table?in OracleHow to get 1st two characters and last two characters from a column in table?
Like
column name=ename values= smith,allen.i want to retrieve only smth and alen respectively.
No activity results to display
Show More
Leave a comment: