This is goodfor getting a count of the instances of a value in a table. eg. How many Addresses in the table are from each state?
|
This will delete duplicate rows in a table. Excellent maintenance script.
|
Das folgende Statement liefert alle Duplikate in einer Tabelle und die Anzahl derer:
|
Returns duplicates for a field.
|
If you have a data dictionary at your work and you want to add a new list of values requiring [for example] 7 elements, then you can either start your elements at the very end of the dictionary [select max(id)+1] or you can use these SQL ...
|
Relocates indexes in an Oracle tablespaceto any other tablespace. When run inSQL*Plus the script displays all tablespacesthat contain indexes. The script thenprompts for the source tablespace and thedestination tablespace. When finished ...
|
Outputs a description of all tables with a given owner. Will list any comments associated with the selected table/column. This is an Oracle-specific stored-proc.
|
Predeccesor and successor detection in different-collation supporting db systems.
|
The code creates a script of insert statements for the existing data within a table. The generated script can then be run to re-populate the table.
|
The functions allow the conversion of a date to timestamp and vice-versa in Oracle
|
|
|