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 inReceived on Mon Dec 11 2006 - 07:42:04 CST
(#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')