Oracle Purchasing²»Äܲ鿴POºÍ開PO
Oracle Purchasing²»Äܲ鿴PO»ò開PO,並ÇÒÓÃ戶ÓÐ權ÏÞ開PO¡£這樣Çé況¿ÉÄÜÓв»ÉÙͬÈÊÒ²ÓöÉÏ類ËÆ問題¡£¾ß體Çé況ÈçÏÂ圖:
Ê×ÏÈ,²é¿´ÓÃ戶ÊDz»ÊÇ採購員,ÐèÒªÔÚOracle PurchasingÌí¼Ó採購員,ÈçÏÂ圖:
µ«ÊÇ£¬ÓÐ時´ËÓÃ戶ÊÇ採購員£¬還ÊÇÓÐÉÏÃæÌáʾÐÅÏ¢£¬Ôõ麼»ØÊ£¿
ÔٴΣ¬ÎÒ們ÐèÒªÓÐÓÃ戶¶¨義µÄ權ÏÞ£¬²é¿´ÓÃ戶´°體ÖеÄÈË員ÓÐ沒ÓÐ與FAUSERÏà關聯£¬這種Çé況ÊÇÎÒ們×îÈÝÒ׺öÂԵġ£
設ÖÃÍêáᣬÖػض¨Î»µ½Oracle Purchasing¾Í¿ÉÒԲ鿴POºÍ開POÁË.
Ïà¹ØÎĵµ£º
--´´½¨Óû§
create user iagent identified by ia
--profile default
default tablespace users
temporary tablespace temp;
--account unlock;
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
alter user iagent identified by ia;
--¸ø´´½¨µ ......
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç ......
¾³£ÓÃoracleµÄÈ˶ÔÏÂÃæµÄÕâÌõÐÅÏ¢¿Ï¶¨²»»áÄ°Éú£º“¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ´½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ”¡£Æäʵ²úÉúÕâ¸öÎÊÌâµÄ¸ù±¾ÔÒò²»ÊǼàÌýûÓÐÆðÀ´£¬¶øÊǼàÌýûÓмàÌýÄãÒªÁ¬½ÓµÄoracleʵÀý¡£
´ó¼Ò¶¼Ã÷°×£¬oracleÖ»ÓÐÁ½Õ߼汸²ÅÄÜÏòÍâ½çÌṩ·þÎñ£ºÒ»¸öÊǼàÌý£¬ÓÃÓÚ½Ó ......
select owner,sum(bytes)/1024/1024 sum_MB
from dba_segments
where tablespace_name='USERS' and owner like 'ZJ%'
group by owner
order by 2 desc;
SET NEWPAGE NONE HEADING OFF SPACE 0 PAGESIZE 0 TRIMOUT ON TRIMSPOOL ON LINESIZE 25 ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶Î:
......