Tuesday, October 20, 2009

SUBSTR in Oracle

Let say we have a data like below in a table :-
ABC12345




We can abstract data using
SUBSTR([column],[position from left],[length]) such as below :-
SELECT SUBSTR(a.mycolumn, 4, 5) FROM mytable a;
will result an output :- 12345

No comments: