| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 find all indexes | Oracle | Advanced /
Andy Archer | 5598 since
10/21/2008 4:26:41 PM | Unrated
|
| |
This SQL*Plus script executes a PL/SQL block to find info on all user indexes, spooling the results to a file and opening the file in Notepad. |
| |
| |
| |
|
find all objects with <string> in their name | Oracle | Intermediate /
Andy Archer | 4557 since
3/4/2013 3:41:05 PM | Unrated
|
| |
This script solicits a string at the SQL*Plus prompt, runs SQL to find all user objects with that string in their name, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
|
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. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
find all table constraints | Oracle | Intermediate /
Andy Archer | 3872 since
10/21/2008 4:25:41 PM | Unrated
|
| |
This SQL*Plus script runs SQL to find constraint info on all user tables, spools the results to a file, and opens the file in Notepad. A quick and handy look at all your table constraints. |
| |
| |
| |
|
find all tables where <string> appears in a column | Oracle | Intermediate /
Andy Archer | 9173 since
1/25/2009 8:49:50 AM |
By 2 Users
|
| |
This little script solicits a column name and a string at the SQL*Plus prompt, builds and runs SQL to find all user tables where the string appears in that column, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
|
find column constraints | Oracle | Intermediate /
Andy Archer | 4854 since
10/24/2008 11:36:00 AM | Unrated
|
| |
This script solicits a user column name at the SQL*Plus prompt, runs SQL to find constraint info on the column for any table it appears in within the user's schema, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
 |
 Find DB Object By Name | SQL Server 2000 | Advanced /
Kevin Xiong | 4400 since
10/17/2003 10:00:17 AM | Unrated
|
| |
Find database objects by name within a database server. |
| |
| |
| |
|
find duplicates in a table | Oracle | Intermediate /
Andy Archer | 8173 since
2/24/2007 2:43:22 PM |
By 6 Users
5 Excellent Ratings
|
| |
This is a collection of example Select statements to find unique or duplicate column values among rows, in one table or across two tables. Two example PL/SQL blocks to find duplicates are also presented. (Beginner to Intermediate). |
| |
| |
| |
|
find server PL/SQL source code | Oracle | Intermediate /
Andy Archer | 4974 since
9/19/2012 9:40:11 AM |
By 1 Users
|
| |
This script solicits a user PL/SQL object name and type at the SQL*Plus prompt, runs SQL to find the object's Data Dictionary source code, spools the results to a file, and opens the file in Notepad. For any server-side proc or trigger. |
| |
| |
| |
|
Find the Nth Ranking Row in a SQL ResultSet | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Kapil Srivastava | 6322 since
9/26/2003 12:00:57 PM |
By 1 Users
|
| |
To find the Nth highest (or lowest) row in a mathematical order, say 7th student in the class. |
| |
