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Êý¾Ý¿â¹ÜÀíϵͳÖУ¬´´½¨¿â±í£¨table£©Ê±Òª·ÖÅäÒ»¸ö±í¿Õ¼ä£¨tablespace£©£¬Èç¹ûδָ¶¨±í¿Õ¼ä£¬ÔòʹÓÃϵͳÓû§È·Ê¡µÄ±í¿Õ¼ä¡£
ÔÚOracleʵ¼ÊÓ¦ÓÃÖУ¬ÎÒÃÇ¿ÉÄÜ»áÓöµ½ÕâÑùµÄÎÊÌâ¡£´¦ÓÚÐÔÄÜ»òÕ߯äËû·½ÃæµÄ¿¼ÂÇ£¬ÐèÒª¸Ä±äij¸ö±í»òÕßÊÇij¸öÓû§µÄËùÓбíµÄ±í¿Õ¼ä¡£Í¨³£µÄ×ö·¨¾ÍÊÇÊ×ÏȽ«±íɾ³ý£¬È»ºóÖØÐ½¨±í£¬ÔÚн¨±íʱ½«± ......
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ûÓÐÕâ¸öȨÏÞ£ ......
1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......
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);
ǧÍòҪעÒâ±ðÍüÁËдðºÅ ......
¡¡¡¡´ÓÓαêÌáÈ¡Êý¾Ý
¡¡¡¡´ÓÓαêµÃµ½Ò»ÐÐÊý¾ÝʹÓÃFETCHÃüÁÿһ´ÎÌáÈ¡Êý¾Ýºó£¬Óα궼ָÏò½á¹û¼¯µÄÏÂÒ»ÐС£Óï·¨ÈçÏ£º
FETCH cursor_name INTO variable[,variable,...]
¡¡¡¡¶ÔÓÚSELECT¶¨ÒåµÄÓαêµÄÿһÁУ¬FETCH±äÁ¿ÁÐ±í¶¼Ó¦¸ÃÓÐÒ»¸ö±äÁ¿ÓëÖ®Ïà¶ÔÓ¦£¬±äÁ¿µÄÀàÐÍÒ²ÒªÏàͬ¡£
¡¡¡¡Àý£º
SET SERVERIUTPUT ON
DECLARE
......