Home -> Usenet -> comp.databases.oracle -> Select from a today_table_name

Select from a today_table_name

From: David <the.clansman_at_eudoramail.com>
Date: 16 Sep 2002 02:35:56 -0700
Message-ID: <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 Mon Sep 16 2002 - 11:35:56 CEST












Original text of this message