Oracle question

pushVTECpushVTEC
edited April 2004 in Internet & Media
What is the command to view the columns in a given table?

Comments

  • paroxymparoxym Toronto, Canada
    edited March 2004
    DESCRIBE tablename; ?
  • GHoosdumGHoosdum Icrontian
    edited April 2004
    Yes, doing a DESC on a table will give you the names of the columns in the table, listed in order. If you want to display the tuples (rows) as well, you need to do a select: SELECT * FROM tablename;
Sign In or Register to comment.