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

oracleÊÂÎñµÄÖ´Ðйý³Ì

1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
             Ê×ÏÈ¿Í»§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
 
2.Ìá½»sql:
  (1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösqlÖÁoracle·þÎñÆ÷ʵÀý½ø³Ì,oracleÊ×Ïȼì²éÒ»ÏÂsgaµÄ¹²ÏísqlÇøÊÇ·ñÓÐÏàͬ½á¹¹µÄsql,Èç¹ûÓоÍÓÃËüµÄÖ´Ðз¾¶ºÍ×ÊÔ´,Èç¹ûûÓоʹ´½¨sqlµÄÖ´Ðз¾¶Óë×ÊÔ´ºÍÖ´Ðмƻ®,´´½¨Íê³Éºó,½«sqlµÄ½á¹¹·ÅÔÚ¹²ÏíÇø;
  (2)ʵÀý½«sqlµÄ¸üвÙ×÷֮ǰµÄԭʼÐÅÏ¢·ÅÖÁ»Ø¹ö¶ÎºÍredo¶Î;
  (3)ʵÀýÍê³ÉsqlµÄ¸üвÙ×÷,½«¸üкóµÄÊý¾Ý·ÅÖÁÊý¾Ý»º´æ¶ÎÖÐ;
  (4)¿Í»§¶ËÌá½»ÊÂÎñ(commit);
  (5)Êý¾Ý¿âʵÀý½«redo¶ÎÖеÄÐÅϢдÈëredoÈÕÖ¾ÎļþÖÐ,Ìá½»Íê³Éºó,Íê³ÉÊÂÎñµÄÌá½»;
  (6)¸æËß¿Í»§¶Ë,ÊÂÎñÌá½»Íê³É.(×¢ÒâÕâʱÊý¾Ý¶Î»º´æÖеÄÊý¾Ý²¢Î´Ð´ÈëÊý¾ÝÎļþÖÐ,ʵÀý½ø³Ì»á¶¨Ê±½«Êý¾Ý¶Î»º´æÖеÄÊý¾ÝдÈëÊý¾ÝÎļþÖÐ);


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

OracleÎﻯÊÓͼ

OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......

¡¾×ª¡¿ÈçºÎ²é¿´oracle sqlÖ´Ðмƻ®

·½·¨Ò»
µÚÒ»²½£ºµÇÈësql/plus Ö´ÐÐÃüÁÎÞÏȺó˳Ðò£©
set   time   on; (˵Ã÷£º´ò¿ªÊ±¼äÏÔʾ£©  
  set   autotrace   on; (˵Ã÷£º´ò¿ª×Ô¶¯·ÖÎöͳ¼Æ£¬²¢ÏÔʾSQLÓï¾äµÄÔËÐнá¹û£©  
  set   autotrace   traceonly; (˵à ......

Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü

Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
    °²×° Tomcat5.0 Ç°ÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server ......

OracleÊý¾Ý×ÖµäµÄµ¼³ö

-- ²éѯij±íµÄÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ1",A.DATA_TYPE AS "×ֶΠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ