ÔÚOracleÖÐÉèÖÃ×Ô¶¯Ôö³¤ÁÐ
¡¾ÊµÏÖ²½Öè¡¿
1. ´´½¨±íblog_info, ¾ßÓÐIDºÍtitleÁ½¸ö×Ö¶Î, ÆäÖÐID½«ÉèÖÃΪ×Ô¶¯Ôö³¤ÁÐ;
2. ´´½¨ÐòÁÐ:
create sequence sq_blog_info
start with 1
increment by 1
nomaxvalue
nocycle
cache 10;
3. ´´½¨´¥·¢Æ÷:
create or replace trigger tg_blog_info
before insert on blog_info for each row
begin
select sq_blog_info.nextval into :NEW.id from dual; --¡ï×¢Òâ: ´Ë´¦µÄ;ÊDZØÐëµÄ
end;
4. ²âÊÔ:
insert into blog_info (title) values('a');
Ïà¹ØÎĵµ£º
ORACLE 10 ѧϰ±Ê¼Ç-µÚ3¿Î-ÃüÁî¡£
1.view ÏÞÖÆ
create or replace view my_view01
as select * from emp
with check option
/
2.synonym ͬÒå´Ê
create synonym dept for scott.dept;
select * from dept;
3.sysdba ¹«¹²
drop synonym dept;
create public synonym dept for scott.dept;
desc dba_synonyms
......
¸Õ¿ªÊ¼Ñ§Ï°Orace£¬Óöµ½Ò»Ð©·Ç³£ºÃµÄÊ飬ÔÚÏÂÃæÁгö£¬Ëæ×ÅѧϰµÄÉîÈë»á°ÑÓöµ½µÄºÃÊé¶¼ÁгöÀ´£¬¹©Ñ§Ï°OracleµÄÅóÓѲο¼£¬
Ò²»¶Ó¸÷λÅóÓѲ¹³ä£º
»ù´¡£º
1. ORACLE DBA»ù´¡Åàѵ½Ì³Ì ºÎÃ÷Öø Ç廪´óѧ³ö°æÉç
&n ......
ºÜ¶àÈ˶¼ÖªµÀ£¬OracleµÄ¼àÌýÆ÷Ò»Ö±´æÔÚ×ÅÒ»¸ö°²È«Òþ»¼£¬¼ÙÈç²»ÉèÖð²È«´ëÊ©£¬ÄÇôÄܹ»·ÃÎʵÄÓû§¾Í¿ÉÒÔÔ¶³Ì¹Ø±Õ¼àÌýÆ÷¡£
Ïà¹ØÊ¾Àý£º
D:\>lsnrctl stop eygle
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 28-11ÔÂ-2007 10:02:40
Copyright (c) 1991, 2006, Oracle. All rights reserved.
......
ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍÆ³öÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ ......
1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ:
(1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
(2) ½«"±¾µØ ......