Create yellowpages account with password yellowpages in Oracle10g
Express Edition. This must be done after you log in as SYSTEM user. Then create tables listed below.
create user yellowpages identified by yellowpages;
grant connect, resource to yellowpages;
connect yellowpages/yellowpages
create table categories
( catcode number(2) primary key,
catname varchar(50) not null
);
insert into categories values(1,'Software Development');
insert into categories values(2,'Software Institutes');
insert into categories values(3,'Hardware Retailers');
insert into categories values(4,'Hosting Service');
create table users
( uname varchar(10) primary key,
password varchar(10) not null,
email varchar(50) unique
);
insert into users values('a','a','andy@gmail.com');
insert into users values('b','b','bill@gmail.com');
create table entries
( entryid number(5) primary key,
entryname varchar(50),
description varchar(1000),
address varchar(300),
phoneno varchar(100),
catcode number(2) references categories(catcode),
uname varchar(10) references users(uname)
);
insert into entries values(1, 'Srikanth Technologies','Provides Training for .NET, Java and Oracle',
'Dwarakanagar, Vizag', '2541948',2,'a');