Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ×îÐÂÎÄÕ :

Ê® ¸ö×îÎÅÃûµÄ JavaScript ¿â

 JavaScript ÊÇ Web ¿ª·¢ÓëÉè¼ÆÖÐȱһ²»¿ÉµÄ»õÉ«£¬²»¹ÜÊÇÒ»¸ö¼òÂÔµÄÍøÒ³ÈÔÊÇÒ»¸öרҵµÄÕ¾µã£¬Ò²±Â¹ÜÄãÊǺÃÊÖÈÔÊDzËÄñ£¬ÏÖ½ñ JavaScript ¿âÓúÀ´ÓúÇ¿´ó£¬¿ÉÒÔʤÈκöิÔӵŤ×÷£¬È»ÔòÓë´Ëͬʱ£¬ÖÚÈËÔÚ·ºÀÄ JavaScript ¿âÑÛǰÓÖ¾õ×Ų»ÖªËù´ë£¬ÕýÎÄ£¬ÎÒÃǽ«Ó¦Óà Google ËÑѰ³öÅÅÐÐǰ Ê® λµÄ JavaScript ¿â£¬²¢¶ÔËüÃÇÖð¸ö¿ªÕ¹Òý¼û¡£
1. jQuery: The Write Less, Do More, JavaScript Library
jQuery ÊÇÒ»¸öºÜÐ嵀 JavaScript ¿â£¬ËüµÄ¼´ÐËÊ«ÊÇ“¼¸ÐдúÂ룬ÄܸɴóÊ”£¨Write Less, Do More£©£¬ËüÊÇÓµÓÐÖÁ¶à²å¼þºÍÀ©³äµÄ JavaScript ¿â£¬ÒÔ´ÎÊÇ jQuery ÏÖ¾Ö£º
•Ïֽ׶ΰ汾£º 1.3.2
•×ÊÁϳßÂ룺ѹËõºó×îС19KB£¬Î´Ñ¹ËõΪ120K¡£
•д¸åÈË£º John Resig
•ÓµÓÐ19ÖÖÓïÑԵĿγÌ: ¿Î³ÌÀÛ¼Æ183ÖÖ¡£
•ÎÅÃûÓû§£º ³¬¹ý1000¸ö
•²å¼þ: 3493
•Ò×ѧ
•¶ÔÉè¼ÆÔ±À´ËµÊ®·ÖÒ×ѧ£¬ÔËÓà CSS Óï·¨
•ÓµÓдóÁ¿ÓÐȤµÄÀ©³ä
•ÓµÓÐÊ®·Ö׿ԽµÄÉçÇø£¬¿ÉÄÜÊÇ×î´óµÄ
•±»ÊýÒÔ°ÙÍòµÄÕ¾µãÓ¦Ó㬰üÀ¨Æ©Èç Google, Dell, CBS, NBC, DIGG, Bank of America, Wordpress, Drupal, Mozilla µÈÎÅÃûÕ¾µã¡£
2. MooTools – a com ......

Ubuntu9.04ÏÂOracleÊÖ¶¯Æô¶¯Óë×ÔÆô¶¯½Å±¾

 
Ubuntu9.04ÏÂOracleÊÖ¶¯Æô¶¯Óë×ÔÆô¶¯½Å±¾
Ò»¡¢Æô¶¯Êý¾Ý¿âʵÀý
Java´úÂë
gengzhi
@gengzhi
-desktop:~$ su oracle  
oracle@gengzhi
-desktop:~$ sqlplus 
" scott/tiger  as sysdba"
   
gengzhi@gengzhi-desktop:~$ su oracle
oracle@gengzhi-desktop:~$ sqlplus " scott/tiger as sysdba"
    ½«³öÏÖÈçÏÂÁ¬½ÓÊý¾Ý¿âÐÅÏ¢£º
Sql´úÂë
SQL*Plus: Release 10.1.0.2.0 - Production 
on
 ÐÇÆÚÈý 3Ô 24 16:23:27 2004   
Copyright (c) 1982, 2004, Oracle.  All
 rights reserved.   
Á¬½Óµ½:   
Oracle Database
 10g Enterprise Edition Release 10.1.0.2.0 - Production   
With
 the Partitioning, OLAP 
and
 Data Mining options   
SQL>    ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Èý)

 1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ  ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»»á±»Ð´ÈëÆ÷×èÈû£¬µ«ÔÚÆäËûÊý¾Ý¿âÖпÉÄܲ»ÊÇÕâÑù¡£
Oracle Êý¾Ý¿âÖÐÓÐÁ½¸ö·Ç³£ÖØÒªµÄ¸ÅÄî¡£¶à°æ±¾£¨multi-versioning£©Ò»´ÊʵÖÊÉÏÖ¸Oracle Äܹ»´Ó
Êý¾Ý¿âͬʱÎﻯ¶à¸ö°æ±¾µÄÊý¾Ý¡£Èç¹ûÄãÀí½âÁË¶à°æ±¾ÈçºÎ¹¤×÷£¬¾Í»áÖªµÀÄÜ´ÓÊý¾Ý¿âµÃµ½Ê²Ã´¡£ÔÚ½øÒ»
²½ÉîÈëÌÖÂÛOracle ÈçºÎʵÏÖ¶à°æ±¾Ö®Ç°£¬ÏÂÃæÓÃÎÒÈÏΪ×î¼òµ¥µÄÒ»¸ö·½·¨À´ÑÝʾOracle ÖÐµÄ¶à°æ±¾£º
( p_resource_name, p_start_time, p_end_time );
end schedule_resources;
ops$tkyte@ORA10G> create table t
2 as
3 select *
4 from all_users;
Table created.
ops$tkyte@ORA10G> variable x refcursor
ops$tkyte@ORA10G> begin
2 open :x for select * from t;
3 end;
4 /
PL/SQL procedure successfully completed.
ops$tkyte@ORA10G> delete from t;
28 rows deleted.
o ......

ÍêÈ«Ð¶ÔØOracle

ÍêÈ«Ð¶ÔØOracle
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾
Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
5¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
6¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯
Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú¡£
7¡¢ ÔËÐÐrefedit£¬
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application£¬
ɾ³ýËùÓÐOracleÈë¿Ú¡£
8¡¢ ¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾ÏµÍ³£­£¾¸ß¼¶£­£¾»·¾³±äÁ¿
ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
9¡¢ ´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
10¡¢ ɾ³ý\Program Files\OracleĿ¼
11¡¢ ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
12¡¢ ɾ³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕ ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (ËÄ)

 1.Êý¾Ý¿â¶ÀÁ¢ÐÔ
½«Ó¦ÓôÓÊý¾Ý¿âA ÒÆÖ²µ½Êý¾Ý¿âB ʱ£¬ÎÒʱ³£Óöµ½ÕâÖÖÎÊÌ⣺ӦÓÃÔÚÊý¾Ý¿âA ÉÏÔ­±¾ÎÞи¿É»÷£¬µ½ÁË
Êý¾Ý¿âB ÉÏÈ´²»Äܹ¤×÷£¬»òÕß±íÏֵúÜÀëÆæ¡£¿´µ½ÕâÖÖÇé¿ö£¬ÎÒÃǵĵÚÒ»¸öÏë·¨ÍùÍùÊÇ£¬Êý¾Ý¿âB ÊÇÒ»¸ö
“²»ºÃµÄ”Êý¾Ý¿â¡£¶øÕæÕýµÄÔ­ÒòÆäʵÊÇÊý¾Ý¿âB µÄ¹¤×÷·½Ê½ÍêÈ«²»Í¬¡£Ã»ÓÐÄĸöÊý¾Ý¿âÊÇ´íµÄ»ò“²»ºÃ
µÄ”£¬ËüÃÇÖ»ÊÇÓÐËù²»Í¬¶øÒÑ¡£Ó¦µ±Á˽ⲢÀí½âËüÃÇÈçºÎ¹¤×÷£¬Õâ¶ÔÓÚ´¦ÀíÕâЩÎÊÌâÓкܴóµÄ°ïÖú¡£½«Ó¦ÓÃ
´ÓOracle ÒÆÖ²µ½SQL Server ʱ£¬Ò²»á±©Â¶SQL Server µÄ×èÈû¶ÁºÍËÀËøÎÊÌ⣬»»¾ä»°Ëµ£¬²»ÂÛ´ÓÄĸö·½Ïò
ÒÆÖ²¶¼¿ÉÄÜ´æÔÚÎÊÌâ¡£
ÀýÈ磬ÓÐÈËÇëÎÒ°ïæ½«Ò»Ð©Transact-SQL£¨T-SQL£¬SQL Server µÄ´æ´¢¹ý³ÌÓïÑÔ£©×ª»»ÎªPL/SQL¡£
×öÕâ¸öת»»µÄ¿ª·¢ÈËÔ±Ò»Ö±ÔÚ±§Ô¹Oracle ÖÐSQL ²éѯ·µ»ØµÄ½á¹ûÊÇ“´íµÄ”¡£²éѯÈçÏÂËùʾ£º
Õâ¸ö²éѯµÄÄ¿±êÊÇ£ºÔÚT ±íÖУ¬Èç¹û²»Âú×ãij¸öÌõ¼þ£¬ÔòÕÒ³öx ΪNULL µÄËùÓÐÐУ»Èç¹ûÂú×ãij¸öÌõ
¼þ£¬¾ÍÕÒ³öx µÈÓÚij¸öÌØ¶¨ÖµµÄËùÓÐÐС£
¿ª·¢ÈËÔ±±§Ô¹Ëµ£¬ÔÚOracle ÖУ¬Èç¹ûL_SOME_VARIABLE δÉèÖÃΪһ¸öÌØ¶¨µÄÖµ£¨ÈÔΪNULL£©£¬ Õâ¸ö
²éѯ¾ÓÈ»²»·µ»ØÈκÎÊý¾Ý¡£µ«ÊÇÔÚSybase »òSQL Server Öв»ÊÇÕâÑùµÄ£¬²éÑ ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Îå)

 1.¾¡¿ÉÄܵØÊ¹Óð󶨱äÁ¿ ²»Óÿª¹ØCURSOR_SHARING=FORCE 
Èç¹ûÄãÔ¸Ò⣬Õâ¸öÌØÐÔ»áʵÏÖÒ»¸ö×Ô¶¯°ó¶¨Æ÷£¨auto-binder£©¡£
Èç¹ûÓÐÒ»¸ö²éѯ±àдΪSELECT * from EMP WHERE EMPNO = 1234£¬×Ô¶¯°ó¶¨Æ÷»áÇÄÎÞÉùÏ¢µØ°ÑËü¸Äд³É
SELECT * from EMP WHERE EMPNO = :x¡£ÕâȷʵÄܶ¯Ì¬µØ´ó´ó¼õÉÙÓ²½âÎöÊý£¬²¢¼õÉÙÇ°ÃæÌÖÂ۵Ŀâãŵȴý
ʱ¼ä——µ«ÊÇ£¨·²ÊÂ×ÜÓиö“µ«ÊÇ”£©£¬Ëü¿ÉÄÜÓÐһЩ¸±×÷Óá£Óα깲ÏíµÄÒ»¸ö³£¼û¸±×÷ÓÃÈçÏÂËùʾ£º
ops$tkyte@ORA10G> select /* TAG */ substr( username, 1, 1 )
2 from all_users au1
3 where rownum = 1;
S
-
B
ops$tkyte@ORA10G> alter session set cursor_sharing=force;
Session altered.
ops$tkyte@ORA10G> select /* TAG */ substr( username, 1, 1 )
2 from all_users au2
3 where rownum = 1;
SUBSTR(USERNAME,1,1)
ÕâÀïµ½µ×·¢ÉúÁËʲô£¿ÎªÊ²Ã´µ½µÚ¶þ¸ö²éѯʱSQL*Plus ±¨¸æµÄÁÐͻȻ±äµÃÕâô´ó£¿ÒªÖªµÀ£¬Õ⻹ÊÇ
ͬһ¸ö²éѯѽ£¡Èç¹û²é¿´Ò»ÏÂÓα깲ÏíÉèÖÃΪÎÒÃÇ×öÁËЩʲô£¬Ô­Òò¾Í»áºÜÇå³þÁË£¨»¹»áÃ÷°×ÆäËûһЩÎÊ
Ì⣩£º
Óα깲Ïí»áɾ³ý²éѯÖеÄÐÅÏ¢¡£ËüÕÒµ½Ã¿Ò»¸öÖ±½ÓÁ¿£¨literal£©£¬°ü ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [4990] [4991] [4992] [4993] 4994 [4995] [4996] [4997] [4998] [4999]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ