Travelling Cats
Powerbuilder, SQL, Oracle, My Little Sister & Me
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment