Karteikarten
Week 7 - SQL Part I
Karten in diesem Stapel (5)
- 1Anatomy of SELECT statement
- 2Predicates and search conditions- Comparison (=, <, >, <=, >=)
- Range e.g. BETWEEN x AND y
- Set membership e.g. IN (x, y, z)
- Pattern match e.g. WHERE city LIKE 'M%', WHERE unit_code LIKE 'FIT20__'
- IS NULL - 3ANSI joins- ON e.g. ...FROM student JOIN qualification ON student.sno = qualification.sno
- USING - requires matching attribute names e.g. ...FROM student JOIN qualification USING (sno)
- NATURAL - requires matching attribute names e.g. FROM student NATURAL JOIN qualification - 4Oracle DATE datatype- Stored in internal format as date and time - Julian date is as number => can use arithmetic
- Output controlled by formatting
e.g. SELECT to_char(sysdate,'dd-Mon-yyyy') FROM dual; SELECT to_char(sysdate,'dd-Mon-yyyy hh:mi:ss PM') FROM dual - 5Oracle internal attributes- sysdate: current date/time
– systimestamp: current date/time as a timestamp
- user: current logged in user
Informationen
- Beschreibung
- Computer Science (FIT2094: Databases) Karteikarten am Week 7 - SQL Part I, erstellt von Melina Mackey am 06/11/2020.
- Erstellt von
- Melina Mackey
- Aufrufe
- 0
- Verlauf
-
- Erstellt von Melina Mackey · 19 Okt 2020
- Kopiert von Melina Mackey · 25 Okt 2020
- Kopiert von Melina Mackey · 1 Nov 2020
- Kopiert von Melina Mackey · 6 Nov 2020
- Bewertung