Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle Application Express µÄ°²×°

°²×°Ç°µÄ×¼±¸£º
      µÇ¼ϵͳ£ºsqlplus system/0621
1.   ´ÓÊý¾Ý×Öµäv$instanceÖлñÈ¡Êý¾Ý¿âµÄʵÀýÃûºÍ°æ±¾ºÅ£ºselect instance_name,version from v$instance;
2.   ´ÓÊý¾Ý×Öµäv$versionÖлñÈ¡°æ±¾µÄÏêϸÐÅÏ¢£ºselect * from v$version;
3.È·ÈÏoracleËùʹÓõIJÎÊýÎļþÊÇ·ñΪ¶þ½øÖƵIJÎÊýÎļþ£¨spfile±íÃ÷Ϊ¶þ½øÖÆÎļþ£©£ºshow parameter pfile        
4. È·ÈÏoracleÊÇ·ñʹÓõÄÊÇ×Ô¶¯ÄÚ´æ¹ÜÀí£ºshow parameter memory_target
5. ²é¿´±í¿Õ¼äÊÇ·ñΪ×Ô¶¯À©Õ¹£ºselect tablespace_name, autoextensible from dba_data_file;
 
 
ʹÓÃǶÈëʽPL/SQLÍø¹Ø£¨Ò²³ÆÁ¬½ÓÆ÷£¬Gateway£©°²×°ºÍÅäÖÃOracle Application ExpressµÄ¾ßÌå²½ÖèÈçÏ£º
1.       °²×°Oracle Application Express.
2.       ÐÞ¸ÄAdminÕÊ»§ÃÜÂë
3.       ÅäÖÃǶÈëʽPL/SQLÍø¹Ø¡£
4.       ºËʵºÍ¿ªÆôOracle XML DB HTTP·þÎñÆ÷µÄ¶Ë¿Ú¡£
5.       ¿ªÆôOracle 11gÊý¾Ý¿âÖеÄÍøÂç·þÎñ¡£
6.       °²×°ÆäËûÓïÑÔ¡£
7.       ÉèÖÃJOB_QUERY_PROCESS²ÎÊý¡£
8.       ÅäÖÃSHARED_SERVER²ÎÊý¡£
 
1.     °²×°Oracle Application Express
l  F:cd app/apex
l  Sqlplus /nolog
l  Connect sys/0621 as sysdba
l  @apexins sysaux sysaux temp /i/
ÔËÐа²×°½Å±¾apexins.sqlÎļþ£¬½øÐÐÈ«²¿¿ª·¢»·¾³µÄ°²×°¡£Á½¸ösysaux±íʾExpressµÄÊý¾ÝºÍÓû§ÐÅÏ¢¶¼½«´æ·ÅÔÚsysaux±í¿Õ¼äÖУ»TempΪÅÅÐòËùʹÓõıí¿Õ¼ä£»/i/±íʾExpressÖдæ·ÅͼÏñµÄÐéÄâĿ¼¡£
µ±³É¹¦°²×°oracle application expressÖ®ºó£¬express»áÔÚoracle 11gÊý¾Ý¿ÞÖд´½¨ÈçÏÂ3¸öеÄÕË»§£¨Óû§£©¡£
Ø  APEX_030200:¸ÃÕË»§ÓµÓÐoracle application expressģʽºÍÔªÊý¾Ý¡£
Ø  FLOWS_FILES:¸ÃÕË»§ÓµÓÐoracle application expressÉÏ´«µÄÎļþ
Ø  APEX_PUBLIC_USERS:¸ÃÕË»§Ö»ÓµÓÐÅäÖÃoracle http ·þÎñÆ÷ºÍmod_plsqlÍø¹ØµÄoracle application expressµÄ×îСȨÏÞ¡£
´ÓÊý¾Ý×ÖµäDBA_USERS


Ïà¹ØÎĵµ£º

¸ü¸ÄOracleÊý¾Ý¿â±íµÄ±í¿Õ¼ä

ÔÚOracleÊý¾Ý¿â¹ÜÀíϵͳÖУ¬´´½¨¿â±í£¨table£©Ê±Òª·ÖÅäÒ»¸ö±í¿Õ¼ä£¨tablespace£©£¬Èç¹ûδָ¶¨±í¿Õ¼ä£¬ÔòʹÓÃϵͳÓû§È·Ê¡µÄ±í¿Õ¼ä¡£
ÔÚOracleʵ¼ÊÓ¦ÓÃÖУ¬ÎÒÃÇ¿ÉÄÜ»áÓöµ½ÕâÑùµÄÎÊÌâ¡£´¦ÓÚÐÔÄÜ»òÕ߯äËû·½ÃæµÄ¿¼ÂÇ£¬ÐèÒª¸Ä±äij¸ö±í»òÕßÊÇij¸öÓû§µÄËùÓбíµÄ±í¿Õ¼ä¡£Í¨³£µÄ×ö·¨¾ÍÊÇÊ×ÏȽ«±íɾ³ý£¬È»ºóÖØÐ½¨±í£¬ÔÚн¨±íʱ½«± ......

¿ªÊ¼Ê¹ÓÃoracle ³ÂţѧIT

1£¬oracle tools£ºOUI¡¢DBCA¡¢OEM¡¢SQL*PLUS¡¢NETCA¡¢µÚÈý·½¹¤¾ß£¨toad¡¢PL\SQL developer£©
2£¬¿ÉʹÓÃresponsefile¿ìËÙȥͼÐΰ²×°oracle£¬ÔÚÔ´°²×°Îļþ/responseÀïÃæÓÐһЩģ°åÅäÖÃrpsÎļþ
3£¬Ô¤ÖÃÓû§ÊÇsysÓû§ÓësystemÓû§£ºsysÊÇoracleÊý¾Ý¿â
ÖÐȨÏÞ×î¸ßµÄÕʺţ¬¾ßÓÐcreate
databaseµÄȨÏÞ£¬¶øsystemûÓÐÕâ¸öȨÏÞ£ ......

.netÔÚweb.configÖÐÁ¬½ÓoracleÊý¾Ý¿â

1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
   <add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......

oracleÖе÷Óôø²ÎÊýµÄ´æ´¢¹ý³Ì

create or replace procedure proc_test
( a in number, b out number )
as
begin
b:=a+1;
end    proc_test;
ÏÖÔÚÒªµ÷Óõϰ¾ÍÊÇÕâÑù
SQL> c number;
SQL>exec proc_test(1,:c);
ǧÍòҪעÒâ±ðÍüÁËдðºÅ ......

oracle´ø²ÎÊýÓαêµÄʹÓÃ


¡¡¡¡´ÓÓαêÌáÈ¡Êý¾Ý
¡¡¡¡´ÓÓαêµÃµ½Ò»ÐÐÊý¾ÝʹÓÃFETCHÃüÁÿһ´ÎÌáÈ¡Êý¾Ýºó£¬Óα궼ָÏò½á¹û¼¯µÄÏÂÒ»ÐС£Óï·¨ÈçÏ£º
FETCH cursor_name INTO variable[,variable,...]
¡¡¡¡¶ÔÓÚSELECT¶¨ÒåµÄÓαêµÄÿһÁУ¬FETCH±äÁ¿ÁÐ±í¶¼Ó¦¸ÃÓÐÒ»¸ö±äÁ¿ÓëÖ®Ïà¶ÔÓ¦£¬±äÁ¿µÄÀàÐÍÒ²ÒªÏàͬ¡£
¡¡¡¡Àý£º
SET SERVERIUTPUT ON
DECLARE
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ