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

oracle¹éµµÄ£Ê½ÐÞ¸Ä

C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 13 15:26:31 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL> archive log list;
Êý¾Ý¿âÈÕ־ģʽ             ·Ç´æµµÄ£Ê½
×Ô¶¯´æµµ             ½ûÓÃ
´æµµÖյ㠠          USE_DB_RECOVERY_FILE_DEST
×îÔçµÄÁª»úÈÕÖ¾ÐòÁР    112
µ±Ç°ÈÕÖ¾ÐòÁР          114
SQL> shutdown immediate;
Êý¾Ý¿âÒѾ­¹Ø±Õ¡£
ÒѾ­Ð¶ÔØÊý¾Ý¿â¡£
ORACLE Àý³ÌÒѾ­¹Ø±Õ¡£
SQL> startup mount;
ORACLE Àý³ÌÒѾ­Æô¶¯¡£
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             230689668 bytes
Database Buffers          373293056 bytes
Redo Buffers                7135232 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£
SQL> alter database archivelog;
Êý¾Ý¿âÒѸü¸Ä¡£
SQL> alter database open;
Êý¾Ý¿âÒѸü¸Ä¡£
TNS´íÎó£º
C:\Documents and Settings\Administrator>set oracle_sid=sgxxcyj


Ïà¹ØÎĵµ£º

Oracle 10g Logminer Ñо¿¼°²âÊÔ

LogMinerÌṩÁËÒ»¸ö´¦ÀíÖØ×öÈÕÖ¾Îļþ²¢½«ÆäÄÚÈÝ·­Òë³É´ú±í¶ÔÊý¾Ý¿âµÄÂß¼­²Ù×÷µÄSQLÓï¾äµÄ¹ý³Ì¡£LogMinerÔËÐÐÔÚOracle°æ±¾8.1»òÕ߸ü¸ß°æ±¾ÖС£
 
 
Ò»£¬ÈçºÎʹÓÃLogminer:   
ÏÈÒª°²×°logminerµÄÁ½¸ö°ü£»ÒÔSYSÓû§ÔËÐÐÏÂÃæÁ½¸ö½Å±¾,ÆäÖеÚÒ»¸ö½Å±¾dbmslm.sqlÓÃÀ´´´½¨DBMS_LOGMNR°ü£¬¸Ã°üÓÃÀ´·Ö ......

windows ÏÂÃæoracle·þÎñÆ÷ instant clientµÄ°²×°

×ܵÄÀ´ËµwindowsÏÂÔØ°²×°oracleÈí¼þ±ÈlinuxÏÂÒª¼òµ¥µÄ¶à¡£
Ò».°²×°oracle ·þÎñ¶Ë
1.oracle·þÎñÆ÷µÄÏÂÔØÍøÖ·ÈçÏ£º
    http://www.oracle.com/technology/software/products/database/index.html
    È»ºóÎÒÑ¡ÔñÁËÏÂÃæÕâ¸ö°²×°°ü£º
    Oracle Database 10g Release 2 ( ......

OracleǧÍòÌõ¼Ç¼²åÈëÓë²éѯС½á

×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£Ô­ÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËÆºõ±äµÃÏ൱À§ÄÑ¡£¼¸¾­ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
1¡¢ ±ÜÃâʹÓÃHibernate¿ò¼Ü
HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£
¹ØÓÚ²åÈ룺 ......

oracleÌØÊ⺯ÊýÓ÷¨

<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·­ÒëÖµ1,Öµ2,·­ÒëÖµ2,...Öµn,·­ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·­ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......

oracleѧϰ±Ê¼Ç(¶þ)·ÖÏíÖ®´æ´¢¹ý³ÌǶÌ×ÓαêÀý×Ó

create or replace procedure aa1 is
v_aa varchar2(20);
v_bb varchar2(20);
va_aa varchar2(20);
va_bb varchar2(20);
va_number_aa number;
message varchar2(60);
CURSOR aas is
SELECT DISTINCT aa.aa, aa.bb from aa;
CURSOR aaas is
SELECT DISTINCT aaa.aa, aaa.bb from aaa where aaa.aa = v_aa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ