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ÊÖ¶¯Æô¶¯Óë×ÔÆô¶¯½Å±¾
Ò»¡¢Æô¶¯Êý¾Ý¿âʵÀý
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>
......
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
Èí¼þ»·¾³£º
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£¬É¾³ýÕ ......
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 Öв»ÊÇÕâÑùµÄ£¬²éÑ ......
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£©£¬°ü ......