slipt a string into 2 word in Oracle PL?SQL

0301102

Hi,

I have a input parameter call DOMAIN_NAME (Example: seng.com.my), and i need slipt it into 2 word, becasue "seng" is the label and ".com.my" is the zone,
so my i know how to slpit it into two word? Or any one have a better idea to solve the mentioned problem? Your help will be appreciated. Thx.

Thanks & Regards
seng

debasisdas

you can use the string functions like length,substring,instring etc for the purpose

madankarmukta

Quote:

Originally Posted by 0301102

Hi,

I have a input parameter call DOMAIN_NAME (Example: seng.com.my), and i need slipt it into 2 word, becasue "seng" is the label and ".com.my" is the zone,
so my i know how to slpit it into two word? Or any one have a better idea to solve the mentioned problem? Your help will be appreciated. Thx.

Thanks & Regards
seng

Hi,

You can makes use of the REgular expression if you are working with Oracle - 8i above.This will be the most generic solution to you question.

Thanks!

amitpatel66

Try This:

Expand|Select|Wrap|Line Numbers

 
SQL> select SUBSTR('seng.com.my',1,INSTR('seng.com.my','.',1,1) - 1) str_1,SUBSTR('seng.com.my',INSTR('seng.com.my','.',1,1)) str_2 from dual

/
 
STR_ STR_2

---- -------

seng .com.my
 
SQL>

slipt a string into 2 word in Oracle PL?SQL

re: slipt a string into 2 word in Oracle PL?SQL

re: slipt a string into 2 word in Oracle PL?SQL

re: slipt a string into 2 word in Oracle PL?SQL

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about