Oracle 查Table 大小,筆數
SELECT OWNER,TABLE_NAME,NUM_ROWS,BLOCKS,BLOCKS*8096 as blockusebyte,AVG_ROW_LEN,AVG_ROW_LEN*NUM_ROWS as rowusebyte
FROM all_tables
WHERE owner<>'SYS' and owner<>'SYSTEM'
AND blocks is not null
ORDER BY NUM_ROWS DESC
Oracle 查Table 大小,筆數
SELECT OWNER,TABLE_NAME,NUM_ROWS,BLOCKS,BLOCKS*8096 as blockusebyte,AVG_ROW_LEN,AVG_ROW_LEN*NUM_ROWS as rowusebyte
FROM all_tables
WHERE owner<>'SYS' and owner<>'SYSTEM'
AND blocks is not null
ORDER BY NUM_ROWS DESC
--- 提交處理事務處理介面請求
l_request_id := FND_REQUEST.SUBMIT_REQUEST(
APPLICATION => 'INV',
PROGRAM => 'INCTCM'
);
http://www.itpub.net/563014.html
一、PL/SQL部分
1、(中文) oracle sql function.ppt 3 楼
2、(中文) PLSQL程序设计.pdf 4-11楼
3、(中文) oracle_sql性能优化.doc 12楼
1. oncontextmenu="window.event.returnValue=false" 將徹底遮罩滑鼠右鍵
<table border oncontextmenu=return(false)><td>no</table> 可用於Table
2. <body onselectstart="return false"> 取消選取、防止複製
3. onpaste="return false" 不准粘貼
4. oncopy="return false;" oncut="return false;" 防止複製
1.增加主鍵
alter table TABLE_NAME add constraint KEY_NAME primary key (TABLE_COLUMN);
指定表空間
alter table TABLE_NAME add constraint KEY_NAME primary key (TABLE_COLUMN) using index tablespace TABLE_SPACE_NAME;
2.增加外鍵
SELECT
/*+ INDEX(
rsh rcv_shipment_headers,
rsl rcv_shipment_lines,
ph po_headers_all,
其他字典表
表名:apps.fnd_user
說明:MRPII用戶表
USER_ID NUMBER 用戶ID
USER_NAME VARCHAR2 用戶名稱
WIP模組常用表結構
表名: wip.wip_accounting_classes
說明: 離散作業會計科目
CLASS_CODE VARCHAR2(10) 帳目
ORGANIZATION_ID NUMBER 組織代碼
OE模組常用表結構
so_headers_all;so_lines_all;
表名:ONT.OE_order_headers_all
說明:訂單頭
HEADER_ID NUMBER 訂單頭標識碼
--列出所有應用模組對應的ID
SELECT
appview.APPLICATION_ID
,appview.APPLICATION_SHORT_NAME
,appview.APPLICATION_NAME
Order Import
METALINK : Note 746650.1 : Order Import Functionality In Order Management
insert into
OE_HEADERS_IFACE_ALL
(Operation_Code, --Operation_Code:'INSERT' ,'UPDATE','DELETE'
1. 新增帳號: CREATE USER 使用者名稱 IDENTIFIED BY 密碼;
2. 權限設定: GRANT 權限 ON 資料庫物件 TO 使用者名稱;
GRANT 角色 TO 使用者名稱
3. 取消權限: REVOKE 權限 ON 資料庫物件 FROM 使用者名稱;
4. 新增角色: CREATE ROLE 角色名稱 [ NOT IDENTIFIED | IDENTIFIED { BY 密碼 | USING [ 鋼要 .] PACKAGE | EXTERNALLY | GLOBALLY } ] ;