Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • To check the structure of a table

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 239
    Comment on it

    DESCRIBE Statement:

    It is used to view the structure of a table means it shows name and data type of columns.

    Syntax 1:

    DESC tablename;
    

    Syntax 2:

    DESCRIBE tablename;
    

    Example:

    DESC Employee;
    

    Column Datatype
    ---------- -------------
    Name varchar2
    Address varchar2
    Salary Number
    Dept varchar2

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: