Oracle SQL - Write SQL to display table structures

  1. HOME
  2. Oracle SQL
  3. Table
  4. CREATE TABLE Command

Requirements

Here is the table

Demo

SQL>
SQL> drop table NEWSPAPER;
SQL> create table NEWSPAPER (
  2        Feature      VARCHAR2(15) not null,
  3        Section      CHAR(1),-- from  w w  w  .j  a v a2 s .com
  4        Page         NUMBER
  5  );
SQL>

Write SQL to display table structures

Demo

SQL>
SQL> describe NEWSPAPER-- w w w. ja v  a 2  s.co m
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FEATURE                                   NOT NULL VARCHAR2(15)
 SECTION                                            CHAR(1)
 PAGE                                               NUMBER

SQL> /
create table NEWSPAPER (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL>

Related Quiz