4. Архитектура и работа с Oracle Database

Общие:
-- tables
-- indexes
-- views
-- materialized views

select * from MV_FACT_SALE;

-- sequences

drop sequence SEQ_ID;
create sequence SEQ_ID start with 10000;

select seq_id.CURRVAL from dual;

insert into PRODUCT(PRODUCT_ID, PRODUCT_NAME)
values (seq_id.nextval, 'Новый продукт');

insert into PRODUCT(PRODUCT_NAME)
values ('Новый продукт');

-- synonyms
create synonym S_PRODUCT for OLTP_TEST.PRODUCT;

-- public synonyms

select myFunction('abc') from dual;

insert update delete
before, after, instead of

-- PL/SQL:
  -- procedures (stored procedures)
  -- functions
  -- triggers
  -- packages
  -- types

Очереди событий:
-- Queues
-- Queue tables


-- Database links
insert into PRODUCT select * from OLTP_TEST.PRODUCT@ORCL2

-- directories

-- scheduler