Re: select from dynamic table names

Hello

2011/11/8 Dinesh Kumara <dinesh(at)rezgateway(dot)com>

> **
> I have 16 tables which created according to generated MD5 hash.
> At the time of execution i tried to retrieve data from a table where table
> name id dynamic.
>
> table name can be expertdb.rate_AVAIL_[0 to F]
>
> I tried to get this from ;
> SELECT * FROM expertdb.rate_AVAIL_ ||
> upper(substring(md5('2011-11-10')from 1 for 1))
>
> but it is giving an error that is error with '||' appender. please someone
> give me an idea..
>

you can't do it on SQL level - column and table names must be constant

Regards

Pavel Stehule

>
> --
>
> *Thanks and Regards,*
> Dinesh Kumara,
> Software Engineer,
> Reservation Gateway Inc,
> Email:dinesh(at)rezgateway(dot)com
> www.rezgateway.com
>