17,377
社区成员
发帖
与我相关
我的任务
分享
INSERT /*+ APPEND*/
INTO ODS_O_SERV_USER_OCS_DAY NOLOGGING
SELECT /*+PARALLEL(T,10)USE_HASH(t,a)*/
V_MONTH ACCT_MONTH,
SUBSTR(V_DATE, 7, 2),
TO_CHAR(USER_ID),
T.CITY_CODE,
'',
'',
SERVICE_ID,
'1',
TO_CHAR(FAVOUR_ID),
DEALER_ID,
LEFT_FEE,
TO_CHAR(STATE),
TO_CHAR(MISSSTATE),
BLACKSTATE,
TO_CHAR(FIRSTRECHARGEFLAG),
TO_CHAR(FIRSTCALLFLAG),
TO_CHAR(CREDITLIMIT),
DELETETIME,
EXPIRE_DATE,
SERVICESTART,
ACCOUNTSTOP,
'',
''
FROM STAGE.BB_PPS_USER_INFO_T
/*+ APPEND*/ /*+PARALLEL(T,10)USE_HASH(t,a)*/
这两个注释必需加上么,这连个注释什么意思