Question

use SQL to answer the question.

Create two tables and insert atleast 7 or 8 values（whatever you want） into each of these two tables

1) Person

2) Favorite food

I need every step-codes such as ：

SQL> connect admin/admin as sysdba;

SQL> create table products_tb1

2 (prod_id integer primary key,

3 prod_desc char(30),

4 cost real);

SQL> insert into products_tb1 values(11235, 'WITCH COSTUME', 29.99);

SQL> insert into products_tb1 values(222, 'PLASTIC PUMKIN 18 INCH', 7.75);

SQL> insert into products_tb1 values(13, 'FALSE PARAFFIN TEETH', 1.1);

SQL> insert into products_tb1 values(90, 'LIGHTED LANTERNS', 14.5);

SQL> select*from products_tb1;

Answer 1

Code

create table Person
(name varchar2(10) primary key,
age number(2),
weight number(3),
city varchar2(15))

insert into Person values('Jay',29,65,'Bhuj');
insert into Person values('Ajay',22,100,'Bhuj');
insert into Person values('Viay',24,52,'Gandhidham');
insert into Person values('Srujay',29,77,'NY');
insert into Person values('Sanay',55,41,'London');
insert into Person values('Dhanjay',24,89,'Perth');
insert into Person values('Mrunt',66,55,'Mumbai');
insert into Person values('Viral',29,80,'Kampala');

create table Favorite_food
(fid varchar2(5) primary key,
fname varchar2(15),
price number(3));

insert into Favorite_food values ('F101','Chocolate',10);
insert into Favorite_food values('F102','Icecream',10);
insert into Favorite_food values('F103','Nuts',20);
insert into Favorite_food values('F104','Pani puri',10);
insert into Favorite_food values('F105','Apple',55);
insert into Favorite_food values('F106','Weffer',50);
insert into Favorite_food values('F107','Chiken',100);
insert into Favorite_food values('F108','Egg',10);

output

Run SQL Command Line Copyright (c) 1982 214, Oracle All rights reserved SQL> connect Enter user-name: cystem/admin ERROR: ORA-01e17: invalid username/password; logon denied SQL> connect Enter user-name: system/admin Connected SQL> create table Person 2 (name varchar2 (10) primary key, 3 age number(2), 4 weight number(3), 5 city varchar2(15)) Table created SQL> insert into Person values (Jay,29,65, "Bhuj); 1 row created SQL> insert into Person values('Ajay',22,18e, Bhuj') 1 row created SQL> insert into Person values('Viay,24,52, Gandhidham) 1 row created SQL> insert into Person values( Srujay',29,77, NY); 1 row created SQL> insert into Person values( Sanay,55,41, 'London); 1 row created SQL> insert into Person values(Dhanjay,24,89, "Perth') 1 row created ENG 16:34 INTL 02-03-2019 2

Run SQL Command Line SQL> insert into Person values("Viral,29,8e, "Kampala') 1 row created SQL> insert into Person values('Mrunt',66,55, 'Mumbai'); 1 row created SQL> ENG 16:38 INTL 02-03-2019 2

Run SQL Command Line SQL> create table Favorite food 2 (fid varchar2(5) primary key 3 fname varchar2(15), 4 price number(3)) Table created SQL> insert into Favoritefood values ('F1e1, Chocolate,1e); 1 row created SQL> insert into Favorite_food values('F182, 'Icecream,1e); 1 row created SQL> insert into Favoritefood values( F183, "Nuts',2e); 1 row created SQL> insert into Favoritefood values( F184, "Pani puri',1e); 1 row created SQL> insert into Favoritefood values( F185, "Apple,55); 1 row created SQL> insert into Favorite food values( F1e6, "Weffer,5e); 1 row created SQL> insert into Favoritefood values( F107, "Chiken,1e0); 1 row created SQL> insert into Favorite_food values('F188, Egg,10) 1 row created SQL> ENG 16:44 INTL 02-03-2019 2

Run SQL Command Line SQL> selectfrom person; NAME AGE 29 24 WEIGHT CITY 65 Bhuj Day Ajay Viay Srujay Sanay Dhanjay Viral Mrunt 100 Bhu 52 Gandhidham 77 NY 41 London 89 Perth 80 Kampala 55 Mumbai 29 24 29 8 rows selected SQL> selectfrom Favorite food; FID FNAME PRICE F101 Chocolate F102 Icecream F103 Nuts F104 Pani puri F105 Apple F106 Weffer F187 Chiken F108 Egg 1e 1e 2e 1e 5e 180 1e 8 rows selected SQL> ENG 16:44 INTL 02-03-2019 2
If you have any query regarding the code please ask me in the comment i am here for help you. Please do not direct thumbs down just ask if you have any query. And if you like my work then please appreciates with up vote. Thank You.