Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> #prompt('p_division','string')#

#prompt('p_division','string')#

From: Nitin <nitinwork_at_gmail.com>
Date: 11 Dec 2006 05:42:04 -0800
Message-ID: <1165844524.614883.246510@79g2000cws.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US