User Tools

Site Tools


kurs:oracle-advanced-sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:oracle-advanced-sql [2010/10/30 15:02]
mh
kurs:oracle-advanced-sql [2018/12/11 09:08] (current)
admin
Line 1: Line 1:
 +[[Fragen Dezember 2018]]
 +
 [[3rd party software]] [[3rd party software]]
  
Line 4: Line 6:
  
 [[einfache selects]] [[einfache selects]]
 +
 +[[sessions + transactionen]]
  
 [[indices]] [[indices]]
Line 13: Line 17:
 [[joins]] [[joins]]
  
-[[rownum]]+[[joins - subsetvergleich]] 
 + 
 +[[beispiele]] 
 + 
 +[[any all]] 
 + 
 +[[rownum|rownum limit]] 
 + 
 +[[overlaps]]
  
 [[sets Gruppenoperatoren]] [[sets Gruppenoperatoren]]
  
 [[metadata]] [[metadata]]
 +
 +[[aggregat/​summenfunktionen]]
 +
 +[[rank]]
  
 [[group by Beispiele]] [[group by Beispiele]]
Line 35: Line 51:
 [[external tables]] [[external tables]]
  
 +[[histogramm gehaltsverteilung]]
 +
 +[[partition rank]]
  
 DML DML
Line 47: Line 66:
  
 [[analyze indices/​index]] [[analyze indices/​index]]
 +
 +[[table for merge]]
  
 [[merge with table]] [[merge with table]]
Line 84: Line 105:
 [[connect by prior]] [[connect by prior]]
  
-[[Regular Expression]]+[[zeit zwischen jobs]]
  
 +[[Regular Expression]]
  
 +[[foreign keys finden]]
kurs/oracle-advanced-sql.1288443775.txt.gz · Last modified: 2014/09/10 21:22 (external edit)