Re: Select from a today_table_name

If you just need to cron the task, then you don't need to have it in stored procedure. For example, you can just create a file say "cron_sel_call":

# load your .profile here (set ENV)
# this line will run the script Mon through Fri at 8am: 0 8 * * 1-5 sqlplus user/pass_at_sid @/oracle/sel_call.sql

Then at unix prompt run

crontab cron_sel_call

You are all set.

HTH Guang

the.clansman_at_eudoramail.com (David) wrote in message news:<95e48c3a.0209180605.52748e77_at_posting.google.com>...
> I need to make it in a stored procedure to task in the cron after
>
> the.clansman_at_eudoramail.com (David) wrote in message news:<95e48c3a.0209160135.5caa7bb3_at_posting.google.com>...
> > How have I to do to make a Select from a tabla that its name is today
> > date. I need to put this in a stored procedure.
> >
> > It's not possible to use a function in from.
> > SELECT 'TABLE_' || TO_CHAR(SYSDATE,'YYYYMMDD') into cot From DUAL
Received on Wed Sep 18 2002 - 20:39:55 CEST