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..