Home » SQL & PL/SQL » SQL & PL/SQL » how can i write regular expression for this (ORacle10g)
how can i write regular expression for this [message #402995] Wed, 13 May 2009 06:39 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member


Hi,
I have to extract the following name such as, ex. FN_GETTYPE will return only GETTYPE,CRT_SF_LM_TAB will retun SF_LM_TAB
How can I exctract this type of requiremtn shalli used regualr substring function
CRT_SF_LM_TAB
F_GETTRANDTL
F_GETTRANDTL
F_GETTRANDTL
FN_GETMAILINGADDRESS
FN_ISRULETRUELC
FN_RECEIPTS_COUNT
FN_RECEIPTS_RET_CNT
FN_RECEIPTS_STATUS
FN_RECP_RET
INS_CLASSIFICATION_ERROR
P_COLL_LINKCIFID
P_LOAD_ADDRESS_DATA

Re: how can i write regular expression for this [message #402998 is a reply to message #402995] Wed, 13 May 2009 06:45 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You know, there is actually only one way to learn regular expressions: practice.. a lot.
If you are just interested in the final result, you'd probably be better off with using instr and substr, since that will make it easier for you to adjust it to your needs.
Re: how can i write regular expression for this [message #403150 is a reply to message #402995] Wed, 13 May 2009 23:43 Go to previous message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
select substr('CRT_SF_LM_TAB',instr('CRT_SF_LM_TAB','_')+1) from dual
Previous Topic: Getting error :ORA-06531:Reference to unintialized collection (merged)
Next Topic: How to find max value of a variable. (merged)
Goto Forum:
  


Current Time: Sun Dec 04 14:28:04 CST 2016

Total time taken to generate the page: 0.04392 seconds