| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> #prompt('p_division','string')#
iHi Gurus,
Could somebody tell me what this cmmand in sql means
In particular the command: #prompt('p_division','string')#
Regards
Nitin
(SELECT
TO_CHAR(FC1.CUSTOMER_SEGMENT_KEY) "FROM_SEGMENT",
'Individual Active Residential Accounts' "TO_SEGMENT",
COUNT( DISTINCT FC1.CUSTOMER_KEY) "MIGRATION_COUNT"
FROM
F_CUST_CONFIGURATION_SEGMENT FC1,
D_CUSTOMER DC
WHERE
FC1.REGION = # prompt('p_division','string')#
AND( FC1.START_TIME_KEY <= #prompt('P_MIG_FROM' ,'integer' )#
AND FC1.END_TIME_KEY > #prompt('P_MIG_FROM' ,'integer' )#
)
AND FC1.SEGMENT_LEVEL_1<>4
AND DC.REGION=FC1.REGION
AND FC1.CUSTOMER_SEGMENT_KEY<>999
AND DC.CUSTOMER_KEY=FC1.CUSTOMER_KEY
AND DC.CLASSIFICATION in
(#promptmany('P_CLASSIFICATION','string')#)
AND DC.ADELPHIA_SUB in (#promptmany('P_ADELPHIA_SUB','string')#)
AND nvl(DC.COURTESY_CUST_FLAG,'N') ='N'
AND DC.START_TIME_KEY<=#prompt('P_MIG_FROM' ,'integer' )#
AND DC.END_TIME_KEY>#prompt('P_MIG_FROM' ,'integer' )#
GROUP BY
FC1.CUSTOMER_SEGMENT_KEY,
'Individual Active Residential Accounts')
Received on Mon Dec 11 2006 - 07:42:04 CST
![]() |
![]() |