title: How can I pass a parameter to a t-sql script?
body: <pre><code>CREATE TABLE DMS_POP_WKLY_REFRESH_20100201 NOLOGGING PARALLEL AS
  SELECT wk.*,bbc.distance_km ,NVL(bbc.tactical_broadband_offer,0) tactical_broadband_offer ,
         sel.tactical_select_executive_flag,
         sel.agent_name,
         res.DMS_RESIGN_CAMPAIGN_CODE,
         pclub.tactical_select_flag
  FROM   spineowner.pop_wkly_refresh_20100201 wk,
         dms_bb_coverage_102009 bbc,
         dms_select_executive_group sel,
         DMS_RESIGN_CAMPAIGN_26052009 res,
         DMS_PRIORITY_CLUB pclub
  WHERE  wk.mpn = bbc.mpn(+)
  AND    wk.mpn = sel.mpn (+)
  AND    wk.mpn = res.mpn (+)
  AND    wk.mpn = pclub.mpn (+)
  </code></pre>
  <p>vijay.sql  ( name given to above sql script)</p>
  <p>How can I pass a parameter for 20100201 in side the sql script? I need to change every time this date format.</p>
  <p>How can I call this sql script and run it in unix by passing date as parameter? So that date in the script should be modified in every run.</p>