Prof. Ashay Dharwadker's Courses (2):

Course	Semester	Grade	Add New Course
Information Systems	Fall 2003	View	Update Course
Database Systems	Fall 2003	View	Update Course

Projects (1)

Seminars (1)

How to create a table??
If we are to create the following table.
test

SNO.	Name	Age
1	Rachit	19
2	Ankit	19

we would type(in Oracle)::
create table test(SNo number(2), Name varchar2(30), Age number(2));

to make SNo as primary key we would simply type::::
create table test(SNo number(2) primary key, Name varchar2(30), Age number(2));
To view the attributes of the table we would simply type desc test; this would show the field names,field type and field size in the table.

How to Insert values in the table??

Simply type::
insert into test values(1,'Rachit',19);
insert into test values(2,'Ankit',19);

To view the table ::
select * from test;

to update a table::
for instance Ankit is now 20 years old...
update test set Age = 20 where SNo = 2;

to delete a record::
for instance Rachit decided to leave::
delete test where SNo=1;

to delete all data in the table::::
delete test;
this will leave a null table

To alter a table(change,add,modifydelete fields)::::

If you need another field address in the table::
alter table test add address varchar2(30);
this will add a column address to the table.

If we need to make the field Name larger in size::
alter table test modify Name varchar2(40);
Note::you cannot decrease the size of a field.

If you need to delete a column:::
alter table test drop column address;
This will delete the column Address.

The next part of my seminar was to compare Oracle9i with SQL Server 2001.

Information was taken from www.oracle.com

Research Notes (1)