Page 2 of 2 FirstFirst 12
Results 21 to 24 of 24

Thread: Query to find structure of a table

  1. #21
    Junior Member
    Join Date
    May 2012
    Answers
    18

    Re: Query to find structure of a table

    DESC BOOk_NAME;

    eg:

    DESC BOOK;

    BOOK is name of table.


  2. #22
    Junior Member
    Join Date
    Jun 2012
    Answers
    1

    Re: Query to find structure of a table

    Sp_help is for SQL server
    DESC is for ORACLE DB

    Last edited by admin; 11-05-2012 at 12:27 AM.

  3. #23
    Junior Member
    Join Date
    Jun 2012
    Answers
    2

    Post Re: Query to find structure of a table

    you can try it by Double click on the data element(data type) of this field and click where
    used list icon on the toolbar to find the table which used this data
    element.
    I hope it will help you


  4. #24
    Junior Member
    Join Date
    Jan 2013
    Answers
    9

    Re: Query to find structure of a table

    Select column_name, data_type, data_length, data_precision, data_scale from ALL_TAB_COLUMNS
    where table_name = 'EMP';
    or
    desc emp;

    Last edited by admin; 01-22-2013 at 07:07 AM.

  5.  Sponsored Ads
    Ad


     
Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact