Home » SQL & PL/SQL » SQL & PL/SQL » substr
substr [message #196147] Wed, 04 October 2006 06:01 Go to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
ipaddress:
---------


234.45.78.9

345.678.89.345

I need each one seperatley using substr and instr


like

345
678
89
345

for the column ipaddress
Re: substr [message #196155 is a reply to message #196147] Wed, 04 October 2006 06:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Homework ?
Re: substr [message #196156 is a reply to message #196147] Wed, 04 October 2006 06:18 Go to previous message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Same qts have appeared in the board just few hrous back…have a look

Naveen
Previous Topic: How to create Batch file for sql
Next Topic: Outer Join Question
Goto Forum:
  


Current Time: Fri Dec 09 01:52:26 CST 2016

Total time taken to generate the page: 0.05590 seconds