Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • To check the structure of a table

    @suresh.ramola
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 608
    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
    SQL Oracle
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: