select from dynamic table names
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..
--
*Thanks and Regards,*
Dinesh Kumara,
Software Engineer,
Reservation Gateway Inc,
Email:dinesh@rezgateway.com <mailto:dinesh@rezgateway.com>
www.rezgateway.com
Attachments:
Hello
2011/11/8 Dinesh Kumara <dinesh@rezgateway.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
Show quoted text
--
*Thanks and Regards,*
Dinesh Kumara,
Software Engineer,
Reservation Gateway Inc,
Email:dinesh@rezgateway.com
www.rezgateway.com