x
Play video and select frame to capture or upload thumbnail
  Play   Capture Upload Own Image

Oracle Core, Лекция 3-2

By blaginov1955 in Базы данных Oracle - администрирование 1495 views 11th May, 2018 Video Duration: 01:34:13
Видеокурс по администрированию баз данных Oracle. Продолжаем осваивать SQL.

1. Таблица DUAL
2. Конструкция WITH. Рекурсивные запросы с конструкцией WITH
3. Иерархические запросы (self joins): START WITH, CONNECT BY, PRIOR, NOCYCLE, ORDER SIBLINGS BY, LEVEL, CONNECT_BY_ISCYCLE, CONNECT_BY_ISLEAF, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT
4. Псевдостолбцы (pseudocomlumns).
4.1 ORA_ROWSCN (SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN)
4.2 ROWID (DBMS_ROWID)
4.3 ROWNUM
5. Конструкция SAMPLE
6. Конструкция PIVOT
7. Конструкция UNPIVOT
8. Оператор INSERT INTO SINGLE TABLE
9. Оператор INSERT INTO MULTITABLE: INSERT ALL, INSERT FIRST
10. Оператор UPDATE
11. Оператор DELETE
12. Оператор MERGE
13. Обновляемая VIEW (KEY-PRESERVED TABLE)
14. SQL FUNCTIONS: SYSDATE, EXTRACT, ADD_MONTH, MONTH_BETWEEN, UPPER/LOWER, LENGTH, SUBSTR, INSTR, REPLACE, LTRIM/RTRIM/TRIM, LPAD/RPAD, TO_CHAR, TO_NUMBER, TO_DATE, POWER, ABS, ROUND, CEIL/FLOOR, USER, TRUNC, GREATEST/LEAST

Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle

People In This Video
No users are tagged in this video


0
0
0
0
0
0
Unable to load tooltip content.