Oracle SUBSTR function How to use SUBSTR and SUBSTR Example Code

Tutorial66.com
@Share Application Development Skill.

Tutorial is tutorial...66 is My Country Code Up to 10 Years EXP for Application Development Role in Thailand.

Pages: [1]

Topic: Oracle SUBSTR function How to use SUBSTR and SUBSTR Example Code (Read 236 times)

My Development skill
Java JSP Servlet EJB
Spring Framework
Hibernate Framework
iReport Jasper Report
Apache CXF
PHP Codigniter
Oracle PLSQL
Unix Shell Script

Oracle SUBSTR function How to use SUBSTR and SUBSTR Example Code

« on: December 28, 2011, 07:27:21 AM »

How to use Oracle SUBSTR
Oracle SUBSTR format

SUBSTR(str,start_position,number_char)

Example Code for Oracle SUBSTR

Code: [Select]


SELECT SUBSTR('ABCDEF',1,3) FROM DUAL --ABC
SELECT SUBSTR('ABCDEF',3,1) FROM DUAL --C 
SELECT SUBSTR('ABCDEF',3,2) FROM DUAL --CD

Logged

2011@Tutorial66.com
Tutorial for JAVA,PHP,DBMS,Web Developer

Oracle SUBSTR function How to use SUBSTR and SUBSTR Example Code

Tutorial Category

Topic: Oracle SUBSTR function How to use SUBSTR and SUBSTR Example Code (Read 236 times)

Oracle SUBSTR function How to use SUBSTR and SUBSTR Example Code