| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 How to remove excessive spaces | SQL Server 2000, SQL Server 7.0 | Intermediate /
Kaczyński Grzegorz | 5107 since
10/31/2003 2:37:53 AM |
By 1 Users
|
| |
How to remove excessive spaces from column in your table? Example: how to convert 'dupa___jasiu______pierdzi___stasiu' to 'dupa_jasiu_pierdzi_stasiu' (tested only with varchar) :).
|
| |
| |
| |
|
Insert pipe delimited rows into multiple rows. | SQL Server 2000, SQL Server 7.0 | Intermediate /
Charles Toepfer | 6893 since
10/21/2002 6:09:25 PM | Unrated
|
| |
Take a pipe delimited row, split it out and insert it into multiple rows in a temp table. |
| |
| |
| |
|
 InStrRev | SQL Server 2000 | Advanced /
Brad G Skidmore | 4577 since
4/8/2004 11:48:23 AM |
By 2 Users
|
| |
Returns the position of the last occurrence of one string within another.
|
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 Is It Distinct Characters | Oracle | Intermediate /
Andy Archer | 2658 since
4/17/2008 12:05:44 PM | Unrated
|
| |
Here is a little PL/SQL stored function that returns Y or N to indicate whether or not the IN string is made up of distinct characters. With SQL*Plus test script. |
| |
| |
| |
 |
Is It Only Alphas | Oracle | Intermediate /
Andy Archer | 4891 since
6/25/2008 1:24:47 PM | Unrated
|
| |
PL/SQL does not provide a way to readily determine whether or not a string contains only alphabetic characters. Without looping, this PL/SQL stored function will perform the task. With SQL*Plus test script. |
| |
| |
| |
|
Is It Only Alphas And Digits | Oracle | Intermediate /
Andy Archer | 3522 since
6/25/2008 1:22:52 PM | Unrated
|
| |
Without looping, this little PL/SQL stored function returns Y or N to indicate whether or not the IN string contains only alphabetic characters and digits (0123456789). With SQL*Plus test script. |
| |
| |
| |
|
Is It Only Character Set | Oracle | Intermediate /
Andy Archer | 5364 since
1/21/2010 8:52:04 AM | Unrated
|
| |
Without looping, these two little PL/SQL stored functions return Y or N to indicate whether or not the IN string consists of only characters (one or more) from the IN character set. With SQL*Plus test scripts. |
| |
| |
| |
|
Is It Only Digits | Oracle | Intermediate /
Andy Archer | 4306 since
3/27/2009 8:38:31 AM |
By 2 Users
2 Excellent Ratings
|
| |
PL/SQL does not provide a way to readily determine whether or not a string contains only digits (0123456789). Any of these three PL/SQL stored functions, without looping, will do the job. With SQL*Plus test script. |
| |
| |
| |
|
Is It Only Pattern | Oracle | Advanced /
Andy Archer | 2438 since
7/31/2007 9:59:35 AM | Unrated
|
| |
Without looping, this little PL/SQL stored function returns Y or N to indicate whether or not the IN string consists of only a pattern of a character or string of characters. With SQL*Plus test script. |
| |
| |
| |
|
Is It Only Printable ASCII | Oracle | Intermediate /
Andy Archer | 3792 since
11/29/2007 10:30:07 AM |
By 2 Users
|
| |
This PL/SQL stored function, without looping, returns Y or N to indicate whether or not the IN string contains only printable or space ASCII characters (codes 32 through 126). With SQL*Plus test script. |
| |
