Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Íæ×ªOracle£¨2£©

sql*plus ÃüÁî
//Ö´Ðнű¾
@ºÍstart d:/a.txt;
//Ð޸Ľű¾
edit d:/a.txt;
//½«ÄÚÈÝÊäÈëµ½Îı¾ÖÐ
sloop d:/a.txt;  //¿ªÊ¼¼Ç¼ÆÁÄ»ÄÚÈÝ
sloop off;  //¼Ç¼½áÊø
//Á´½ÓµÇ¼Êý¾Ý¿â
connect system/919959 as sysdba/sysoper;  //ȨÏÞ×î´ódba
connect sys/919959;
connect scott/tiger;
//´´½¨Óû§
create user valen identified by 919959;  //´´½¨Íê³Éºó²¢²»Äܹ»µÇ¼£¬ÐèÒªÊÚȨ
//µ±Ç°Óû§
show user;
//ɾ³ýÓû§
drop user valen;
//ÊÚȨ
grant connect to valen;  //µÇ¼µÄȨÏÞ
grant resource to valen; //½¨±íµÄȨÏÞ
grant select on emp to valen; //½«¶ÔÏó²Ù×÷ȨÏÞ¸øÓèijһ¸öÓû§£¬¼ÙÉ赱ǰÓû§Îªscott£¬½«scottµÄemp±íµÄselectȨÏÞ¸³¸øvalen
grant update on emp  //¸üÐÂȨÏÞ
grant inset on emp  //Ìí¼ÓȨÏÞ
grant delete on emp  //ɾ³ýȨÏÞ
grant all on emp  //µ±Ç°±íµÄËùÓÐȨÏÞ
//ÊÕ»ØÈ¨ÏÞ
revoke select on emp from valen; //´ÓvalenÓû§ÊջضÔemp±íµÄselectȨÏÞ
//²éѯÆäËûÓû§µÄ±íµÄȨÏÞ
select * from scott.emp  //²éѯscottÓû§ÏÂemp±í
//ȨÏÞµÄά»¤
//¶ÔÏóȨÏÞ
scott½«È¨ÏÞ´«¸øÁËvalen£¬²¢Ï£Íûvalen½«¸ÃÑ¡Ïß¼ÌÐø´«µÝ¸øÏÂÒ»¸öÓû§
grant select on emp to valen with grant option //Èç¹ûÊǶÔÏóȨÏ޾ͼÓÈëwith grant option
//ϵͳȨÏÞ
grant connect to valen with admin option //Èç¹ûÊÇϵͳȨÏ޾ͼÓÈëwith admin option
Èç¹ûscottÊÕ»ØÁËvalenµÄȨÏÞ£¬ÔòvalenÊÚȨ¸øtomµÄȨÏÞÒ²±»ÊÕ»ØÁË
//ʹÓÃprofile¹ÜÀíÓû§¿ÚÁî
´´½¨profileÎļþ
create profile lock_account //´´½¨¹æÔòlock_account
limit    //¹Ø¼ü×Ö
failed_login_attempts 3  //¸øÓè3´ÎµÇ¼»ú»á
password_lock_time 2;  //Ëø¶¨2Ìì
//¸ü¸ÄÓû§×ñÑ­´Ë¹æÔò
alter user tom profile lock_account;
//¸øÕË»§½â·â
alter user tom account unlock; //¸øÖ¸¶¨Óû§½â·â
//ÖÕÖ¹¿ÚÁî
create profile myprofile //´´½¨¹æÔòmyprofile
limit
password_life_time 10  //ÿ10ÌìÐ޸ĵǼÃÜÂë
password_grace_time 2  //¿íÏÞÆÚΪ2Ìì
password_reuse_time 10  //Ö¸¶¨¿ÚÁî¿ÉÖØÓÃʱ¼ä¼´10Ììºó¾Í¿ÉÒÔÖØÓÃ
//


Ïà¹ØÎĵµ£º

Oracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷Ó¦ÓÃ

ÒÔϵÄÎÄÕÂÖ÷Òª½²ÊöµÄÊÇOracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷·½°¸£¬±¾ÎÄÖ÷ÒªÊÇÒÔÏà¹ØÊµ¼ÊÓ¦ÓôúÂëµÄ·½Ê½À´Òý³öÆäʵ¼ÊµÄ²Ù×÷²½Ö裬ÒÔϾÍÊÇÎÄÕµľßÌåÄÚÈÝÃèÊö£¬ÍûÄãÔÚä¯ÀÀÖ®ºó»áÓÐËùÊÕ»ñ¡£
1.
select 'Drop table '||table_name||';' from all_tables where owner='Ҫɾ³ýµÄÓû§Ãû£¨×¢ÒâÒª´óд£©';

2.Oracleɾ³ýÓû§±í ÒÔÓ ......

ÈçºÎÔÚOracleÖÐʹÓÃJava´æ´¢¹ý³Ì (Ïê½â)

Æäʵ£¬ÕâÆª¶ÌÎÄ£¬ÎÒÔç¾ÍÓ¦¸ÃдÁË¡£ÒòΪ£¬java´æ´¢¹ý³Ì½ñºóÔÚ¸÷´óÊý¾Ý¿â³§ÉÌÖÐÔ½À´Ô½Á÷ÐУ¬¹¦ÄÜÒ²Ô½À´Ô½Ç¿´ó¡£ÕâÀïÒÔOracleΪÀý£¬½éÉÜÒ»ÏÂjava´æ´¢¹ý³ÌµÄ¾ßÌåÓ÷¨¡£
Ò»¡¢ÈçºÎ´´½¨java´æ´¢¹ý³Ì£¿
ͨ³£ÓÐÈýÖÖ·½·¨À´´´½¨java´æ´¢¹ý³Ì¡£
1. ʹÓÃoracleµÄsqlÓï¾äÀ´´´½¨£º
e.g. ʹÓÃcreate or replace and compile java source ......

OracleÊý×éÈëÃÅ

OracleÊý×éÒ»°ã¿ÉÒÔ·ÖΪ¹Ì¶¨Êý×éºÍ¿É±äÊý×é
¹Ì¶¨Êý×é
Sql´úÂë
   declare 
   type v_ar is varray(10) of varchar2(30); 
   my_ar v_ar:=v_ar('g','m','d','¹¨','˧'); 
   begin 
          for ......

.net³ÌÐòÔ¶³ÌÁ¬½ÓOracleÊý¾Ý¿â

.net Ô¶³ÌÁ¬½ÓOracleÊý¾Ý¿â¿´ÆðÀ´Í¦¼òµ¥µÄ£¬µ«Êµ¼Ê×öÆðÀ´»¹ÊÇÓöµ½²»ÉÙÎÊÌâ¡£°ÑÎÒ½ñÌìÕÛÌÚÕâ¸ö¶«Î÷µÄ¾­Ñ鏸´ó¼Ò¹²Ïí°É¡£
¡¡¡¡·ÃÎÊ oracle Êý¾Ý¿âµÄ·½Ê½ºÜ¶à£¬ÎÒÓõÄÊÇ OleDbConnection£¬Õâ¸öûʲôºÃ˵µÄ£¬´úÂëÈçÏ£º
¡¡¡¡1. Á¬½Ó´úÂë
   ¡¡_OleDbConnection¡¡=¡¡new¡¡OleDbConnection(connectionString);
¡¡¡ ......

½â¾öOracleÎÞ¼àÌý´íÎó

ÔÚÓÃPL/SQL DeveloperÁ¬½ÓÊý¾Ý¿âʱ³öÏÖ
“ORA-12541:TNS:ÎÞ¼àÌý³ÌÐò”´íÎó¡£
1¡¢¼ì²élistener.logÈÕÖ¾
·¢ÏÖÏÂÃæ´íÎó£º
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9ÔÂ -2008 10:25:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
ϵͳ²ÎÊýÎļþΪD:\oracle\product\1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ