Just a hint: If you need temporary tables, this is usually an indicator
that something is terribly wrong with either the database or the way you
want to use the database. Usually, you can use a view or a simple
select, if that way has performance issues, think about indexes and in
really hard cases some low-level database tuning (i.e. ask your local DB
admin or some Oracle consultant).
Alexander
Ready, Mike wrote:
Hi
Is there a way to use a bind variable to pass a tablename into an oracle
create table statement - e.g.
CREATE TABLE ?
(
CASE_NUM NUMBER,
TLM_PROG VARCHAR2(50 BYTE),
TLM_REASON VARCHAR2(100 BYTE),
TLM_CREATE_DT DATE,
TLM_TASK_NAME VARCHAR2(50 BYTE),
TLM_ACTION VARCHAR2(50 BYTE)
)
where ? gets replaced with a bind variable holding a temp table name
that contains the date? I can do it by substituting the date into the
sql string or by concatenating the tablename with a couple of strings to
create the sql statement, but it seems cheesy. If I try to do it using
a bind variable, it errors out.
Thanks
Mike R.
Michael P. Ready
Texas ACCESS Alliance
Work 512-533-3959, Mobile 512-796-7085, Fax 512-437-6532
AIM: michaelpready
[EMAIL PROTECTED]
--
Alexander Foken
mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
