Hi Guys,
What is the query to get all the table and column name from a database.
Thanks in advance
Printable View
Hi Guys,
What is the query to get all the table and column name from a database.
Thanks in advance
SELECT owner, table_name, column_name
FROM all_tab_columns
ORDER BY owner, table_name, column_id;
thanks...it worked like a charm
No problem. You should become familiar with DICT. You can use this to find sys tables and views. You might also want to try to get a data dictionary poster.
How to query to get the specific values at the top?
Eg..
If i queried to get the alphabetic order values and it resulted in like..
Alien
Brama
Ganga
Saraswati
Yamuna
I need a query to bring Saraswati and Yamuna in front.. like..
Saraswati
Yamuna
Alien
Brama
Ganga
Is it possible?? Thanks in advance!!
This post is completely unrelated to the other post. :confused: You should have created a new post for your question.
If you want certain name to sort to the top you need another column to sell Oracle to sort certain items higher.
Like if you had a priority column along with the name column where a lower number means that it should be listed higher in the results then you could do this:
select name from table where ... ... order by priority, name;