SQL
« Previous EntriesDate und Time Formate
Wednesday, February 23rd, 2011CC Century SCC Century BC prefixed with – YYYY Year 1956 SYYY Year BC prefixed with – IYYY ISO Year 1956 YY Year 56 RR Year 56 rollover for Y2K compatibility * RRRR Year rollover (accepts 2 digits, returns 4) * YEAR Year spelled out SYEAR Year spelled out BC prefixed with – BC BC/AD [...]
Ergebnisse eines select statements im file speichern
Wednesday, February 23rd, 2011spool d:\temp\abc.txt; Das file als abc.txt im Verzeichnis tmp öffnen select to_char(Datum, ‘YYYYMMDD’),Eroeffnung, hoechst,tiefst,schluss, volumen from WPKursdaten where wp_id =’24163′; spool off; file schließen
Teilstrings in varchar2 Feld ändern
Tuesday, February 15th, 2011Update tablename set Tabellenname = replace (Tabellenname,’zu ersetzender String’, ‘Ersatzstring’);
alter table column examples
Tuesday, February 15th, 2011ALTER TABLE customer MODIFY ( cust_name varchar2(100) not null, cust_hair_color varchar2(20) ) ; dynamic PL/SQL BEGIN SQL_STRING := ‘ALTER TABLE ‘||:TABLE_NAME||’ MODIFY ‘||:COLUMN_NAME||’ VARCHAR2(100)’; . . . END;
Codebeispiel Oracle : Anzahl doppelter Datensätze
Friday, June 12th, 2009select wp_id, count (*) as anzahl from tmp_Kurse group by wp_id having count(*) >1;
Oracle Codebeispiel: Löschen doppelter Datensätze in einem table
Tuesday, April 28th, 2009Oracle speichert eine interne Indexierung mit dem Namen ROWID, DELETE FROM tmp_index WHERE rowid NOT IN (SELECT max(rowid) FROM tmp_index GROUP BY ISIN);
« Previous Entries