Database Reference
In-Depth Information
Sol:
CREATE TABLE Student
Data Type Size
Number 4 Character 20 Date
Character 50 Character 15 Number 13
( Rollno number(4) ,
Name varchar2(20),
DOB date,
Address varchar2(50), City char(15), Phone number(13)
);
Example: Create a table Staff with following structure:
Column Name
StaffID
Name
DOB
Designation
Department Address
City
Phone
Data Type Size
Number 4 Character 20 Date
Character 15 Character 15 Character 50 Character 15 Number 13 Sol:
CREATE TABLE Staff (
StaffID number(4) , Name varcha2r(20), DOB
Designation Department Address
City
Phone
);
date,
varchar2(15), varchar2(15), varchar2(50), char(15),
number(13)
Example : Create a table student_result with following structure:
