|
|
| Submitted on: 4/15/2001 4:28:53 AM
By: Jason
Level: Beginner
User Rating:
By 1 Users
Compatibility:Oracle
Users have accessed this article 5893 times.
| |
| | | You can use negative numbers with the SUBSTR functions in Oracle.
| |
| |
Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use
this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description. | | Normally you would use a SUBSTR function to clip out sub-strings of data. This would be in the form of "SUBSTR (Phone, 5)" which would eliminate the area code of a list of phone numbers. This works fine if you know the length of data being queried. If you have a column of data that has variable lengths and you only want the last 4 characters you can use a negative number with your query. "SUBSTR(Var_data, -4)" will return only the last 4 characters in your column regardless of the data length. This method saves time and computation cycles because you do not have to check data lengths before doing SUBSTR functions.
| |
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
5/9/2001 6:58:54 PM:Foofoo
Slick, that'll come in handy.
Thanx.
|
5/14/2002 8:03:43 AM:vilas
What is new in that??
I think this is
known by all SQL programmer.
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular article, please click here.
|
|
