| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Create Sample Data using Multiple Cursors | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
T Runstein | 9149 since
3/2/2001 11:29:48 AM |
By 3 Users
|
| |
Shows how to create a table and populate it with sample data. Also demonstrates how to use multiple cursors concurrently. Lots of comments to help you customize this for your own needs. T Runstein |
| |
| |
| |
|
 Create thousand Data Base users quickly | Oracle | Advanced /
N.D.I.Samantha | 5500 since
1/1/2004 7:16:05 AM | Unrated
|
| |
Create thousand Data Base users quickly. |
| |
| |
| |
|
 Creating Grids | SQL Server 7.0 | Intermediate /
Lewis E. Moten III | 6928 since
6/15/2002 10:25:39 AM |
By 2 Users
2 Excellent Ratings
|
| |
Explains how to create grids and walks through the process of optimizing the query for speed. Grid table is populated with rows containing columns of X and Y. (ScreenShot) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
 |
Creating your own Access2000 validation routines | SQL Server 7.0, SQL Server 6.5 and earlier, Other | Beginner /
davepamn | 6059 since
11/25/2011 5:25:52 PM |
By 1 Users
|
| |
This article explains how to create your own Access 2000 validation routines. Access2000 has ValidationRules you can create for each control. However, I found it easier to use Visual Basic techniques to validate my data.
|
| |
| |
| |
|
Custom xp_cmdshell | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
OddityX | 6876 since
8/13/2003 10:40:55 PM | Unrated
|
| |
Custom xp_cmdshell |
| |
| |
| |
|
D2k - Report 6i Tutorial | Oracle | Intermediate /
Dinesh Kumar S | 25220 since
2/24/2010 8:40:21 AM |
By 2 Users
|
| |
Developer 2000 Report 6i Beginners tutorial. All the examples are explained with screen shots.
|
| |
| |
| |
|
 Data Preparations Methods for Data Mining Process | SQL Server 2000, SQL Server 7.0, Informix
, Oracle, Other | Advanced /
barkýn ünüulu | 7842 since
1/7/2008 5:43:14 PM |
By 4 Users
2 Excellent Ratings
|
| |
The purpose of this small article is to introduce some basic terms which are used in many Data Mining software during data preparation. The article is written in Turkish in order reach to the users who put their hands into Data Mining mess. |
| |
| |
| |
|
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). |
| |
| |
| |
|
describe all tables and views | Oracle | Intermediate /
Andy Archer | 7075 since
2/5/2008 1:32:37 PM |
By 1 Users
|
| |
This little SQL*Plus script builds and runs DESC (describe) strings for all user tables and views, spools the results to a file, and opens the file in Notepad. A quick and handy look at all your tables and views. |
| |
| |
| |
|
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) |
| |
(ScreenShot)
(ScreenShot)
