Become a Premium Member and unlock a new, free course in leading technologies each month.
Go Premium for a chance to win a PS4. Enter to Win
drop table tab1 purge;
create table tab1(key varchar2(10), value varchar2(10));
drop table tab2 purge;
create table tab2(col1 varchar2(50));
insert into tab1 values('MI','Miles');
insert into tab1 values('FT','Feet');
insert into tab2 values('Speed is 2 MI per hour');
insert into tab2 values('What about the name Miller?');
insert into tab2 values('Speed is 2 MI per hour 2 FT per second');
create or replace function myConvert(inStr in varchar2) return varchar2 is
retval := ' ' || inStr || ' ';
for i in (select key, value from tab1) loop
retval := replace(retval,' ' || i.key || ' ',' ' || i.value || ' ');
select myConvert(col1) from tab2;
Open in new window
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Author Closing Comment
Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!