Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Unanswered: oracle query help

    Hi Guys,

    What is the query to get all the table and column name from a database.

    Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    select table_name,column_name
    from all_tab_columns
    order by table_name,column_id

    This query will print out the column names in the order that they are in the table.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Sep 2003
    Posts
    19
    Thank you so much...it worked like a charm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •