Show the table structure : Describe « Table « Oracle PL / SQL

Home
Oracle PL / SQL
1.Aggregate Functions
2.Analytical Functions
3.Char Functions
4.Constraints
5.Conversion Functions
6.Cursor
7.Data Type
8.Date Timezone
9.Hierarchical Query
10.Index
11.Insert Delete Update
12.Large Objects
13.Numeric Math Functions
14.Object Oriented Database
15.PL SQL
16.Regular Expressions
17.Report Column Page
18.Result Set
19.Select Query
20.Sequence
21.SQL Plus
22.Stored Procedure Function
23.Subquery
24.System Packages
25.System Tables Views
26.Table
27.Table Joins
28.Trigger
29.User Previliege
30.View
31.XML
Oracle PL / SQL » Table » Describe 
Show the table structure
 

SQL>
SQL> create table employee_history employee_id      number(6not null,
  2                                  salary           number(8,2),
  3                                  hire_date        date default sysdate,
  4                                  termination_date date,
  5                                  termination_desc varchar2(4000),
  6                                  constraint       emphistory_pk
  7                                  primary key (employee_id, hire_date)
  8                                );

Table created.

SQL> describe employee_history;
 Name                                        Null?    Type
 ------------------------------------------- -------- -------------

 EMPLOYEE_ID                                 NOT NULL NUMBER(6)
 SALARY                                       NUMBER(8,2)
 HIRE_DATE                                   NOT NULL DATE
 TERMINATION_DATE                             DATE
 TERMINATION_DESC                             VARCHAR2(4000)

SQL>
SQL> drop table employee_history;

           
         
  
Related examples in the same category
1.describe user_tables
2.describe a procedure
3.Check the view structure
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.