title: How to get the values from dummy table to variables?
body: <pre><code>(SELECT SUBSTRING(TO_CHAR(current_timestamp, 'yyyy-mm-dd hh12:mi:ss AM'),21,2)),
                              current_date ,
                              current_date - INTERVAL '1' DAYS, 
                              to_char(current_date,'Day') into 
                              vs_current_ampm,
                              vd_current_dt,
                              vd_prev_dt, 
                              vl_day;
  </code></pre>