| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 virtual Magic 8-Ball | Oracle | Advanced /
Andy Archer | 11202 since
1/26/2013 6:33:17 PM |
By 1 Users
|
| |
The virtual Magic 8-Ball SQL*Plus script will answer any yes-or-no question. Just ENTER your question, shake the screen vigorously, and press ENTER. Just like the real thing, but without the icosahedral die suspended in liquid. Mystical. (ScreenShot) |
| |
| |
| |
|
SQL*Plus "I'm thinking of a number between 1 and 10" game | Oracle | Advanced /
Andy Archer | 3708 since
1/21/2013 5:37:52 PM | Unrated
|
| |
Just for fun. You against the computer. Yeah, I know ...that old thing. But hey, it's just for fun. With a bonus between-1-and-100 version. |
| |
| |
| |
|
six specialized Select statements | Oracle | Intermediate /
Andy Archer | 10541 since
1/10/2013 9:14:28 AM |
By 2 Users
2 Excellent Ratings
|
| |
(1) Find the longest string in a column. (2) Find the longest string of a repeating character in a column. (3) Call or (4) validate a PL/SQL function. (5) Lock rows when you query them. (6) Get the latest ten rows in a table. |
| |
| |
| |
 |
 Age in years and months. | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 3085 since
1/2/2013 2:30:45 PM | Unrated
|
| |
May a times were are faced with situation to find the age of person.
Below mentioned code finds the age of person in years and months.
|
| |
| |
| |
|
SQL*Plus - back to the future with CMD ("DOS") | Oracle | Beginner /
Andy Archer | 1987 since
1/2/2013 2:28:47 PM | Unrated
|
| |
Sqlplusw.exe, the Windows GUI version of SQL*Plus, goes away in Oracle's RDBMS 11g. But sqlplus.exe, the CMD (command line) version, is still available on your PC. This short write-up shows how you can easily make the switch. |
| |
| |
| |
|
find all server PL/SQL where <string> appears | Oracle | Advanced /
Andy Archer | 8023 since
12/10/2012 2:53:04 PM |
By 1 Users
|
| |
This script solicits a string at the SQL*Plus prompt, does a BULK COLLECT to find all server PL/SQL user source where the string appears, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
|
 Stored procedure to know vital SQL Server statistics | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 1890 since
11/15/2012 1:42:59 PM | Unrated
|
| |
SP_Monitor:
SQL Server itself tracks how much and what work it has done through series of functions. Here is the stored procedure showing the same. The numbers are displayed in form number(number)-number%. The first number shows number of seconds since sq ...(description truncated) |
| |
| |
| |
|
Format Number | Oracle | Beginner /
Andy Archer | 10486 since
11/8/2012 4:09:29 PM |
By 2 Users
|
| |
This tiny PL/SQL stored function, on a TO_CHAR of in_number, replaces the significant-digit format model's comma with any character (or characters) of your choosing, returning the formatted number as varchar2. With SQL*Plus test script. |
| |
| |
| |
|
Count Integer Places & Count Fractional Places | Oracle | Advanced /
Andy Archer | 12659 since
11/8/2012 4:09:27 PM |
By 1 Users
|
| |
Without looping, these tiny PL/SQL stored functions return the number of places to the left or right of the input number's decimal point, respectively. With both-in-one version and SQL*Plus test scripts. |
| |
| |
| |
|
display your pertinent SQL*Plus session info on your PC's screen with this little script | Oracle | Advanced /
Andy Archer | 2310 since
9/24/2012 4:13:03 PM | Unrated
|
| |
See your pertinent SQL*Plus session info (and some other stuff) on your PC's screen when you run this little script at the prompt. Nice and compact. (Intermediate to Advanced).(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
