Create virtual table.
becksSep 17 2010 — edited Sep 20 2010Hi all,
I have a table with SUBTYPE, DATAID, ORIGNALDATAID, DATE column.
select dataid, orignaldataid from table where subtype=1 and Date=01-Aug-2010.
I have the above query statment. I need the dataid for further processing, but before the processing is done. I need to check if the orignaldataid=0, if yes, dataid remains else dataid=orginaldataid. Before the list is pass to another sql. But i intend to use nested sql for futher processing, hence i need to database to crunch the data instead of using java to change the data.
I was thinking of creaating another virtaual table in DB where it will automatically do this for me instead of having dataid and orginaldatid column, it will jus have dataid column. Then i can just query this virtual table.
Select dataid from virtualTable where subtype=1 and Date=01-Aug-2010. Is it possible?