Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: limit characters returned by a select statement

Re: limit characters returned by a select statement

From: Carlos <kaleeloo_at_caramail.com>
Date: 30 Oct 2001 14:27:06 GMT
Message-ID: <20011030-15276-342764@foorum.com> 






SUBSTR(name_of_the_column,start_here,finish_here)



ex : 


toto = 'THANKS'



select SUBSTR(toto,2,2) from dual;



return this => HA


-- 
User of http://www.foorum.com/. The best tools for usenet searching.


Received on Tue Oct 30 2001 - 08:27:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US