| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 delete duplicates in a table, with one SQL statement | Oracle | Intermediate /
Andy Archer | 18299 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. |
| |
| |
| |
|
delete duplicates in a table | Oracle | Intermediate /
Andy Archer | 11121 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 | 12566 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. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
UTL_FILE file utility - Unix write checker & Unix file remover | Oracle | Intermediate /
Andy Archer | 552 since
4/15/2013 11:20:17 AM | Unrated
|
| |
These two handy SQL*Plus scripts solicit input at the prompt. One script lets you know whether or not you can write to Unix while the other removes (deletes) a Unix file. Via the comfort and convenience of your PC session. |
| |
| |
| |
 |
one-month calendar | Oracle | Advanced /
Andy Archer | 311 since
4/5/2013 5:04:50 PM | Unrated
|
| |
This SQL*Plus script executes a PL/SQL block to display a one-month calendar for the input month and year (solicited at the prompt). Default is the current month, for which today's date is highlighted. (ScreenShot) |
| |
| |
| |
|
Remove Character & Replace Character | Oracle | Beginner /
Andy Archer | 300 since
3/30/2013 12:35:27 AM | Unrated
|
| |
With PL/SQL you can easily remove all occurrences of a character in a string as well as replace all occurrences of a character with another character. This write-up with code examines some functions for those tasks. |
| |
| |
| |
|
Remove Bad ASCII | Oracle | Beginner /
Andy Archer | 572 since
3/24/2013 10:30:56 AM | Unrated
|
| |
This PL/SQL stored function returns in_string with non-printable/space ASCII characters removed. Codes 32 through 126 correspond to the printable and space ASCII characters. |
| |
| |
| |
|
 Oracle R12 - MOAC | Oracle | Advanced /
Dinesh Kumar S | 3158 since
3/8/2013 9:15:14 PM | Unrated
|
| |
Oracle R12 - MOAC By Dinesh Kumar S
I have given an overview about oracle R12 new features and multi org setup with MOAC.
All the setups are explained with screenshots. Hope this might be useful for all.
Cheers :) |
| |
| |
| |
|
Oracle Form Personalization | Oracle | Intermediate /
Dinesh Kumar S | 1133 since
3/4/2013 3:41:22 PM | Unrated
|
| |
Oracle Form Personalization - By Dinesh Kumar S
This is a complete overview of form personalization with examples and screenshots.
Useful for all beginners & Fresher''s.
Happy reading :)
|
| |
| |
| |
|
Oracle Forms | Oracle | Intermediate /
Dinesh Kumar S | 1101 since
3/4/2013 3:41:21 PM | Unrated
|
| |
Oracle Forms - Development Basics
I have created a simple eBook for oracle forms with screenshot for beginners and freshers.
Attached the sample fmb file for your reference.
Hope this might be useful.
Happy Reading :) |
| |
(ScreenShot)
