| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Pivot Table Creation in SQL SERVER 2005. | SQL Server 2000 | Advanced /
Dinesh Mishra | 132 since
7/25/2010 9:14:23 AM | Unrated
|
| |
Creation of Pivot always makes it easy to read data and make conclusions fast. It is one of strong points of Microsoft Excel Spreadsheet. It is easily understood by everyone and needed frequently in various scenarios. Eveb Sql Server 2005 is capable of cr ...(description truncated) |
| |
| |
| |
 |
Count Integer Places & Count Fractional Places | Oracle | Advanced /
Andy Archer | 7236 since
7/9/2010 9:04:47 AM |
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. |
| |
| |
| |
|
delete quasi duplicates in a table (with one SQL statement) | Oracle | Intermediate /
Andy Archer | 3862 since
6/25/2010 8:51:57 AM | Unrated
|
| |
The example SQL and brief narrative illustrate how to delete quasi duplicate rows in a table via a Delete statement with a subquery. |
| |
| |
| |
|
grant a privilege on all user tables to another user | Oracle | Advanced /
Andy Archer | 1720 since
6/22/2010 8:38:27 AM | Unrated
|
| |
This script solicits a table privilege and grantee user name at the SQL*Plus prompt, then builds and executes a file of GRANT statements to grant the privilege on all user tables to the grantee user. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
get all row counts | Oracle | Intermediate /
Andy Archer | 2517 since
6/22/2010 8:38:05 AM | Unrated
|
| |
This SQL*Plus script spools two files built from all user tables: (1) a file of SELECT COUNT(*) FROM statements, and (2) a comma-delimited file of row counts and table names, opened in Notepad. |
| |
| |
| |
|
do DML on many tables, from many other similar tables, with minimal coding | Oracle | Advanced /
Andy Archer | 889 since
6/22/2010 8:37:19 AM | Unrated
|
| |
This write-up with code shows how to do inserts, updates, and deletes on many tables, from many other similar tables, by using a mapping table, a REF cursor, and SQL built around PL/SQL variables. The mapping table makes for tight PL/SQL coding. |
| |
| |
| |
|
Factorial Calculator. | SQL Server 2000 | Intermediate /
Dinesh Mishra | 636 since
6/11/2010 8:06:11 AM | Unrated
|
| |
For calculating Factorial. |
| |
| |
| |
|
 Current Date/Periods | SQL Server 2000 | Advanced /
John C Kirwin | 600 since
6/10/2010 9:08:54 AM | Unrated
|
| |
Query of current date and periods |
| |
| |
| |
|
Cursor days of the week | SQL Server 2000 | Advanced /
John C Kirwin | 668 since
6/4/2010 9:01:16 AM | Unrated
|
| |
This code will cursor through the days of the week and print the day and date each time through |
| |
| |
| |
|
Days Of This Week | SQL Server 2000 | Advanced /
John C Kirwin | 669 since
6/4/2010 9:01:01 AM | Unrated
|
| |
This query will return the day of the week in one column and the date in another column. |
| |
