1. Views . New View. : V_ .
2. ( SQL Query) ( ) , . , ( ). -. DATE : dd.mm.yyyy. TO_CHAR(D1,mask) D1 DATE, mask .
3. Test Syntax. DDL . OK .
4. , , Advanced ( ).
1.3 ר
. :
- ;
- ( );
- ( );
- ( DDL ).
. .
1. USER (default tablespace) TEMP (temporary tablespace)?
2. GRANT?
3. Pct Free Pct Used 100%?
4. , Ini Trans?
5. Storage Options.
6. , alter table .
7. -? ? , - Oracle.
2
,
- (Sequence), (Trigger) , Insert .
, . , .
|
|
ORACLE , , . , , , . . ORACLE , , .
, , . , , , , . , . - , , .
, . , - , , , , .
CREATE SEQUENCE , , 1, 1 . INCREMENT BY -1, , -1 .
, :
- ;
-
;
-
.
, , MAXVALUE NOMAXVALUE . MINVALUE NOMINVALUE.
, , MAXVALUE ( ) MINVALUE ( ). NOCYCLE. , , .
, , , MAXVALUE MINVALUE, CYCLE.
|
|
START WITH , , . , , .
CACHE. . . , CACHE. , , . CACHE. ORACLE 20 .
(database trigger) PL/SQL, . PL/SQL , SQL ( Insert, Update, Delete ..) . Oracle , SQL.