How to exchange a string in oracle sql?

[kishore ku Roul]

i have string like 'XYZ ZYX'.
I Want to display like 'ZYX XYZ'.

[snehasismishra1]

Hi Kishore,

You can use below query. I have tested in sql server.

DECLARE @FullName        VARCHAR(100)
SET @FullName = 'XYZ ZYX'

SELECT SUBSTRING(@FullName,5,7)+
       SUBSTRING(@FullName,1,3)

Please mark as reply if it suits you.

Thanks,
Snehasis

[kishore ku Roul]

str='xyz zyx'
select substr(str,5,7) ||substr(str,1, 3) as str from dual;

Regards
kishore ku Roul

[rski]

Or something like that

declare
vi varchar2(10);
vo varchar2(10);
begin
vi:='XYZ ZYX';
select regexp_replace(vi,'([^ ]+) ([^ ]+)','\2 \1') into vo from dual
end;

[praveent]

IT'S SIMPLY BY USING TRANSLATE FUNCTION
SELECT 'XYZ ZYX',TRANSLATE( 'XYZ ZYX','XZ','ZX') FROM DUAL
--Only Display purpose