Flashcards
Week 7 - SQL Part I
Flashcards do conjunto (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
Informações
- Descrição
- Computer Science (FIT2094: Databases) FlashCards sobre Week 7 - SQL Part I, criado por Melina Mackey em 06-11-2020.
- Criado por
- Melina Mackey
- Visualizações
- 0
- Histórico
-
- Criado por Melina Mackey · 19 out 2020
- Copiado por Melina Mackey · 25 out 2020
- Copiado por Melina Mackey · 1 nov 2020
- Copiado por Melina Mackey · 6 nov 2020
- Avaliação