ORACLE/PLSQL: SUBSTR FUN

SUBSTR( string, start_position, [ length ] )

SUBSTR('This is a test', 6, 2)
Result: 'is'

SUBSTR('This is a test', 6)
Result: 'is a test'

SUBSTR('TestOnTheNet', 1, 4)
Result: 'Test'

SUBSTR('TestOnTheNet', -3, 3)
Result: 'Net'

SUBSTR('TechstOnTheNet', -6, 3)
Result: 'The'

SUBSTR('TestOnTheNet', -8, 2)
Result: 'On'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: