Расширенные возможности SQL - Команд SQL в рамках урока #15

-- Основы работы с SQL Plus (часть 2)
-- https://youtu.be/L_A0ibKsuhQ

-------------------------------------------
-- Расширенные возможности SQL. Примеры команд и запросов SQL в рамках урока #15.

Windows + R

chcp 1251
sqlplus

hr@XEPDB1
hr2020


@echo off
chcp 1251
sqlplus hr/hr2020@XEPDB1


SELECT * FROM regions
WHERE REGION_ID >= 1;


START region.SQL
@region.SQL
@temp/region.SQL


SELECT * FROM regions
WHERE REGION_ID >= &REG_ID_1 AND REGION_ID <= &REG_ID_2;


@region.SQL 3 8


SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY FROM employees
WHERE rownum <= 5;


@region.SQL 2 8


SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY FROM employees
WHERE rownum <= &3;


@region.SQL 2 8 10


DECLARE
  v NUMBER;
BEGIN
  SELECT COUNT(*) INTO v
  FROM employees;
  dbms_output.put_line(chr(13));
  dbms_output.put_line('Result PL/SQL: ' || v);
  dbms_output.put_line(chr(13));
END;
/


SET SERVEROUTPUT ON

@region.SQL 2 8 10
@employees.SQL


SELECT * FROM employees;


@select_empl.SQL


SET linesize 30000
SET pagesize 1000

@select_empl.SQL

SPOOL RESULT.txt
SPOOL OFF

@select_empl.SQL

SET termout off
SET markup csv ON
SET feedback off