Fichas
Week 7 - SQL Part I
Fichas del 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
Información
- Descripción
- (FIT2094: Databases) Computer Science Fichas sobre Week 7 - SQL Part I, creado por Melina Mackey el 06/11/2020.
- Creado por
- Melina Mackey
- Visitas
- 0
- Historial
-
- Creado por Melina Mackey · 19 oct 2020
- Copiado por Melina Mackey · 25 oct 2020
- Copiado por Melina Mackey · 1 nov 2020
- Copiado por Melina Mackey · 6 nov 2020
- Valoración