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
Answers
Answered by
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');
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');
Answered by
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!
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!
Similar questions