Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

ORACLEÌåϵ½á¹¹


Ò»¡¢             ÄÚ´æ½á¹¹
¹²Ïí³Ø£º·ÖΪ¿â¸ßËÙ»º´æºÍ×Öµä¸ßËÙ»º³åÇø
¿â¸ßËÙ»º´æ£¬ÓÃÓÚ´æ´¢¾­¹ýÓï·¨·ÖÎö²¢ÇÒÕýÈ·µÄSQLÓï¾ä£¬²¢ËæÊ±×¼±¸Ö´ÐС£
×Öµä¸ßËÙ»º³åÇø£¬´æ´¢µÇ½µ½ORACLEµÄÓû§Ãû£¬¼°ÕâЩÓû§ÓÐÄÄЩÊý¾Ý¿â¶ÔÏóÒÔ¼°ÕâЩÊý¾Ý¿â¶ÔÏóµÄλÖá£
Êý¾Ý»º³åÇø£ºÊý¾Ý¸ßËÙ»º³åÇø°üº¬Èý¸öÀàÐ͵ÄÇøÓò
keep»º³å³Ø¡¢recycle»º³å³Ø¡¢ default»º³å³Ø
                     ´æ·ÅORACLEϵͳ×î½üʹÓùýµÄÊý¾Ý¿é
       ÈÕÖ¾»º³åÇø£º
ÈκÎÊÂÎñÔڼǼµ½ÖØ×öÈÕ־֮ǰ¶¼±ØÐëÊ×Ïȷŵ½ÖØ×öÈÕÖ¾»º³åÇøÖУ¬È»ºóÓÉÈÕ־дÈë½ø³Ì¶¨ÆÚ½«´Ë»º³åÇøµÄÄÚÈÝдÈëÖØ×öÈÕÖ¾ÖÐ
¶þ¡¢             ºǫ́½ø³Ì
PMON£º
              ¼à¿ØÓû§½ø³Ì£¬ÓÃÓÚÖÕÖ¹ÄÇЩʧ°ÜµÄÓû§ÒÔ¼°ÊÍ·ÅÓû§ËùÕ¼ÓõÄ×ÊÔ´µÈ
SMON£º
        &nb ......

ORACLE Êý¾Ý¿â¶ÔÏó

ORACLE Êý¾Ý¿â¶ÔÏó
——Ë÷Òý
 
q      Ë÷ÒýÊÇÓë±íÏà¹ØµÄÒ»¸ö¿ÉÑ¡½á¹¹
q      ÓÃÒÔÌá¸ß SQL Óï¾äÖ´ÐеÄÐÔÄÜ
q      ¼õÉÙ´ÅÅÌI/O
q      ʹÓà CREATE INDEX Óï¾ä´´½¨Ë÷Òý
q      ÔÚÂß¼­ÉϺÍÎïÀíÉ϶¼¶ÀÁ¢ÓÚ±íµÄÊý¾Ý
q      Oracle ×Ô¶¯Î¬»¤Ë÷Òý
 
Ë÷ÒýµÄÄ¿±ê£ºÌá¸ß²éѯÐÔÄÜ
 
Ë÷Òý¶ÔÔöɾ¸Ä²éµÄÓ°Ïì
SQLÓï¾ä
¶ÔÐÔÄܵÄÓ°Ïì
SELECT
²éѯÐÔÄÜÌá¸ß
UPDATE
¸üÐÂɾ³ýʱÐèÒªÏȲéѯ£¬´Ó´Ë½Ç¶ÈÐÔÄÜÌá¸ß
¸üÐÂɾ³ýʱÒýÆðË÷ÒýÐ޸ģ¬´Ó´Ë½Ç¶ÈÐÔÄÜϽµ
DELETE
INSERT
Ôö¼ÓÒýÆðË÷Òý¸Ä±ä£¬Ë÷Òý¶ÔÆä¸ºÃæÓ°Ïì¸ü´ó£¬ÐÔÄÜϽµ
 
ʲôʱºò½¨Á¢Ë÷Òý£¿
1.         ÐèҪƵ·±²éѯµÄÊý¾Ý
2.         Êý¾ÝÁ¿½Ï¶à
3.         ¸ÃÁв»»áƵ·± update/insert/delete
4.         ÔÚ where/order by/group by ×Ö¾äÖгöÏÖµ ......

ORACLEÓαê

ORACLEÓαê
Óα꣺ÈÝÆ÷£¬´æ·Åµ±Ç°SQLÓï¾äÓ°ÏìµÄ¼Ç¼
       ËùÓÐDMLÓï¾ä¶¼»áÓõ½Óαê
      
       ÖðÐд¦ÀíÓ°ÏìµÄÐÐÊý
 
Óαê
       ¾²Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐǰ¹ØÁª
       ¶¯Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐʱ¹ØÁª
Óαê
       ÒþʽÓα꣺×Ô¶¯ÉùÃ÷¡¢´ò¿ª¡¢¹Ø±Õ£¬ÆäÃûSQL
       ÏÔʽÓα꣺
       REFÓα꣺£¨¶¯Ì¬Óα꣩
ÏÔʽÓαê²Ù×÷¹ý³Ì
       ÉùÃ÷Óα꣨¹ØÁªSQLÓï¾ä£©                    cursor Ãû×Ö is/as sqlÓï¾ä£¨DML£©;
       ´ò¿ªÓαִ꣨ÐÐSQLÓï¾ä£¬Ìî³äÓα꣩ open Ãû×Ö;
       ´ÓÓαêÖÐÌáȡֵ£¬´æ·Åµ½ÐÐÀàÐͱäÁ¿ÖР fetch Ãû×Ö into ÐÐÀàÐͱäÁ¿;
    ......

ORACLE³ÌÐò°ü

³ÌÐò°ü
 
°üÖ÷Ìå/¹æ·¶Ãû×ÖÒ»Ñù
°üÖ÷Ìå/¹æ·¶ÖеĶÔÓ¦²ÎÊý±ØÐëÀàÐͼ°Ãû×ÖÒ»Ñù
Ö»ÄÜʹÓÃÇ¿ÀàÐ͵ÄREFÓαê
 
´´½¨³ÌÐò°ü¹æ·¶
create or replace package my_pack
is
       procedure find_emp_proc(eno emp.empno%type);
       function find_emp_fun(eno emp.empno%type) return emp.ename%type;
end my_pack;
 
SQL> ed
SQL> /
 
Package created
 
µ÷Óú¯Êý
SQL> select my_pack.find_emp_fun(7788) from dual;
 
select my_pack.find_emp_fun(7788) from dual
 
ORA-04068: ÒѶªÆú³ÌÐò°ü  µÄµ±Ç°×´Ì¬
ORA-04067: δִÐУ¬package body "SCOTT.MY_PACK" ²»´æÔÚ
ORA-06508: PL/SQL: ÎÞ·¨ÔÚµ÷ÓÃ֮ǰÕÒµ½³ÌÐòµ¥Ôª
ORA-06512: ÔÚline 1
 
Ö´Ðд洢¹ý³Ì
SQL> exec my_pack.find_emp_proc(7788);
 
begin my_pack.find_emp_proc(7788); end;
 
ORA-04068: ÒѶªÆú³ÌÐò°ü  µÄµ±Ç°×´Ì¬
ORA-04067: δִÐУ¬package body "SCOTT.MY_PACK" ²»´æÔÚ
ORA-06508: PL/SQL: ÎÞ·¨ÔÚµ÷ÓÃ֮ǰÕÒµ½³ÌÐòµ¥Ôª
ORA-06512: ......

AjaxʹÓÃʾÀý

/***************************by
garcon1986********************************/
Index.php:
<script type="text/javascript" src="ajax.js" ></script>
<a href="#" onclick="funphp('S')" >S</a>
<a href="for.php?url=E" >E</a>
<div id="idiv"></div>
for.php:
<?php
error_reporting(E_ALL ^ E_NOTICE);
if($url = $_GET[url]){
for($i=1;$i<10;$i++){
echo $url;
}
exit();
}
?>
Ajax.js:
//Ê×ÏÈÉùÃ÷±äÁ¿
var xmlHttp;
//´´½¨¶ÔÏóº¯Êý
function GetXmlHttpObject(){
try{
//Firefox, Opera, Safari
xmlHttp = new XMLHttpRequest();
}
catch(e){
try{
//MS IE 6.0+
xmlHttp = new ActiveXObject(Msxml2.XMLHTTP);
}
catch(e){
try{
//MS IS 5.5+
xmlHttp = new ActiveXObject(Microsoft.XMLHTTP);
}
catch(e){
alert("ÄúµÄä¯ÀÀÆ÷²»Ö§³ÖAJAX£¡");
return false;
}
}
}
}
//·¢ËÍÇëÇóº¯Êý
function funphp(t){
//µ÷ÓÃGetXmlHttpObjectº¯Êý
GetXmlHttpObject();
//open() ·½·¨ÐèÒªÈý¸ö²Î ......

2010ÄêÖйúWAP¹ã¸æÊг¡¹æÄ£


´ÓÖйúÒÆ¶¯¹ã¸æÖ÷Ҫϸ·ÖÊг¡¹æÄ£À´¿´£¬2006ÄêWAP¹ã¸æÊг¡¹æÄ£Îª0.6ÒÚÔª£»ÖÁ2007Ä꣬WAP¹ã¸æÊг¡¹æÄ£Ô¤¼Æ½«´ïµ½1.7ÒÚÔª£¬Ôö³¤183%£»·¢Õ¹µ½2008Ä꣬WAP¹ã¸æÊг¡¹æÄ£Ô¤¼Æ½«´ïµ½3.5ÒÚÔª£¬Ôö³¤106%£»ÖÁ2010Ä꣬ÖйúWAP¹ã¸æÔ¤¼Æ½«´ïµ½7ÒÚÔªÊг¡¹æÄ£¡£2006-2010ÄêÖйúWAP¹ã¸æÊг¡¹æÄ£ÄêÆ½¾ù¸´ºÏÔö³¤ÂÊ´ïµ½85%£¬Êг¡±íÏÖ½«³¬¹ýÕûÌåÒÆ¶¯¹ã¸æÊг¡¡£
 
×öΪÔÚÊÖ»úýÌåÁìÓòÑо¿ÁË4ÄêµÄÀÖ¹ËÍŶÓÀ´Ëµ£¬ÕâÎÞÒÉÊǸöºÃÏûÏ¢¡£×Ô2005ÄêÒÔÀ´£¬Ò»Ö±ÔÚ×öÊÖ»úýÌåÓ¦ÓõÄÑо¿¿ª·¢£¬Öм䳢ÊÔ¹ý¶àÖÖ¹ã¸æÐÎʽÏò½áºÏµÄÔË×÷Ä££¬Ê½µ«Ã»ÓÐ×îÖÕÕÒµ½Ò»¸ö¿ÉÒÔÒýÁìδÀ´µÚÎåýÌåµÄ×î¼Ñ×éºÏģʽ¡£09Äê8Ô·ݣ¬È«ÐµĸöÈËýÌå½áºÏÊý×Ö³ö°æÏµÍ³µÄÕûºÏÔË×÷ģʽÕýʽÉÏÏߣ¡½áºÏ±¨Éç¡¢³ö°æÉçµÄÄÚÈÝÕûºÏÓÅÊÆ£¬Ó¦ÓÃ×ÔÖ÷Ñз¢µÄÈ«ÇòÁìÏȵŦÄÜÇø¶¨Î»ÏµÍ³ºÍ´¥·¢¹ã¸æ»úÖÆ£¬¿ª´´ÁËÊÖ»úýÌåÍêÉÆµÄÔË×÷»úÖÆ£¬³¹µ×´òÆÆÁË´«Í³Ã½ÌåºÍ»¥ÁªÍøÃ½ÌåµÄ¸ôĤ¡£
 
¾ß±¸ÊÖ»úä¯ÀÀÆ÷¹¦ÄܵÄÀÖ¹ËÈí¼þ£¬¿ÉÒÔ»ñÈ¡×ʱȨÍþµÄÐÂÎÅ×ÊѶ£¬¼°Ê±Á˽âÖܱßÉú»î¶¯Ì¬£¬ËæÊ±ËæµØ´¥·¢Öܱßʼþ¡£ÏòϵͳÌá½»ÄãµÄ×îÐÂÐèÇó£¬Öܱß3¹«ÀïÄÚÊʺÏÄãµÄÐÅÏ¢Ò»Ò»·¢µ½ÄãµÄÊÖ»ú×ÀÃæ£»Ò²ÐíÄã¸Õ¿ç½øKFCµÄµêÃÅ¡¢¹¦ÄÜÇø¶¨Î»ÏµÍ³²¶×½µ½ÄãµÄ¶¯×÷£¬Á¢¼´½«×îеç×ÓÓÅ»ÝÈ ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2830] [2831] [2832] [2833] 2834 [2835] [2836] [2837] [2838] [2839]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ