| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 sp_executesql : How to use ? | SQL Server 2000 | Advanced /
Francisco Antonio de Araujo e Souza | 213 since
7/10/2013 3:20:46 PM | Unrated
|
| |
sp_executesql
exemplo
example
Como usar a sp_executesql ?
How to use the sp_executesql ? |
| |
| |
| |
 |
 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. |
| |
| |
| |
|
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. |
| |
| |
| |
|
UTL_FILE file utility - Unix write checker & Unix file remover | Oracle | Intermediate /
Andy Archer | 764 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 | 503 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 | 462 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 | 803 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 | 5091 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 | 1432 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 :)
|
| |
(ScreenShot)
