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

-- Основы работы с SQL Plus
-- https://youtu.be/y9oTOXWEhuw

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


sqlplus
chcp 1251

hr@XEPDB1
hr2020


SELECT * FROM regions;


SELECT * FROM regions
WHERE REGION_ID >= 3;


SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY FROM employees;


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


SELECT * FROM employees WHERE rownum <= 5;


store SET C:\Users\Maxim\Documents\Temp\env.SQL


SET linesize 30000;
SELECT * FROM employees WHERE rownum <= 5;


SELECT * FROM employees;
SET pagesize 1000;
SELECT * FROM employees;


CREATE TABLE KMV_SQLPLUS_TEST
    (
        customer_id     NUMBER,
        customer_name   varchar2(20),
        city            varchar2(20)
    )
;


SELECT * FROM KMV_SQLPLUS_TEST;


INSERT INTO kmv_sqlplus_test (customer_id, customer_name, city)
VALUES (1, 'Oleg', 'Omsk');

INSERT INTO kmv_sqlplus_test (customer_id, customer_name, city)
VALUES (2, 'Mark', 'Murmansk');

commit;


DROP TABLE KMV_SQLPLUS_TEST;