´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING
DATAFILE ' C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEST_DATA01.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§²¢Öƶ¨±í¿Õ¼ä
CREATE USER username IDENTIFIED BY password
DEFAULT TABLESPACE TEST_DATA
TEMPORARY TABLESPACE TEST_TEMP;
¸øÓû§ÊÚÓèȨÏÞ
GRANT
¡¡¡¡ CREATE SESSION, CREATE ANY TABLE , CREATE ANY VIEW , CREATE ANY INDEX , CREATE ANY PROCEDURE ,
¡¡¡¡ ALTER ANY TABLE , ALTER ANY PROCEDURE ,
¡ ......
ÅäÖÃÉí·ÝÑéÖ¤
OracleΪÓû§ÕË»§ÌṩÈýÖÖÉí·ÝÑéÖ¤·½·¨£º
(1)ÃÜÂëÑéÖ¤
µ±Ò»¸öʹÓÃÃÜÂëÑéÖ¤»úÖÆµÄÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµØÊý¾Ý¿âÓû§£¬²¢ÇÒÌṩÓë¸ÃÓû§ÔÚÊý¾Ý¿âÖд洢µÄÃÜÂëÏàÆ¥ÅäµÄÃÜÂë¡£
(2)ÍⲿÑéÖ¤
µ±Ò»¸öÍⲿÑé֤ʽÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµÄÊý¾Ý¿âÕË»§£¬²¢È·ÐŸÃÓû§ÒѾÍê³ÉÁ˲Ù×÷ϵͳ¼¶±ðµÄÉí·ÝÑéÖ¤¡£
(3)È«¾ÖÑéÖ¤
È«¾ÖÑé֤ʽÓû§Ò²²»ÔÚÊý¾Ý¿âÖд洢ÑéÖ¤ÃÜÂ룬ÕâÖÖÀàÐ͵ÄÑéÖ¤ÊÇͨ¹ýÒ»¸ö¸ß¼¶°²È«Ñ¡ÏîËùÌṩµÄÉí·ÝÑéÖ¤·þÎñÀ´½øÐеġ£
´´½¨Óû§
sql> create user shoo identified by "wangsHuo"
sql> default tablespace tempts
sql> temporary tablespace temp;
sql> quota unlimited on tempts; -- Óû§ÔÚtempts±í¿Õ¼ä²»ÊÜÏÞÖÆ
-- sql> quota XXXm on tempts; -- ÅäÖÃÓû§ÔÚ±í¿Õ¼äÉϵĴÅÅÌÏÞ¶î
-- sql> quota 0 on system; -- ²»ÔÊÐí¸ÃÓû§Ê¹ÓÃsystem±í¿Õ¼ä
ȨÏÞ¹ÜÀí
ÔÚOracleÊý¾Ý¿âÖÐȨÏÞ·ÖΪÁ½´óÀࣺϵͳȨÏÞ(System privilege)ºÍ¶ÔÏóȨÏÞ(Object privilege)¡£
ϵͳȨÏÞÊÇÔÚϵͳ¼¶¶ÔÊý¾Ý¿â½øÐдæÈ¡ºÍʹÓõĻúÖÆ£¬±ÈÈ磬Óû§ÊÇ·ñÄܹ»Á¬½Óµ½Êý¾Ý¿âϵͳ(sessio ......
ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mstrdw)
)
)
ÉÏÊö´úÂëÖÐÊ×ÐÐmstrdwÇ°Ãæ²»ÄÜÓпոñ£¬ÆäÓಿ·ÖÐÐÊ×±ØÐëÓпոñ¡£
ºô~
Æäʵ£¬¶ÔÓÚ±¾µØNET·þÎñÃûµÄÅäÖ㬻¹ÊÇÖ±½Óͨ¹ýNET configuration assistantÀ´±£ÏÕЩ~
......
±Õ°ü¸ÅÄ±Õ°ü¾ÍÊÇÄܹ»¶ÁÈ¡ÆäËûº¯ÊýÄÚ²¿±äÁ¿µÄº¯Êý¡£
ÓÉÓÚÔÚJavascriptÓïÑÔÖУ¬Ö»Óк¯ÊýÄÚ²¿µÄ×Óº¯Êý²ÅÄܶÁÈ¡¾Ö²¿±äÁ¿£¬
Òò´Ë¿ÉÒ԰ѱհü¼òµ¥Àí½â³É“¶¨ÒåÔÚÒ»¸öº¯ÊýÄÚ²¿µÄº¯Êý”¡£
function f1(){
¡¡¡¡¡¡¡¡n=999;
¡¡¡¡¡¡¡¡function f2(){
¡¡¡¡¡¡¡¡¡¡¡¡alert(n);
¡¡¡¡¡¡¡¡}
¡¡¡¡¡¡¡¡return f2;
¡¡¡¡}
¡¡¡¡var result=f1();
¡¡¡¡result(); // 999
ÓÃevalº¯Êý½«ajax ·µ»ØµÄjson×Ö·û´®×ª»»³Éjs¶ÔÏóʱÐèÒªÓÃÒ»¶Ô"()"ÏȽ«¸Ã×Ö·û´®°üס;
js´úÂ룺
function jsonToJsObj(){
var jsonStr='{"name":"ëÔó¶«","sex":"ÄÐ"}';//»¨À¨ºÅÍâÃæ»¹ÒªÓÐ"'"·ûºÅ;???
var jsObj=eval("("+jsonStr+")");
alert(jsObj.name);
}
......
À´Ô´£ºhttp://developer.51cto.com/art/200906/129502.htm
±¾ÎĽéÉÜÁËËÄÖÖÁ÷ÐеÄAJAX¿ò¼Ü£¬°üÀ¨¼ò½àµÄjQuery£¬ÃæÏò¶ÔÏóµÄ
Mootools£¬ÓµÓÐÇ¿´óÖ§³ÖµÄDojo£¬ÒÔ¼°×é¼þ»¯£¬RIA»¯µÄExt JS¡£
AJAX
ÊÇweb20
µÄ»ùʯ£¬ÏÖÔÚÍøÉÏÁ÷Ðм¸ÖÖ¿ªÔ´µÄ
AJAX¿ò¼Ü£¬±ÈÈ磺jQuery,Mootools,Dojo,Ext JSµÈµÈ£¬ÄÇôÎÒÃǵ½µ×ÔÚʲôÇé¿öϸÃʹÓÃÄǸö¿ò¼Ü£¿ÒÔÏÂÊÇÒ»×éÕª³µÄÊý¾Ý£º
AjaxianÔÚ2007Äêµ×¶ÔAjax¹¤¾ß½øÐÐÁ˵÷²é£¬²¿·Öµ÷²é½á¹û¼ûÏÂ±í£¨ÆäÖÐÊý×ÖΪµ÷²éÕßʹÓøù¤¾ßµÄ°Ù·Ö±È£¬ÏêϸµÄÇë²Î¼ûÍøÒ³£©£ºhttp://ajaxian.com/archives/2007-ajax-tools-usage-survey-results
Prototype
jQuery
Ext
Script.aculo.us
Mootools
YUI
JSON
Dojo
Backbase
34.1%
29.3%
22.5%
22.3%
14.3%
13%
12.9%
11.8%
8.3%
ÆäÖÐPrototypeʹÓÃÂÊ×î¸ß£¬ºÜ´ó³Ì¶ÈÉÏÊÇÒòΪËüÊÇ×îÔç³ÉÊìµÄ¿ò¼Ü£¬ºÜ¶àÒÔǰÔÚÏîÄ¿ÖвÉÓã¬ËùÒÔÏÖÔÚÒ»Ö±ÔÚÓÃ
ÈÃÎÒÃÇÀ´¿´¿´Ñ¡ÔñAJAX¿ò¼ÜµÄ»ù´¡£º
ÄãµÄÏîÄ¿ÐèÇ󣨼´ÄãÐèÒªÄÄÐ©ÌØÐÔ£¬ÀýÈçÊÇ·ñÒªÇó×ö³ö¾«ÃÀµÄ½çÃæ¡¢ÌØÐ§»òÆäËü¹¦ÄÜ£©
ÊÇ·ñÖ§³ÖAµÈ¼¶µÄä¯ÀÀÆ÷£¨IE, FirefoxµÈ£©?
ÎĵµµÄÖÊÁ¿£ºÊÇ·ñÍêÉÆ£¨°üº¬½Ì³Ì£¬API£¬´úÂëʾÀýµÈ£©
¿ò¼ÜµÄ¿ÉÀ©Õ¹ÐÔÈçºÎ£¿Îª¿ò¼Üд²å¼þÈÝÒ×Âð£¿
......
XHTML MP (XHTML Mobile Profile) ¼ò½é
ʲôÊÇ XHTML MP?
XHTML MP (¿ÉÀ©Õ¹±ê¼ÇÓïÑÔÒÆ¶¯¸ÅÒª) WAP 2.0 Öж¨ÒåµÄ±ê¼ÇÓïÑÔ. WAP 2.0 ÊÇ WAP ÂÛ̳ (ÏÖΪ¿ª·ÅÒÆ¶¯ÁªÃË [OMA]) ´´½¨µÄ×îеÄÒÆ¶¯·þÎñ˵Ã÷. ¶Ô WAP CSS (WAP ¼¶ÁªÑùʽµ¥»ò WCSS) µÄ˵Ã÷Ò²ÔÚ WAP 2.0 ÖÐ×÷Á˶¨Òå. WAP CSS ÊÇ XHTML ÒÆ¶¯¸ÅÒªµÄ°éÂÂ, ¶þÕß³£±»Ò»ÆðʹÓÃ. ÓÐÁË WAP CSS, Äã¿ÉÒÔÇáËɵظıäÓë¸ñʽ»¯ XHTML MP Ò³ÃæµÄÕ¹ÏÖ.
XHTML ÒÆ¶¯¸ÅÒªÊÇ XHTML µÄ×Ó¼¯, ÊÇ HTML µÄ¸üÑϸñµÄ°æ±¾. XHTML ÒÆ¶¯¸ÅÒªÊÇ XHTML »ù´¡ (Basic, Ò²ÊÇ XHTML µÄÒ»¸ö×Ó¼¯) ¼ÓÉÏÁË XHTML ÍêÈ«°æÖÐһЩ¶îÍâµÄÔªËØºÍÊôÐÔ.
XHTML ÒÆ¶¯¸ÅÒªµÄÄ¿±ê, ÊǰÑÒÆ¶¯ÒòÌØÍøä¯ÀÀºÍÍòÎ¬Íøä¯ÀÀµÄ¼¼Êõ½áºÏÆðÀ´. ÔÚ XHTML ÒÆ¶¯¸ÅÒª²úÉú֮ǰ, WAP ¿ª·¢ÈËÔ±Óà WML ºÍ WMLScript ´´½¨ WAP ÍøÕ¾, ¶ø Web ³ÌÐòÔ±Óà HTML / XHTML ºÍ CSS ¿ª·¢ Web ÍøÕ¾.
XHTML ÒÆ¶¯¸ÅÒª·¢²¼ºó, ÎÞÏßÊÀ½çºÍÓÐÏßÊÀ½çµÄ±ê¼ÇÓïÑÔ×îÖÕ»ã¾Ûµ½ÁËÒ»Æð. XHTML ÒÆ¶¯¸ÅÒª ºÍ WAP CSS ¸³ÓèÁËÎÞÏßÒòÌØÍøÓ¦Óÿª·¢ÈËÔ±¸ü¶à¸üºÃµÄÕ¹ÏÖ¿ØÖÆ. È»¶ø, ×î´óµÄÓŵã, ÊÇÄãµÄ Web °æºÍÎÞÏß°æÒòÌØÍøÍøÕ¾¿ÉÒÔÓÃͬÑùµÄ¼¼Êõ¿ª·¢. Äã¿ÉÒÔÔÚÔÐÍ»¯ºÍ¿ª·¢¹ý³ÌÖÐÓÃÈκΠWeb ä¯ÀÀÆ÷²é¿´ÄãµÄ WAP2.0 Ó¦ÓóÌÐò.
......