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 [2018/12/11 09:08]
admin
kurs:oracle-advanced-sql [2022/03/14 14:23] (current)
admin
Line 1: Line 1:
 +[[RDBMS]]
 +
 +[[DB Sprachen]]
 +
 [[Fragen Dezember 2018]] [[Fragen Dezember 2018]]
  
Line 6: 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 14: Line 26:
  
 [[datum]] [[datum]]
 +
 +[[oracle outer joins]]
  
 [[joins]] [[joins]]
Line 32: Line 46:
  
 [[aggregat/​summenfunktionen]] [[aggregat/​summenfunktionen]]
 +
 +[[listagg]]
  
 [[rank]] [[rank]]
 +
 +[[pivot]]
  
 [[group by Beispiele]] [[group by Beispiele]]
Line 110: Line 128:
  
 [[foreign keys finden]] [[foreign keys finden]]
 +
 +=== DML ===
 +
 +[[create participant table]]
kurs/oracle-advanced-sql.1544515736.txt.gz ยท Last modified: 2018/12/11 09:08 by admin