Can you plese help me translate a simple DB2 queries to Oracle 10G.
with allhours (hh) as (values(0),(1),(2),(3),(4),(5))
I need to write a database setup check routine. I will specify the objects in the values.. and join it to user_objects table to check successfull setup of build
with allhours (hh) as (select rownum-1 from all_objects where rownum <= 6)
Actually this is not what I am looking for. Let me rephrase my question.
with AllColors (Color) as (values('Red'),('Blue'),('Green'),('Purple'),('Yel low'))
You actually want to check the existence of particular database objects? Tony just used ALL_OBJECTS as a simple way of generating some rows from SQL. If you want to check those objects against a list, try an outer join.