Oracle Query Help
What is the query to get all the table and column name from a database.
Thanks in advance
SELECT owner, table_name, column_name
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.
Please help me
How to query to get the specific values at the top?
If i queried to get the alphabetic order values and it resulted in like..
I need a query to bring Saraswati and Yamuna in front.. like..
Is it possible?? Thanks in advance!!
This post is completely unrelated to the other post. 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;
Originally Posted by PradeepSmile
this space intentionally left blank
Not to mention post was almost five years old! another government run project perhaps?
Originally Posted by gandolf989
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width