ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25),
PHONE VARCHAR(10),
ADDRESS VARCHAR(50)
);
È»ºó£¬ÄãÐèÒªÒ»¸ö×Ô¶¨ÒåµÄsequence
CREATE SEQUENCE emp_sequence
INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
NOCYCLE -- Ò»Ö±ÀÛ¼Ó£¬²»Ñ»·
NOCACHE -- ²»½¨»º³åÇø
ÒÔÉÏ´úÂëÍê³ÉÁËÒ»¸öÐòÁÐ(sequence)µÄ½¨Á¢¹ý³Ì,Ãû³ÆÎªemp_sequence,·¶Î§ÊÇ´Ó1¿ªÊ¼µ½ÎÞÏÞ´ó(ÎÞÏÞ´óµÄ³Ì¶ÈÊÇÓÉÄã»úÆ÷¾ö¶¨µÄ),nocycle ÊǾö¶¨²»Ñ»·,Èç¹ûÄãÉèÖÃÁË×î´óÖµÄÇôÄã¿ÉÒÔÓÃcycle »áʹseqµ½×î´óÖ®ºóÑ»·.¶ÔÓÚnocache˳±ã˵һÏÂÈç¹ûÄã¸ø³öÁËcacheÖµÄÇôϵͳ½«×Ô¶¯¶ÁÈ¡ÄãµÄcacheÖµ´óС¸öseq
,ÕâÑùÔÚ·´¸´²Ù×÷ʱ»á¼Ó¿ìÔËÐÐËÙ¶È,µ«Èç¹ûÔâÓöÒâÍâÇé¿öÈçµ±»úÁË»òoracleËÀÁË,ÔòÏ´ÎÈ¡³öµÄseqÖµ½«ºÍÉϴεIJ»Á¬¹á.(Èç¹ûÁ¬²»Á¬¹áÎÞËùν½¨ÒéÓÃcache,ÒòΪʱ¼ä¾ÍÊǽðǮѽ!ÅÜÌâÁË£¡)
Êé½ÓÉÏÎÄ£¬ÄãÖ»ÓÐÁ˱íºÍÐòÁл¹²»¹»£¬»¹ÐèÒªÒ»¸ö´¥·¢Æ÷À´Ö´ÐÐËü£¡´úÂëÈçÏ£º
CREATE TRIGGER "´¥·¢Æ÷Ãû³Æ" BEFORE
INSERT ON example FOR EACH ROW WHEN (new.id is null)
begin
&nbs
Ïà¹ØÎĵµ£º
Oracle
ÒÆ¶¯Êý¾Ý¿âÎļþ
OracleÊý¾Ý¿âÓÉÊý¾ÝÎļþ£¬¿ØÖÆÎļþºÍÁª»úÈÕÖ¾Îļþ
ÈýÖÖÎļþ×é³É¡£
ÓÉÓÚ´ÅÅ̿ռäµÄ±ä»¯£¬»òÕß»ùÓÚÊý¾Ý¿â´ÅÅÌI/OÐÔÄܵĵ÷ÕûµÈ£¬ÎÒ們¿ÉÄܻῼÂÇÒÆ¶¯Êý¾Ý¿âÎļþ¡££¨×¢:
»Ö¸´Êý¾Ý¿âʱ·Ç³£
ÓÐÓã¬ÊôÓÚÀ䱸·Ý£©
²éѯµ±Ç°Êý¾Ý¿âÖÐ,Ïà¹ØÎļþ·¾¶
select * from v$datafile;
se ......
oracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨°üÀ¨»úÆ÷¹ÊÕÏ¡¢½éÖʹÊÕÏ¡¢Îó²Ù×÷µÈ£©£¬Êý¾Ý¿âÓÐʱҲ¿ÉÄÜÔâµ½ÆÆ»µ£¬ÕâʱÈçºÎ¾¡¿ì»Ö¸´Êý¾Ý¾Í³ÉΪµ±ÎñÖ®¼±¡£Èç¹ûƽʱ¶ÔÊý¾Ý¿â×öÁ˱¸·Ý£¬ÄÇô´Ëʱ»Ö¸´Êý¾Ý¾ÍÏԵúÜÈÝÒס£Óɴ˿ɼû£¬×öºÃÊý¾Ý¿âµÄ±¸·ÝÊǶ ......
SELECT trim(NAME) ||' '|| VALUE from v$parameter
WHERE NAME IN ('sga_max_size','db_cache_size','shared_pool_size',
'shared_pool_reserved_size','large_pool_size','java_pool_size',
'db_block_size','db_block_buffers','log_buffer','sort_area_si ......
1. ¸´ÖƱí½á¹¹¼°ÆäÊý¾Ý£º
create table table_name_new as select * from table_name_old
2. Ö»¸´ÖƱí½á¹¹£º
create table table_name_new as select * from table_name_old where 1=2;
»òÕߣº
create table table_name_new like table_name_old
3. Ö»¸´ÖƱíÊý¾Ý£º
Èç¹ûÁ½¸ö±í½á¹¹Ò»Ñù£º
insert into table_name_ ......
Èç¹ûÄãÊÇWINXP»òWIN2003µÄϵͳÖÐ×Ô´øµÄ·À»ðǽ,¿ÉÒÔÊÔÒ»ÏÂÒÔÏ·½·¨:
1.ÔÚ·À»ðǽµÄÀýÍâÖÐ,Ìí¼ÓORACLE.EXEÔËÐгÌÐò.(ÔÚoracle°²×°Ä¿Â¼ÕÒµ½binÎļþ¼ÐÖÐ)
2.ÔÙÔÚ·À»ðǽÀýÍâÖУ¬Ìí¼Ó¶Ë¿Ú1521¶Ë¿Ú¾ÍÑù¾ÖÓòÍøÄ򵀮äËû»úÆ÷¾Í¿ÉÒÔ·ÃÎÊÄãµÄORACLEÁË.
»òÕßÔڸ߼¶ÖÐ,Ñ¡Öе±Ç°Ê¹ÓõÄÍø¿¨,Ìí¼ÓIP,¶Ë¿ÚºÅ(1521),ÕâÑù,ÆäËû»úÆ÷Ò²¿ÉÒÔ·ÃÎ ......