Home -> Usenet -> comp.databases.oracle -> SQL*Plus newbie questions

SQL*Plus newbie questions

From: Steve Chell <slc_at_stevensons.co.nz>
Date: 1996/01/22
Message-ID: <4dv0n0$52b_at_news.nznet.gen.nz>#1/1 






Hi all.  I come from an Informix background, and I'm currently
trying to get to grips with Oracle, in particular SQL*Plus.



Any help with the following would be appreciated.



    
  
  1.   Once connected to the database via SQL*Plus, how do you list
   the tables.  (Informix equivalent: info tables)

  
  2.   Are there any system catalog tables which hold info about
   the tables, columns, etc in the database.

    
   (Informix equivalent: systables, syscolumns, etc)

    

  
  3.   How do you determine the number of tables in the database.

    
   (Informix equivalent:

    
   select count(*) from systables where tabtype = "T")

  
  4.   How do you list the columns in a table.

    
       (Informix equivalent: info columns for tablename)

    






Thanks very much.
Received on Mon Jan 22 1996 - 00:00:00 CET












Original text of this message