USERENV('SESSIONID')

SELECT * FROM

FOR UPDATE OF

TRUNC(SYSDATE, 'DD')

FROM BILL_DETAIL BD, TARIFF_ITEM TI

LIKE '%'

ROWNUM <= 100

/*+ PARALLEL(D 4) */

LISTAGG(SERV_NBR, ',') WITHIN GROUP (ORDER BY SERV_NBR)

SUBSTR(CUST_CODE, 1, 10)

TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE, 'MM'), 1 - LEVEL), 'YYYYMM')

TRUNC(SYSDATE, 'MM')

TO_CHAR(PAY_TIME, 'YYYYMMDD')

TRUNC(SYSDATE, 'DD')

FROM BILL_DETAIL BD, ACCT_INFO AI

/*+ INDEX(BD IDX_BILL_DETAIL_ACCT) FULL(CI) */

ALTER SESSION SET

ALTER SESSION SET

EXEC DBMS_JOB.RUN

DBMS_JOB.RUN

EXEC DBMS_JOB.SUBMIT

DBMS_JOB.SUBMIT

AS OF TIMESTAMP

NOT IN ( SELECT

BD.ROWID

FROM ACCT_BILL B, OWE_BILL O

TRUNC(SYSDATE, 'MM')

NUMTODSINTERVAL(

TRUNC(SYSDATE, 'DD')

NVARCHAR2(

CHAR(2)

VARCHAR2(32 BYTE)

CHAR(1)

CHAR(1)

ROUND(BALANCE / 100, 2)

CHAR(2)

WITH LOCAL TIME ZONE

CHAR(2)

GENERATED ALWAYS AS IDENTITY

CHAR(2)

DEFAULT ON NULL

CHAR(2)

CHAR(2)

CHAR(2)

ORGANIZATION INDEX

CHAR(1)

NUMTOYMINTERVAL(

PARTITION BY RANGE (BILL_DATE) INTERVAL (

ORGANIZATION EXTERNAL

CHAR(1)

CHAR(1)

CHAR(1)

, PRINT_XML CLOB

INTERVAL DAY(3) TO SECOND

INTERVAL DAY(3) TO SECOND(0)

CHAR(1)

BINARY_DOUBLE

CHAR(2)

CHAR(2)

CHAR(2)

CHAR(1)

RAW(16)

CHAR(2)

SHARING = METADATA

CREATE SEQUENCE SEQ_PAY_LOG START WITH 100000001 INCREMENT BY 1 CACHE 100 ORDER

FROM SERV_INFO S, ACCT_INFO A

CREATE OR REPLACE FORCE VIEW

SUBSTR(CERT_NBR, 1, 6)

BEQUEATH CURRENT_USER

WITH CHECK OPTION

EDITIONABLE

FROM ACCT_BILL B, ACCT_INFO A

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEW

CREATE PUBLIC SYNONYM

CREATE PUBLIC SYNONYM

SELECT CYCLE_BEGIN, CYCLE_END INTO o_begin, o_end FROM BILL_CYCLE WHERE CYCLE_ID = p_month

SELECT UNIT_PRICE INTO v_price FROM PRICE_PLAN WHERE PLAN_ID = p_plan_id

TRUNC(SYSDATE, 'DD')

SUBSTR(CUST_CODE, 1, 10)

TO_NUMBER(SUBSTR(CUST_CODE, 1, 10))

START WITH CUST_ID = p_group_cust_id CONNECT BY PRIOR CUST_ID = TO_NUMBER(SUBSTR(CUST_CODE, 1, 10))

FROM ACCT_INFO A, MV_ACCT_OWE M

SELECT CREDIT_AMOUNT INTO v_credit_amt FROM CREDIT_CONTROL WHERE ACCT_ID = p_group_cust_id

TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')

FOR UPDATE OF

SELECT BALANCE, FROZEN_FEE INTO v_balance, v_frozen FROM ACCT_BALANCE WHERE ACCT_ID = p_acct_id FOR UPDATE OF BALANCE WAIT 5

RETURNING BALANCE INTO

FROM BILL_DETAIL D, ADJUST_LOG J

FOR UPDATE OF

TO_CHAR(SEQ_MSG_ID.NEXTVAL)

WHERE CURRENT OF

CRM_CUST_INFO@DBLINK_CRM

SUBSTR(p_content, 1, 1000)

FOR UPDATE OF

WHEN MATCHED THEN UPDATE SET T.BALANCE = T.BALANCE - S.FEE DELETE WHERE

TRUNC(SYSDATE, 'DD')

SELECT * FROM

FROM ACCT_BALANCE B, ACCT_INFO A

TO_CHAR(CREATE_TIME, 'YYYYMM')

TO_CHAR(CREATE_TIME, 'YYYYMM') =

LISTAGG(S.SERV_NBR, ',') WITHIN GROUP (ORDER BY S.SERV_NBR)

WM_CONCAT(S.SERV_NBR)

KEEP (DENSE_RANK

XMLSERIALIZE(

GREATEST(

EMPTY_CLOB(

FROM ACCT_BILL CUR, ACCT_BILL PREV

SELECT * FROM

FROM INVOICE_INFO I, ACCT_BILL B

SELECT * FROM

INTO ARCH_BILL_DETAIL_${archMonth}

FROM ${archTable}

ROWID

NOT IN ( SELECT

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

SELECT * FROM

FROM BILL_DETAIL BD, CUST_INFO CI

/*+ INDEX(BD IDX_BILL_DETAIL_ACCT) FULL(CI) PARALLEL(BD 4) */

FROM BILL_DETAIL BD, TARIFF_ITEM TI

TO_CHAR(BD.BILL_DATE, 'YYYYMM')

q'[集团VIP客户（免催缴）]'

FROM BILL_DETAIL BD, CUST_INFO CI

TO_DATE(:p)

SELECT * FROM

ROWNUM <= 10

ROUND(BD.FEE / 100, 2)

TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS')

TO_CHAR(SEQ_MSG_ID.NEXTVAL)

SELECT * FROM

LIKE '%'

LIKE '%'

LIKE '%'

LIKE '%'

LIKE '%'

LIKE '%'

LIKE '%'

LIKE '%'

NVL2(CONTACT_PHONE, '已登记', '未登记')

NLSSORT(

LENGTHB(

LIKE '%'

ORDER BY ${sortColumn}

LNNVL(

FROM OWE_BILL O, SERV_INFO S

FROM OWE_BILL O, CRM_CUST_MANAGER

CRM_CUST_MANAGER@DBLINK_CRM

ROUND(MONTHS_BETWEEN(SYSDATE, OWE_DATE), 1)

MONTHS_BETWEEN(SYSDATE, OWE_DATE)

TRUNC(SYSDATE, 'DD')

NEXT_DAY(TRUNC(SYSDATE, 'DD'), '星期一')

SELECT * FROM

SELECT * FROM

FROM OWE_BILL O, ACCT_INFO A

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, CREDIT_CONTROL C

FROM OWE_BILL O, ACCT_INFO A

FROM OWE_BILL O, ACCT_INFO A

TO_CHAR(SEQ_PAY_LOG.NEXTVAL)

SYS_GUID()

TO_NUMBER(:p, '999999990.99')

TO_CHAR(CHANNEL_ID)

LPAD(

NUMTODSINTERVAL(

SELECT * FROM

TO_CHAR(PAY_TIME, 'YYYYMMDD')

TO_CHAR(PAY_TIME, 'YYYYMMDD') =

TRUNC(SYSDATE, 'DD')

FROM PAY_LOG P, CHANNEL_INFO C

TRUNC(SYSDATE, 'DD')

FROM PAY_LOG P, CHANNEL_INFO C

TRUNC(SYSDATE, 'DD')

FROM PAY_LOG P, CHANNEL_INFO C

TO_CHAR(SEQ_PAY_LOG.NEXTVAL)

TO_CHAR(SEQ_PAY_LOG.NEXTVAL)

TRUNC(SYSDATE, 'DD')

TO_CHAR(P.PAY_TIME, 'YYYYMMDD')

FROM PAY_LOG P, CHANNEL_INFO C

TO_CHAR(P.PAY_TIME, 'YYYYMMDD') =

REGEXP_REPLACE(SERV_NBR, '(1[0-9]{2})[0-9]{4}([0-9]{4})', '\1****\2')

REGEXP_SUBSTR(SERV_ATTR, '[^;]+', 1, :p)

REGEXP_COUNT(

FROM TABLE(

SAMPLE (5

DBMS_RANDOM.VALUE

SYS_CONTEXT('USERENV', 'SESSION_USER')

SYSTIMESTAMP

SELECT * FROM

FROM SERV_PROD_REL R, PROD_OFFER P

INSTR(SERV_ATTR, '')

TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE, 'MM'), 1 - LEVEL), 'YYYYMM')

TRUNC(SYSDATE, 'MM')

TRUNC(BD.BILL_DATE)

INSERT ALL

FROM BILL_DETAIL BD, TARIFF_ITEM TI

PIVOT (

SELECT * FROM

FROM BILL_DETAIL BD, TARIFF_ITEM TI

TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'YYYYMM')

TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')

SELECT * FROM

TO_CHAR(STAT_DATE, 'YYYYMM')

TO_CHAR(STAT_DATE, 'YYYY') =

TO_CHAR(STAT_DATE, 'YYYYMM')

TO_CHAR(STAT_DATE, 'YYYYMM') =

FROM ACCT_BILL B, USAGE_MONTH_SUM S

TO_CHAR(STAT_DATE, 'YYYYMM')

TO_CHAR(STAT_DATE, 'YYYYMM') =

object_type_usage

trigger_correlation_reference

trigger_correlation_reference

package_var

pipelined

nested_table

varray

plsql_boolean_type

deterministic

package_init_block, package_var

pipelined

predefined_exception

trunc_call

last_day_call

to_char_call

deterministic

exception_block

result_cache

associative_array

ref_cursor

record_type

dbms_call_dbms_lob

package_var

result_cache

ref_cursor

predefined_exception

to_char_call

exception_block

oracle_clob_type

dbms_call_utl_file

goto

when_others

dynamic_sql

to_char_call

exception_block

bulk_collect

forall

associative_array

when_others

savepoint

type_anchor

trunc_call

exception_block

associative_array

when_others

predefined_exception

to_number_call

to_char_call

exception_block

savepoint

predefined_exception

raise_application_error

exception_block

bulk_collect

nested_table

when_others

exception_block

to_char_call

char_blank_padding

dbms_call_dbms_job

dbms_call_dbms_scheduler

plsql_integer_types

trunc_call

ref_cursor

dblink_usage

autonomous_transaction

when_others

exception_block

column_type_long, long_type

invisible_column

national_char_types

char_blank_padding

column_type_udt

char_blank_padding

char_blank_padding

virtual_column

char_blank_padding

timestamp_local_tz

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

column_type_long_raw, long_type

bfile_type, column_type_bfile

oracle_clob_type

interval_types

interval_leading_precision

char_blank_padding

column_type_rowid, rowid_type

binary_float_double.binary_double

char_blank_padding

char_blank_padding

char_blank_padding

char_blank_padding

raw_uuid_candidate

column_type_xmltype, xmltype

char_blank_padding

object_type_usage

editionable

trigger_correlation_reference

trigger_on_global_temp_table

trigger_correlation_reference

USERENV('SESSIONID')

SELECT * FROM

FOR UPDATE OF

FOR UPDATE OF BALANCE WAIT 5

TRUNC(SYSDATE, 'DD')

SYSDATE

FROM BILL_DETAIL BD, TARIFF_ITEM TI

||

LIKE '%'

ROWNUM <= 100

/*+ PARALLEL(D 4) */

LISTAGG(SERV_NBR, ',') WITHIN GROUP (ORDER BY SERV_NBR)

SYSDATE

SYSDATE - 3

SUBSTR(CUST_CODE, 1, 10)

TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE, 'MM'), 1 - LEVEL), 'YYYYMM')

TRUNC(SYSDATE, 'MM')

ADD_MONTHS(TRUNC(SYSDATE, 'MM'), 1 - LEVEL)

SYSDATE

TO_CHAR(PAY_TIME, 'YYYYMMDD')

TRUNC(SYSDATE, 'DD')

SYSDATE

MINUS

FROM BILL_DETAIL BD, ACCT_INFO AI

/*+ INDEX(BD IDX_BILL_DETAIL_ACCT) FULL(CI) */

ALTER SESSION SET

ALTER SESSION SET

EXEC DBMS_JOB.RUN

DBMS_JOB.RUN

EXEC DBMS_JOB.SUBMIT

DBMS_JOB.SUBMIT

AS OF TIMESTAMP

NOT IN ( SELECT

BD.ROWID

FROM ACCT_BILL B, OWE_BILL O

FOR UPDATE WAIT 3

TRUNC(SYSDATE, 'MM')

SYSDATE

NUMTODSINTERVAL(

TRUNC(SYSDATE, 'DD')

SYSDATE

CHAR(2)

CHAR(1)

SYSDATE

CHAR(1)

ROUND(BALANCE / 100, 2)

SYSDATE

CHAR(2)

SYSDATE

CHAR(2)

GENERATED ALWAYS AS IDENTITY

CHAR(2)

DEFAULT ON NULL

CHAR(2)

CHAR(2)

CHAR(2)

ORGANIZATION INDEX

CHAR(1)

NUMTOYMINTERVAL(

PARTITION BY RANGE (BILL_DATE) INTERVAL (

ORGANIZATION EXTERNAL

CHAR(1)

SYSDATE

CHAR(1)

CHAR(1)

CHAR(1)

SYSDATE

CHAR(2)

CHAR(2)

CHAR(2)

CHAR(1)

CHAR(2)

SHARING = METADATA

SYSDATE

CREATE GLOBAL TEMPORARY TABLE

CREATE SEQUENCE SEQ_PAY_LOG START WITH 100000001 INCREMENT BY 1 CACHE 100 ORDER

FROM SERV_INFO S, ACCT_INFO A

CREATE OR REPLACE FORCE VIEW

SUBSTR(CERT_NBR, 1, 6)

||

BEQUEATH CURRENT_USER

WITH CHECK OPTION

EDITIONABLE

FROM ACCT_BILL B, ACCT_INFO A

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEW

CREATE PUBLIC SYNONYM

CREATE PUBLIC SYNONYM

SYSDATE

||

TRUNC(SYSDATE, 'DD')

SYSDATE