1. The Technique of Java Programming
2. !!!!
3. SQL PL/SQL : , ! : - SQL&PL/SQL - Head First
4. , SQL 2
5. 01 02 03 04 05 06 07
6. 01 , , , , , , ,
7. 02 () () 2 SQL CREATE TABLE [.] ( 1 1_ [NULL, NOT NULL], 2
2_ [NULL, NOT NULL], ) [ TABLESPACE ];
8. 02 , 30 Byte , , , , '_','$','# , . 255
9. 02 CHAR VARCHAR2 CHAR ([ BYTE | CHAR ] ) , 2000byte, 1, byte
VARCARCHAR2 ([ BYTE | CHAR ] ) , 4000byte, 1, byte NCHAR () ( ),
2000byte, 1 NVARCARCHAR2 ( ) ( ), 4000byte, 1 LONG 2 , 1 BYTE, 2
BYTE , NVARCHAR2
10. 02 P , S S , NUMBER [(p, [,s])] , p(1~38, 38) s(-84~127, 0)
10 , 22byte FLOAT[(p)] NUMBER , p 1~128, 128, 2 , 22byte
BINARY_FLOAT 32 , 4byte BINARY_DOUBLE 64 , 8byte NUMBER , 38 ( 28
byte)
11. 02 DATE INTERVAL_DAY TO SECOND, TIMESTAMP WITH TIME ZONE,
TIMESTAMP WITH LOCAL TIME ZONE DATE BC 4712 1 1 9999 12 31, ,,,,, .
TIMESTAMP [(fractional_sec onds_precision)] , , , , , .
fractional_seconds_precision 0~9 6.
12. 02 LOB Large Object CLOB NCLOB, , , BLOB, BFILE CLOB . ,
(4byte-1) *( ) NCLOB () . (4byte-1) *( ) BLOB . (4byte-1) *( )
BFILE (, ). 4
13. 02 NULL NULL , , NULL NOT NULL : NOT NULL UNIQUE : (Primary
Key) : NOT NULL + UNIQUE, 1 , PRIMARY KEY CONSTRAINTS PRIMARY KEY
(, )
14. (Foreign Key) : CONSTRAINT FOREIGN KEY (, ) REFERENCES ( ,
) 02 CHECK : ,
15. DROP TABLE [.] [CASCADE CONSTRAINTS]; 02
16. ALTER TABLE 02 : ALTER TABLE [.] RENAME COLUMN _ TO _; :
ALTER TABLE [.] MODIFY ; : ALTER TABLE [.] ADD ;
17. 02 : ALTER TABLE [.] DROP COLUMN ; () : ALTER TABLE [.] ADD
CONSTRAINTS PRIMARY KEY (, ..); : ALTER TABLE [.] DROP CONSTRAINTS
;
18. 02 CREATE TABLE [.] AS SELECT 1, 2, . FROM ; ) CREATE
TABLEex2_9_1 AS SELECT * FROM ex2_9;
19. 03 CREATE OR REPLACE VIEW [.] AS SELECT ; . ( Updatable )
DROP VIEW [.];
20. 04 : : UNIQUE , NON-UNIQUE : B-tree , ,
21. 04 CREATE[UNIQUE] INDEX [.] ON [.] (1, 2, ); 15% NULL
22. 04 DROP INDEX [.];
23. 05 CREATE OR REPLACE [PUBLIC] SYNONYM [.] FOR[.]; , PUBLIC
: , PRIVATE : , PUBLIC , PRIVATE GRANT SELECT ON TO PUBLIC; GRANT
SELECT ON TO ;
24. 05 DROP [PUBLIC] SYNONYM [.]; PRIVATE DROP SYNONYM DROP ANY
SYNONYM PUBLIC DROP PUBLIC SYNONYM
25. 06 CREATE SEQUENCE [.] INCREMENT BY START WITH NOMINVALUE |
MINVALUE NOMAXVALUE | MAXVALUE NOCYCLE | CYCLE NOCACHE |
CACHE;
26. 06 () : .CURRVAL () : .NEXTVAL DROP SEQUENCE [.];
27. 07 ( ) 1 , .
LOAD MORE