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
Last revision Both sides next revision
kurs:oracle-advanced-sql [2013/10/28 13:35]
mh
kurs:oracle-advanced-sql [2022/03/14 14:03]
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]] [[sessions + transactionen]]
Line 12: Line 26:
  
 [[datum]] [[datum]]
 +
 +[[oracle outer joins]]
  
 [[joins]] [[joins]]
 +
 +[[joins - subsetvergleich]]
 +
 +[[beispiele]]
  
 [[any all]] [[any all]]
  
-[[rownum]]+[[rownum|rownum limit]] 
 + 
 +[[overlaps]]
  
 [[sets Gruppenoperatoren]] [[sets Gruppenoperatoren]]
Line 24: Line 46:
  
 [[aggregat/​summenfunktionen]] [[aggregat/​summenfunktionen]]
 +
 +[[listagg]]
  
 [[rank]] [[rank]]
Line 45: Line 69:
 [[histogramm gehaltsverteilung]] [[histogramm gehaltsverteilung]]
  
 +[[partition rank]]
  
 DML DML
Line 95: Line 120:
  
 [[connect by prior]] [[connect by prior]]
 +
 +[[zeit zwischen jobs]]
  
 [[Regular Expression]] [[Regular Expression]]
  
 [[foreign keys finden]] [[foreign keys finden]]
 +
 +=== DML ===
 +
 +[[create participant table]]
kurs/oracle-advanced-sql.txt · Last modified: 2022/03/14 14:23 by admin