Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: column names and types

    hi!

    how do i find the column names and datatypes of a table in oracle - in MS SQL Server it's the sysobjects table!

    thanks!!

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: column names and types

    Originally posted by dgarvan1
    hi!

    how do i find the column names and datatypes of a table in oracle - in MS SQL Server it's the sysobjects table!

    thanks!!
    query user_tab_columns

    rgds

  3. #3
    Join Date
    Nov 2003
    Posts
    4

    Re: column names and types

    great, thanks for the quick reply!

  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    simply,

    DESC tablename ( if you r using sqlplus)
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  5. #5
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,


    DESC <tbale_name>;
    SATHISH .

Posting Permissions

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