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 [2014/05/13 12:23]
mh
kurs:oracle-advanced-sql [2022/03/14 14:23]
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]]
 +
 +[[pivot]]
  
 [[group by Beispiele]] [[group by Beispiele]]
Line 96: Line 122:
  
 [[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