Author Topic: How to use SUBSTR in Oracle  (Read 127 times)

0 Members and 1 Guest are viewing this topic.

Offline MrSpecialist

  • Sr. Member
  • *
  • Posts: 342
  • Karma: +1/-0
  • I'm an expert!
    • View Profile
How to use SUBSTR in Oracle
« on: November 14, 2008, 09:22:46 AM »
SUBSTR(char, m [, n])

Returns a portion of Char, beginning at character M, N characters long.
If M is positive, Oracle counts from the beginning of Char to find the first character.
if M is negative, Oracle counts backwards from the end of Char.
If N is omitted, Oracle returns all characters to the end of Char.

Techronnati | where technology never sleeps

How to use SUBSTR in Oracle
« on: November 14, 2008, 09:22:46 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
114 Views
Last post August 24, 2008, 04:33:09 PM
by h2obubbler
0 Replies
133 Views
Last post September 10, 2008, 06:34:26 AM
by JusticeLeague
0 Replies
119 Views
Last post November 11, 2008, 04:50:25 AM
by Corps
0 Replies
121 Views
Last post November 11, 2008, 04:51:17 AM
by Corps
0 Replies
118 Views
Last post November 11, 2008, 04:52:14 AM
by Corps

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.