Computer Science, asked by rockman, 1 year ago

solve this questions number 6 plz it's argent and I am very thank ful you plz help me plz plz plz plz plz plz

Attachments:

rockman: thanks
rockman: plz help me
rockman: i ask a one question again plz help you
rockman: sometimes
rockman: if you answer my questions and then send question
rockman: i hope you help me
isiddagangajkd: C) INSERT INTO Managers (Deptno, DeptName, Name, City) VALUES ('S106', 'Sales', 'Kritika Tuteja', 'Delhi');
isiddagangajkd: Hope you got all answers
rockman: yes thanks
rockman: thanks

Answers

Answered by isiddagangajkd
2
A) VARCHAR(15)

Here 15 is maximum number of characters entered in DeptNamefield

B) Select * from Manager;

Here * represents all fields(columns of table)

C) INSERT INTO Managers (Deptno, DeptName, Name, City) VALUES ('S106', 'Sales', 'Kritika Tuteja', 'Delhi');

isiddagangajkd: Urgent Changes Required, Change Manager in B as Manger and Change Managers in C also as Manger. Sorry for inconvenience.
rockman: what
isiddagangajkd: Spelling of table name should he manger..
Answered by siddhartharao77
1
Create table Manager(Deptno Varchar2(10), Deptname varchar2(10), Name varchar2(10), City varchar2(10));

insert into Manager values('S101', 'Sales', 'Pranjal Sharma', 'Delhi');

insert into Manager values('HR404', HR', 'Preeti Arora', 'Chennai');

insert into Manager values('P204','Purchase','Sukhmeen Singh','Bangalore');

insert into Manager values('AD990','Admin','Sukanya Kumar','Mumbai');


(b) select * from Manager;

Hope this helps!



isiddagangajkd: :-) All the Best.. DO well
rockman: plz again help me
rockman: i don't idea this subject
rockman: plz first year try this subject plz help me
isiddagangajkd: Feel free to Ask your queries..
siddhartharao77: Bro's. Sorry for the disturbance. Don't chat here.
rockman: no i send new question ask you
rockman: plz solve this
isiddagangajkd: Table name is specified as "Manger" not "Manager"
siddhartharao77: Ohhk..I cannot edit it now.
Similar questions