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

Thread: Query to find structure of a table

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 05-31-2012 #1
    amycompton
    amycompton is offline
    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.

    Reply With Quote Reply With Quote
  2. 06-11-2012 #2
    Ashish1485
    Ashish1485 is offline
    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.
    Reply With Quote Reply With Quote
  3. 01-22-2013 #3
    rayavarapu
    rayavarapu is offline
    Junior Member
    Join Date
    Jan 2013
    Answers
    9
    Query to find structure of a table

    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.
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

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.
GeekInterview
Interact