Oracle Form開發(4)
ÉÏ節學習開µÚÒ»個Form£¬這個節ÔÚÌí¼ÓÒ»個彈³öÏÂÀ¿ò
µÚÒ»²½£ºÌí¼Ó記錄組
1.1 選ÖÐRecord Groups
1.2 單擊Create
1.3 輸Èë²é詢SQL
1.4 單擊OK
1.5 ÐÞ¸Ä剛²Å創½¨µÄRecord Groups為VENDORRG
µÚ¶þ²½:Ìí¼ÓLOVs
2.1選ÖÐLOVs
2.2單擊Create
2.3選擇Build a new LOV manually£¬單擊OK
2.4¸ÄÐÞLOVs為VENDOR_LOV
2.5 ´ò開VENDOR_LOVµÄÌØÕ÷盤(Palette),Title輸È빩應ÉÌ£¬選擇Record Group為VENDORRG
2.6單擊Column Mapping Properties£¬顯ʾLOV Column Mapping´°¿Ú£¬ÔÚColumn NamesÏÂÀ¿òÖÐ輸ÈëÁÐÃûVENDOR_CODE£¨´ËÁÐÃû與ÉÏÃæRecord Group為VENDORRGÖеÄSQL Select語¾ä×Ö¶ÎÒ»樣£©£¬Return Item選擇·µ»Ø給數據塊HHRALANTESTÖÐ項Ä¿VENDOR_CODE£¬Display WidthÊÇ顯ʾÁÐ寬,Column TitleÊÇ顯ʾÁÐÃû¡£
Èç¹û²»Ðè·µ»Ø給ij項Ä¿£¬Return Item為¿Õ¡£µ«ÊÇ£¬Display WindowºÍColumn TitleÊÇÒ»¶¨Òª輸Èë¡£
Ïà¹ØÎĵµ£º
oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º
Code
create [or replace] procedure procedure_name
[(argument[{in|out|in out}] type,
argument[{in|out|in out}] type)]&n ......
½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
1.HKEY_LOCAL_MACHINE
HKEY_LOCAL_MACHINE
SOFTWARE
ORACLE
2.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services
3.ÖØÐÂÆô¶¯»úÆ÷.
create role a identified by passwor ......
³ö´¦£ºhttp://hi.baidu.com/vcy168/blog/item/877945d908c3d52611df9ba0.html
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
ORACLE sql µÄ´¦Àí¹ý³Ì´óÖÂÈçÏ£º
1.ÔËÓÃHASHËã·¨£¬µÃµ½Ò»¸öHASHÖµ£¬Õâ¸öÖµ¿ÉÒÔͨ¹ýV$SQLAREA.HASH_VALUE ²é¿´
2.µ½shared pool ÖÐµÄ library cache ÖвéÕÒÊÇ·ñÓÐÏàͬµÄHASHÖµ£¬Èç¹û´æÔÚ£¬ÔòÎÞÐèÓ²½âÎö£¬½øÐÐÈí½âÎö
3.Èç¹ûshared pool²»´æÔÚ´ËHASHÖµ£¬Ôò½øÐÐÓï·¨¼ì²é£¬²é¿´ÊÇ·ñÓÐÓï·¨´íÎó
&nbs ......