Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get the field attributes from a table

Re: How to get the field attributes from a table

From: Ahmad Mabsout <amabsout_at_sprint.ca>
Date: Wed, 4 Nov 1998 21:27:09 -0800
Message-ID: <cKa02.2301$gx1.1911573@HME2.newscontent-01.sprint.ca> 






Small Keung wrote in message <71r8u1$cgb_at_eng-ser1.erg.cuhk.edu.hk>...


>As I created a table from Oracle database, how can I get the field


attributes (e.g. Field name, length, types) by SQL commands?


>


>--


>By 小強小強小小強


>上上下下左左右右...





Hi ,



The information that you requested are in the table USER_TAB_COLUMNS



Received on Wed Nov 04 1998 - 23:27:09 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US