Home » SQL & PL/SQL » SQL & PL/SQL » a simple query
a simple query [message #251088] Thu, 12 July 2007 06:42 Go to next message
p.bhaskar
Messages: 33
Registered: February 2007
Location: kolkata
Member
hi
i have a column which has data like this--

java,oracle,xml

now i want to find out number of ',' in column
Re: a simple query [message #251092 is a reply to message #251088] Thu, 12 July 2007 06:48 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Search the SQL Reference guide for INSTR
Re: a simple query [message #251093 is a reply to message #251088] Thu, 12 July 2007 06:48 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
SQL> SELECT LENGTH('java,oracle,xml')
  2         -
  3         LENGTH(REPLACE('java,oracle,xml',',')) x
  4  FROM   dual
  5  /

         X
----------
         2


MHE
Previous Topic: 2 CURSORS - access 1 cursor for processing???
Next Topic: PLSQL Tables!!! A little Help Reqd
Goto Forum:
  


Current Time: Wed Dec 07 20:17:41 CST 2016

Total time taken to generate the page: 0.05284 seconds