Oracle SQL - Write SQL to display table structures

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  ww .  j a  v  a 2 s.co  m
  4        Page         NUMBER
  5  );
SQL>

Write SQL to display table structures

Demo

SQL>
SQL> describe NEWSPAPER-- w  w  w. j  a  v  a  2s.c o 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