snig1 - Name Null?...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL> create table branch23(bname char(10) primary key,bcity char(300),assets integer) Table created. SQL> desc branch23 Name Null? Type ----------------------------------------- -------- ---------------------------- BNAME NOT NULL CHAR(10) BCITY CHAR(300) ASSETS NUMBER(38) SQL> alter table branch23 modify(bname varchar(30)) Table altered. SQL> desc branch23 Name Null? Type ----------------------------------------- -------- ---------------------------- BNAME NOT NULL VARCHAR2(30) BCITY CHAR(300) ASSETS NUMBER(38) SQL> alter table branch23 add(bstreet varchar(30)) Table altered. SQL> desc branch23 Name Null? Type ----------------------------------------- -------- ---------------------------- BNAME NOT NULL VARCHAR2(30) BCITY CHAR(300) ASSETS NUMBER(38) BSTREET VARCHAR2(30) SQL> alter table branch23 drop(bstreet) Table altered. SQL> desc branch23
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Name Null? Type----------------------------------------- -------- ----------------------------BNAME NOT NULL VARCHAR2(30) BCITY CHAR(300) ASSETS NUMBER(38) SQL> drop table branch23 Table dropped. Sheet1 Page 2 SQL> create table customer23(cname char(10) primary key,cstreet char(30), ccity varchar(30)) Table created. SQL> desc customer23 Name Null? Type----------------------------------------- -------- ----------------------------CNAME NOT NULL CHAR(10) CSTREET CHAR(30) CCITY VARCHAR2(30) SQL> create table loan23(lname char(30) primary key, lno integer, lamount float) Table created. SQL> desc loan23 Name Null? Type----------------------------------------- -------- ----------------------------LNAME NOT NULL CHAR(30) LNO NUMBER(38) LAMOUNT FLOAT(126) SQL> commit Commit complete....
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 2

snig1 - Name Null?...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online