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 -> concatenate table alias w parameter in

concatenate table alias w parameter in

From: <drdave_at_canoemail.com>
Date: Wed, 13 Jun 2007 12:11:02 -0700
Message-ID: <1181761862.766335.147940@o11g2000prd.googlegroups.com>


How can I combine the two or can I??

trying to combine table alias w. and parameter in p_column_in in the last AND

(p_column_in IN VARCHAR2,

p_location_id IN VARCHAR2,
p_industry_id IN VARCHAR2,
p_from_current_year IN NUMBER,
p_to_current_year IN NUMBER,
p_reporting_type IN NUMBER)

return NUMBER is SearchTotal Number;

BEGIN SELECT COUNT(current_year) AS RecordCount INTO SearchTotal FROM cpws_work_stoppage w, cpws_location l, cpws_industry i WHERE w.location_id IN (p_location_id)

AND w.location_id = l.location_id
AND w.industry_id IN (p_industry_id)
AND w.industry_id = i.industry_id
AND w.current_year BETWEEN p_from_current_year  AND
p_to_current_year
AND w.reporting_type_id = p_reporting_type

AND w. || p_column_in is null;

RETURN SearchTotal;

END; Received on Wed Jun 13 2007 - 14:11:02 CDT

Original text of this message

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