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 [2017/10/24 15:50]
admin
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]] [[sessions + transactionen]]
Line 12: Line 26:
  
 [[datum]] [[datum]]
 +
 +[[oracle outer joins]]
  
 [[joins]] [[joins]]
  
 [[joins - subsetvergleich]] [[joins - subsetvergleich]]
 +
 +[[beispiele]]
  
 [[any all]] [[any all]]
Line 28: Line 46:
  
 [[aggregat/​summenfunktionen]] [[aggregat/​summenfunktionen]]
 +
 +[[listagg]]
  
 [[rank]] [[rank]]
 +
 +[[pivot]]
  
 [[group by Beispiele]] [[group by Beispiele]]
Line 106: Line 128:
  
 [[foreign keys finden]] [[foreign keys finden]]
 +
 +=== DML ===
 +
 +[[create participant table]]
kurs/oracle-advanced-sql.1508853046.txt.gz ยท Last modified: 2017/10/24 15:50 by admin