I am trying to get (STORIES_MONTH, STORIES_YEAR, CODES AND HEADLINES) TABLES from user_tables. I am passing these table names to another procedure. The problem is I want the tables to be in specific order (stories_month, stories_year, codes and headlines).
I tried all methods I know, but could not get the table names in the desired order from the database. Is there any way I can store them some place and then retrieve them? If so, can you provide me with the query/procedure?
QUESTION POSED ON: 25 JUL 2005
QUESTION ANSWERED BY: Rudy Limeback
Try this:
order
by case when tablename='stories_month' then 0 else 1 end
, case when tablename='stories_year' then 0 else 1 end
, case when tablename='codes' then 0 else 1 end
, case when tablename='headlines' then 0 else 1 end
|
|
|
