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 [2022/03/14 14:23] (current)
admin
Line 1: Line 1:
 +[[RDBMS]]
 +
 +[[DB Sprachen]]
 +
 +[[Fragen Dezember 2018]]
 +
 [[3rd party software]] [[3rd party software]]
  
Line 4: Line 10:
  
 [[einfache selects]] [[einfache selects]]
 +
 +[[CTE Common Table Expression - With Clause]]
 +
 +[[Relationen]]
 +
 +[[Data Dictionary Views]]
 +
 +[[bind und substitution variablen]]
 +
 +[[sessions + transactionen]]
  
 [[indices]] [[indices]]
Line 10: Line 26:
  
 [[datum]] [[datum]]
 +
 +[[oracle outer joins]]
  
 [[joins]] [[joins]]
  
-[[rownum]]+[[joins - subsetvergleich]] 
 + 
 +[[beispiele]] 
 + 
 +[[any all]] 
 + 
 +[[rownum|rownum limit]] 
 + 
 +[[overlaps]]
  
 [[sets Gruppenoperatoren]] [[sets Gruppenoperatoren]]
  
 [[metadata]] [[metadata]]
 +
 +[[aggregat/​summenfunktionen]]
 +
 +[[listagg]]
 +
 +[[rank]]
 +
 +[[pivot]]
  
 [[group by Beispiele]] [[group by Beispiele]]
Line 35: Line 69:
 [[external tables]] [[external tables]]
  
 +[[histogramm gehaltsverteilung]]
 +
 +[[partition rank]]
  
 DML DML
Line 47: Line 84:
  
 [[analyze indices/​index]] [[analyze indices/​index]]
 +
 +[[table for merge]]
  
 [[merge with table]] [[merge with table]]
Line 83: Line 122:
  
 [[connect by prior]] [[connect by prior]]
 +
 +[[zeit zwischen jobs]]
  
 [[Regular Expression]] [[Regular Expression]]
  
 +[[foreign keys finden]]
 +
 +=== DML ===
  
 +[[create participant table]]
kurs/oracle-advanced-sql.1288443775.txt.gz · Last modified: 2014/09/10 21:22 (external edit)