| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 display a chart of the printable and space ASCII characters and their codes on your PC's screen | Oracle | Intermediate /
Andy Archer | 1707 since
2/10/2012 12:05:12 PM | Unrated
|
| |
This very compact SQL*Plus script displays a nice chart of the printable and space ASCII characters and their codes on your screen. (This is really just a PL/SQL block with a SET SERVEROUTPUT command stuck on the top). (ScreenShot) |
| |
| |
| |
|
SQL*Plus PIM | Oracle | Advanced /
Andy Archer | 1704 since
2/1/2012 10:43:13 AM |
By 1 Users
|
| |
PIMs were a big deal years ago. Now, by following four simple steps, you'll automagically be able to see pertinent little daily reminders on your PC's screen when you logon to SQL*Plus.(ScreenShot) |
| |
| |
| |
|
Find Longest Or Shortest Length | Oracle | Advanced /
Andy Archer | 4997 since
1/30/2012 11:58:00 AM | Unrated
|
| |
This PL/SQL stored function returns the length of the longest or shortest in_delim-delimited character or string in in_string. With SQL*Plus test script. |
| |
| |
| |
|
Just The Alphas & Just The Digits | Oracle | Beginner /
Andy Archer | 9814 since
1/27/2012 11:24:34 AM |
By 3 Users
3 Excellent Ratings
|
| |
Just_the_alphas is a tiny PL/SQL stored function returning in_string's alphabetic characters as a varchar2 concatenation. Similarly, just_the_digits returns the digits (0123456789). With SQL*Plus test scripts. |
| |
| |
| |
|
Remove Characters | Oracle | Beginner /
Andy Archer | 8350 since
1/27/2012 11:24:30 AM | Unrated
|
| |
Two PL/SQL stored functions. The first returns in_string minus in_set characters. The second, with no loop, returns in_string with up to eight different characters removed (from the first eight in in_set). With SQL*Plus test scripts. |
| |
| |
| |
|
DBMS_JOB job scheduler - INTERVAL examples | Oracle | Advanced /
Andy Archer | 15119 since
1/17/2012 5:09:30 PM |
By 3 Users
3 Excellent Ratings
|
| |
Here are nineteen examples of scheduling jobs to run at different intervals using the DBMS_JOB package. (Intermediate to Advanced). |
| |
| |
| |
|
Find Last Not-Month-End IN_DAY | Oracle | Intermediate /
Andy Archer | 1151 since
1/12/2012 3:28:58 PM | Unrated
|
| |
This little PL/SQL stored function returns the date for the last IN_DAY in IN_DATE's month that is not the last day of the month. With a calling function and SQL*Plus test scripts. |
| |
| |
| |
|
Can Row Be Locked | Oracle | Intermediate /
Andy Archer | 1366 since
1/11/2012 2:29:01 PM | Unrated
|
| |
This little PL/SQL stored function tells you whether or not a particular row in a particular table can be locked. Handy code-saver when you need to know. Just pass it schema name (optional), table name, and ROWID. |
| |
| |
| |
 |
check the free space in your database | Oracle | Advanced /
Andy Archer | 1550 since
12/25/2011 5:50:39 PM | Unrated
|
| |
This SQL*Plus script prompts for a PERCENT USED value, runs SQL to get data on all tablespaces with that percentage (or more) of used space, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
|
Generate Alter Table Statement From Compared Databases | Other | Intermediate /
RuanDV | 1334 since
12/21/2011 11:29:03 AM | Unrated
|
| |
This code will allow you to compare two databases on two different servers (Creating a link between the two).
The code requires you to specify a few parameters that is declared and then from there you execute it and the Alter statement then gets generated ...(description truncated) |
| |
(ScreenShot)
(ScreenShot)
