一:创建分区表
create table T_PM_ACCT_DTL_AF_TEST
(
DATA_DATE NUMBER(8),
ACCT_NO VARCHAR2(100),
ACCT_ORD VARCHAR2(30),
ACCT_NO_PK VARCHAR2(100),
ACCT_BAL NUMBER(18,4),
D_CMP_BAL NUMBER(24,4),
M_CMP_BAL NUMBER(24,4),
Y_CMP_BAL NUMBER(24,4),
FLAG VARCHAR2(10),
ACCT_FLAG VARCHAR2(10),
TERM NUMBER(8),
TERM_FLAG VARCHAR2(10),
CUR_CODE VARCHAR2(8),
CUR_NAME VARCHAR2(20),
SUB_CODE VARCHAR2(50),
CUST_NO VARCHAR2(30),
CUST_TYPE VARCHAR2(10),
CUST_NAME VARCHAR2(60),
BANK_CORP_CODE VARCHAR2(10),
BRAN_NAME VARCHAR2(50),
MGR_CODE VARCHAR2(30),
MGR_NAME VARCHAR2(50),
OPEN_DATE VARCHAR2(10),
FIX_BAL NUMBER(16,2),
DIV_FIX_FLAG NUMBER(1),
ADJUST_AMT NUMBER(16,2),
ADJUST_AMT_AF NUMBER(24,4),
Y_AVG_AF NUMBER(24,4),
Y_ADD_AF NUMBER(24,4),
创建LIST分区
最新推荐文章于 2023-09-20 22:21:49 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)