±¾ÎÄÒë×Ô£ºhttp://www.codeproject.com/KB/scripting/jsbeginner.aspx
ÔÎÄ£ºJavaScript For Beginners
ÊÊÒ˶ÔÏó£ºJavaScript³õѧÕß¡£
Ŀ¼£º
°üº¬ÓëÒýÈë(Embedding,including)
write ºÍ writeln
Îĵµ¶ÔÏó£¨document object£©
bgColor ºÍ fgColor
ÏûÏ¢¿ò£¨Message Box£©
±äÁ¿£¨Variables£©ºÍÌõ¼þ£¨Conditions£©
º¯Êý£¨Function£©
onClick
onLoad
onUnload
±íµ¥£¨Form£©
onBlur
Á¬½Ó£¨Link£©
ÈÕÆÚ£¨Date£©
´°¿Ú£¨window£©
ÖØÐÂÔØÈ루Reload£©
¼ÓÔØ£¨Loading£©
Ò£¿Ø´°¿Ú
¿ªÆôÆ÷£¨opener£©
¿ò¼Ü£¨Frame£©
°üº¬ÓëÒýÈ루Embedding and including£©
ÈÃÎÒÃÇÏÈ¿´Ò»¸ö¼òµ¥µÄÀý×Ó£º
<html>
<head>
<title>This is a JavaScript example</title>
<script language="JavaScript">
<!--
document.write("Hello World!");
//-->
</script>
</head>
<body> Hi, man! </body>
</html>
ͨ³£Çé¿öÏ£¬JavaScript´úÂëÊÇÒÔ<script language="JavaScript">¿ªÍ·£¬²¢ÒÔ</script>½á⣬Õû¸ö´úÂë·ÅÔÚ<head> ºÍ &l ......
1. ´´½¨ÐµÄÊý¾Ý¿âʵÀý£º
D:\oracle\product\10.2.0\admin\adidb\scripts>dbca
2.Æô¶¯ºÍ¹Ø±ÕʵÀý
D:\oracle\product\10.2.0\admin\adidb\scripts>net start oracleserviceorcl
D:\oracle\product\10.2.0\admin\adidb\scripts>net stop oracleserviceorcl
3.Á¬½ÓÊý¾Ý¿âʵÀý
1> ÉèÖÃoracle_sid (set oracle_sid=orcl)
2> sqlplus / as sysdba ÒÔdbaµÄÉí·ÝµÇ¼
3> ²é¿´ÊµÀý״̬£º select status, instance_name from v$instance ;
......
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐУ¬Ò»°ã»á³öÏÖÈçͼ1°²×°½çÃæ£º
ͼ1
¡¡¡¡µ¥»÷“¿ªÊ¼°²×°”£¬¾Í¿ÉÒÔ°²×°ORACLE 10g£¬Ò»°ã»á¼ì²éϵͳÅäÖÃÊÇ·ñ·ûºÏÒªÇó£¬È»ºó³öÏÖ“Oracle DataBase 10g°²×°”¶Ô»°¿ò£¬Èçͼ2Ëùʾ£º
ͼ2
¡¡¡¡ÔÚ°²×°Oracle DataBase 10gʱ¿ÉÒÔÑ¡Ôñ“»ù±¾°²×°”ºÍ“¸ß¼¶°²×°”Á½ÖÖ·½·¨¡£Ñ¡Ôñ“»ù±¾°²×°”ʱ£¬“OracleÖ÷Ŀ¼λÖÔÓÃÓÚÖ¸¶¨Oracle DataBase 10gÈí¼þµÄ´æ·ÅλÖ㻓°²×°ÀàÐÍ”ÓÃÓÚÖ¸¶¨Oracle²úÆ·µÄ°²×°ÀàÐÍ(ÆóÒµ°æ¡¢±ê×¼°æºÍ¸öÈ˰æ)¡£Èç¹ûÑ¡Ôñ“´´½¨Æô¶¯Êý¾Ý¿â”£¬ÄǾÍÒªÖ¸¶¨È«¾ÖÊý¾Ý¿âÃû³ÆºÍÊý¾Ý¿âÓû§µÄ¿ÚÁî¡£
¡¡¡¡Ñ¡Ôñ“¸ß¼¶°²×°”£¬µ¥»÷“ÏÂÒ»²½”£¬»á³öÏÖ“Ö¸¶¨Îļþ¶Ô»°¿ò”£¬ÔÚԴ·¾¶ÏÔʾµÄÊǰ²×°²úÆ·ËùÔڵĴÅÅÌ·¾¶£»Ä¿±êÃû³ÆÓÃÓÚ×ʶ¨O ......
¾³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝÇ¨ÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂÇ¨ÒÆÊ§°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ÉÂÒÂë¡£ÏÖÔÚÎÒ½«oracle×Ö·û¼¯Ïà¹ØµÄһЩ֪ʶ×ö¸ö¼òµ¥×ܽᣬϣÍû¶Ô´ó¼Ò½ñºóµÄ¹¤×÷ÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØÏµ¡£ORACLE Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔºÍÆ½Ì¨¡£
¡¡¡¡Ó°ÏìoracleÊý¾Ý¿â×Ö·û¼¯×îÖØÒªµÄ²ÎÊýÊÇNLS_LANG²ÎÊý¡£ËüµÄ¸ñʽÈçÏÂ:
¡¡¡¡NLS_LANG = language_territory.charset
¡¡¡¡ËüÓÐÈý¸ö×é³É²¿·Ö(ÓïÑÔ¡¢µØÓòºÍ×Ö·û¼¯)£¬Ã¿¸ö³É·Ö¿ØÖÆÁËNLS×Ó¼¯µÄÌØÐÔ¡£ÆäÖÐ:
¡¡¡¡Language Ö¸¶¨·þÎñÆ÷ÏûÏ¢µÄÓïÑÔ£¬territory Ö¸¶¨·þÎñÆ÷µÄÈÕÆÚºÍÊý×Ö¸ñʽ£¬charset Ö¸¶¨×Ö·û¼¯¡£Èç:AMERICAN _ AMERICA. ZHS16GBK
¡¡¡¡´ÓNLS_LANGµÄ×é³ÉÎÒÃÇ¿ÉÒÔ¿´³ö£¬ÕæÕýÓ°ÏìÊý¾Ý¿â×Ö·û¼¯µÄÆäʵÊǵÚÈý²¿·Ö¡£ËùÒÔÁ½¸öÊý¾Ý¿âÖ®¼äµÄ×Ö·û¼¯Ö»ÒªµÚÈý²¿·ÖÒ»Ñù¾Í¿ÉÒÔÏ໥µ¼Èëµ¼³öÊý¾Ý£¬Ç°ÃæÓ°ÏìµÄÖ»ÊÇÌáʾÐÅÏ¢ÊÇÖÐÎÄ»¹ÊÇÓ¢ÎÄ¡£
¡¡¡¡¶þ¡ ......
Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇø·Ö²»Í¬Êý¾Ý¿âµÄ²ÎÊý¡£
Ò»¡¢Ê²Ã´ÊÇÊý¾Ý¿âÃû(db_name)?
Êý¾Ý¿âÃûÊÇÓÃÓÚÇø·ÖÊý¾ÝµÄÄÚ²¿±êʶ£¬ÊÇÒÔ¶þ½øÖÆ·½Ê½´æ´¢ÓÚÊý¾Ý¿â¿ØÖÆÎļþÖеIJÎÊý£¬ÔÚÊý¾Ý°²×°»ò´´½¨Ö®ºó½«²»µÃÐ޸ġ£Êý¾Ý¿â°²×°Íê³Éºó£¬¸Ã²ÎÊý±»Ð´ÈëÊý¾Ý¿â²ÎÊýÎļþpfileÖУ¬¸ñʽÈçÏ£º
[code:1:1aaf156970]
.........
db_name="orcl" #(²»ÔÊÐíÐÞ¸Ä)
db_domain=dbcenter.toys.com
instance_name=orcl
service_names=orcl.dbcenter.toys.com
control_file=(...............
.........
[/code:1:1aaf156970]
ÔÚÿһ¸öÔËÐеÄORACLE8iÊý¾Ý¿âÖж¼ÓÐÒ»¸öÊý¾Ý¿âÃû(db_name),Èç¹ûÒ»¸ö·þÎñÆ÷³ÌÐòÖд´½¨ÁËÁ½¸öÊý¾Ý¿â£¬ÔòÓÐÁ½¸öÊý¾Ý¿âÃû¡£Æä¿ØÖƲÎÊý¾Ý·ÖÊôÔÚ²»Í¬µÄpfileÖпØÖÆ×ÅÏà¹ØµÄÊý¾Ý¿â¡£
¶þ¡¢Ê²Ã´ÊÇÊý¾Ý¿âʵÀýÃû(instance_name)
Êý¾Ý¿âʵÀýÃûÔòÓÃÓںͲÙ×÷ϵͳ֮¼äµÄÁªÏµ£¬ ......
ÊÖ¶¯Æô¶¯Êý¾Ý¿â£º
Æô¶¯¼àÌý³ÌÐò£ºlsnrctl start
Æô¶¯Oracle·þÎñ£ºoradim -startup -sid orcl»òÕßnet start oracleserviceorcl
ÆäÖÐorclΪÊý¾Ý¿âµÄ·þÎñÃû»òÕßSID£¬oradim -startup -sid orclÕâ¸öÃüÁîÒÔǰ×Ô¼ºÃ»Óùý
ȨÏÞ¹ÜÀí£º
ϵͳȨÏÞ£º
create user zhangsan identified by zhangsan;
grant create session to lisi;
grant create table to lisi;
grant unlimited tablespace to lisi;
create table mytable (id int);
insert into mytable values(1);
select * from mytable;
select * from user_sys_privs;---²éѯµ±Ç°µÇ½Óû§µÄϵͳȨÏÞ
revoke create table from lisi;
revoke unlimited tablespace from lisi;
grant create any table to public;--ÊÚÓèËùÓÐÓû§
×¢Ò⣺grantÓëtoÊÇÅä¶ÔʹÓõ쬶ørevokeÓëfromÅä¶ÔʹÓõÄ
¶ÔÏóȨÏÞ£º
grant sel ......