| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 AI, Pattern Recognition | Oracle | Advanced /
Miro Brada | 7853 since
6/12/2006 7:24:34 AM |
By 3 Users
2 Excellent Ratings
|
| |
I present a pattern recognition problem through simplified pictures and random patterns. The PatternRecognition.zip file includes 1) PatternRecognition.doc file with detailed explanation of the pattern recognition and commented SQL scripts and analyses, 2 ...(description truncated) (ScreenShot) |
| |
| |
| |
|
 An application of Benford's Law using SQL | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Oracle | Beginner /
Justin Beerley | 10871 since
10/22/2009 9:03:44 AM |
By 2 Users
|
| |
Benford's Law maintains several purposes, one of which is forensic accounting. Condsider the fact that people who make up figures tend to distribute their digits fairly uniformly, a simple comparison of first-digit frequency distribution from the data wit ...(description truncated) |
| |
| |
| |
|
 Birth Database | Other | Beginner /
Ca2 | 9139 since
5/16/2004 11:00:27 AM | Unrated
|
| |
The code makes a new table, insert birth, location and name. Then show it with SELECT(ScreenShot) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Count Matches | SQL Server 7.0 | Advanced /
Lewis E. Moten III | 9958 since
2/22/2002 1:31:50 PM |
By 1 Users
|
| |
Allows you to count how many times a string appears within another string. example - count carriage returns within text. Handles up to 8K characters. Tricks can get around 8K limit for large text fields. |
| |
| |
| |
|
DB Object Report | SQL Server 7.0, Other | Beginner /
MisterD | 13445 since
6/28/2001 9:49:14 PM |
By 2 Users
2 Excellent Ratings
|
| |
Script to report on number of foreign keys, primary keys, indexes, triggers, views, tables (user and system), stored procedures, defaults and rules. Great for comparing two or more DB's against a known master copy, etc. |
| |
| |
| |
 |
display your pertinent SQL*Plus session info on your PC's screen with this little script | Oracle | Advanced /
Andy Archer | 2309 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) |
| |
| |
| |
|
find session info | Oracle | Advanced /
Andy Archer | 4752 since
4/17/2009 9:14:22 AM | Unrated
|
| |
This SQL*Plus script runs SQL to find some useful session info from V$ views and other sources, spools the results to a file, and opens the file in Notepad. A handy look at session data. |
| |
| |
| |
|
Get Data Statistics For All Tables | SQL Server 2000, SQL Server 7.0 | Advanced /
Tim Watts | 5920 since
10/4/2007 11:19:20 AM | Unrated
|
| |
These procedures will help in analyzing your data. They will look at all tables owned by the given user within the given database. Each column in the table will be analyzed, if the column contains less than 20 unique values the spread of the data will be ...(description truncated) |
| |
| |
| |
|
Ip grabber | Other | Beginner /
Bossman | 9390 since
12/12/2002 11:37:46 PM | Unrated
|
| |
A simple script that can register your visitor's ip address on an external file. No database required |
| |
| |
| |
|
Quick Table Row Counts | SQL Server 2000, SQL Server 7.0 | Intermediate /
Rob Waibel | 15846 since
5/27/2004 4:57:56 PM |
By 6 Users
5 Excellent Ratings
|
| |
Just run it from Query Analyzer and choose a DB.
No modification is needed. It saves a great deal of time in getting counts in an entire DB.
|
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
