| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Can Row Be Locked | Oracle | Intermediate /
Andy Archer | 1365 since
1/11/2012 2:29:01 PM | Unrated
|
| |
This little PL/SQL stored function tells you whether or not a particular row in a particular table can be locked. Handy code-saver when you need to know. Just pass it schema name (optional), table name, and ROWID. |
| |
| |
| |
 |
 Constraints | Oracle | Intermediate /
manoj a.p | 5461 since
1/20/2011 6:54:02 PM | Unrated
|
| |
Apply some business rules with constraints |
| |
| |
| |
|
 DBCC Log | SQL Server 7.0 | Advanced /
Keith Henry | 15602 since
8/6/2002 5:15:39 AM |
By 5 Users
|
| |
Viewing the Tranaction log in MS SQL 7+ |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 Delete Duplicate Rows | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Himanshu Upadhyay | 17403 since
4/25/2004 3:25:14 AM |
By 4 Users
2 Excellent Ratings
|
| |
How to Delete Duplicate Rows in a Given Table |
| |
| |
| |
|
delete duplicates in a table | Oracle | Intermediate /
Andy Archer | 11383 since
5/12/2013 6:46:38 PM |
By 1 Users
|
| |
Here's an example PL/SQL stored procedure that uses a cursor with an ORDER BY clause (carrying the primary key) to delete duplicate rows in a table. |
| |
| |
| |
|
delete duplicates in a table, using FOR UPDATE NOWAIT | Oracle | Intermediate /
Andy Archer | 12841 since
5/12/2013 6:46:33 PM |
By 1 Users
|
| |
Here's an example PL/SQL block that uses a cursor with an ORDER BY (primary key) clause and a FOR UPDATE NOWAIT clause, along with the pseudocolumn ROWID, to delete duplicate rows in a table. |
| |
| |
| |
|
delete duplicates in a table, with one SQL statement | Oracle | Intermediate /
Andy Archer | 18700 since
5/12/2013 6:46:48 PM |
By 4 Users
3 Excellent Ratings
|
| |
This kind of SQL statement deletes duplicates in a table, leaving the first row inserted of each duplicate set. It deletes rows from a set of duplicates where the primary key values are greater than that of the original row. |
| |
| |
| |
|
insert into one table all rows from another table (no duplicates), with one SQL statement | Oracle | Intermediate /
Andy Archer | 86469 since
3/11/2009 10:58:34 AM |
By 7 Users
6 Excellent Ratings
|
| |
The example SQL and narrative illustrate how to insert into one table all rows from another table, without pulling over duplicates (including null row duplicates), via an Insert statement with subqueries. Merge example also included. |
| |
| |
| |
|
insert the ampersand (&) via SQL*Plus | Oracle | Beginner /
Andy Archer | 8243 since
1/29/2009 8:25:47 AM | Unrated
|
| |
This short write-up examines the role of the ampersand (&) in SQL*Plus, and shows how you can easily turn it into just another text character when you need to insert it into a table. |
| |
| |
| |
|
insert the apostrophe ('), or "single quote" | Oracle | Beginner /
Andy Archer | 5276 since
3/27/2009 8:38:17 AM | Unrated
|
| |
The apostrophe ('), or "single quote", delimits a string to be inserted into a table. This little write-up shows how the apostrophe itself can be inserted, via SQL*Plus. |
| |
