SQL1

         

SQL1

SQL
ANSI

PL/I



SQL


DATE TIME

FORMAT







INTERSECT MINUS




" "?


( )


:


SQL
2. SQL. .
SQL?
ANSI?
SQL
SQL

SQL. .
""?


3. SQL

?
?
SELECT

SELECT




DISTINCT
ALL DISTINCT

4.



5.
IN
BETWEEN

LIKE
NULL
IS NULL
NOT
. 6
?

?
COUNT
DISTINCT
COUNT ,

,
GROUP BY
HAVING


8.









NULL
8. ,







9.
?






10.
?
,
DISTINCT



, IN


HAVING
11. Ѩ
Ѩ ?

?
Ѩ

Ѩ HAVING
Ѩ
12. EXISTS

EXISTS?
EXISTS
EXISTS Ѩ
EXISTS
NOT EXISTS
EXISTS


13. ANY, ALL SOME

SQL1

ANY SOME
IN EXISTS ANY

ANY ?
ALL

ANY ALL
ANY, ALL EXIST ?
?
ANY ALL EXISTS NULL
COUNT EXISTS

14. UNION

?
UNION
UNION
UNION ORDER BY


15. ,
DML

NULL
(INSERT)





UPDATE

NULL-
INSERT


,
DELETE
UPDATE
DML
17.




:

,

18.



(NULL)
,





CHECK
,


19.



/FOREIGN KEY





?


, ?



, ͨ
20. . .
?
CREATE VIEW







?

21.



__.
?
,
ר
,





GRANT
. .

ALL PUBLIC
WITH GRANT OPTION



?



23. SQL





?
?
SQL ?
:



24. SQL ?

SQL1






SYSTEMINDEXES -
SYSTEMUSERAUTH -
SYSTEMTABAUTH - ,
SYSTEMCOLAUTH - ,
SYSTEMSYNONS -


25. SQL (/ SQL)
- SQL?
SQL?
SQL?
SQL




SQLCODE
SQLCODE
WHENEVER

INDICATOR
INDICATOR NULL- SQL
:
INDICATOR


SQL


SQL

BEGIN DECLARE SECTION ( )
CLOSE CURSOR ( )
COMMIT (WORK) ( ())
CREATE INDEX ( )
CREATE SYNONYM (*NONSTANDARD*) ( ) (**)
CREATE TABLE ( )
CREATE VIEW ( )
DECLARE CURSOR ( )
DELETE ()
EXEC SQL ( SQL)

FETCH (/)
GRANT ( )
INSERT ()
OPEN CURSOR ( )
REVOKE (*NONSTANDARD*) ( ) ()
ROLLBACK (WORK) () ()
SELECT ()
UNION ()
UPDATE ()

WHENEVER ( )
SQL,