. |
, . , .
(trigger) , () . — . , ; .
, : . , . , . . , . . , . . . , . . (, ).
DML (Data Modification Language, Transact-SQL). , , , . , . , . , ( , , ). :
CREATE TRIGGER _ ON _[WITH ENCRYPTION]FOR {INSERT | UPDATE | DELETE} [,...][WITH APPEND][NOT FOR REPLICATION]AS[ SQL][RETURN]
: , ( ). , . CREATE TRIGGER . . , , . , , db_owner db_ddladmin.
, . , . , , PL/SQL, Java , "--" (EventCondition-Action — EGA), ( ), Oracle, INSERT, UPDATE DELETE, (, , ); CREATE, ALT3R DROP, ; Oracle; ; . , — . , , . , , , . , . SQL , , - .
: (row-level triggers), , (statement-level triggers), , . Oracle INSTEAD-OF, , SQL DML (INSERT, UPDATE DELETE). INSTEAD-OF, , , Oracle (instead-of) SQL. . , , , , , . Oracle ON DELETE NO ACTION ON UPDATE NO ACTION . Oracle ON DELETE CASCADE , . ON UPDATE CASCADE SET DEFAULT SET NULL. , .
2) SELECT, ( , WHERE). . . (DISTINCT).
:
SELECT column AS column_alias FROM table;
SELECT LastName AS Family, FirstName AS Name FROM Persons -
SELECT column FROM table AS table_alias;
SELECT LastName, FirstName FROM Persons AS Employees – Employees
: SELECT column FROM table WHERE column operator value
SELECT * FROM Persons WHERE LastName IN ('Hansen','Pettersen'); "Persons"
SELECT * FROM Persons WHERE City='Sandnes‘
SELECT : SELECT DISTINCT column_name(s) FROM table_name; -
" ":
1 - . .
2 -
...
16 - . , . Web- . XML Web- (Web-Services).
17 - 2) SELECT SQL. UNION. EXIST NOT EXIST.
18 - .
19 - . ER-.
20 - . .
...
43 - .
44 - - . .
45 - .
| : |
