DBMS - SIKSHAPATH

0

Harshdalal15

Asked: November 6, 2021In: DBMS

Write a query to create a view that shows for each order the salesman and customer by name.

0

Consider the following relations: Salesman salesman_id | name | city | commission ————-+————+———-+———— 5001 | James Hoog | New York | 0.15 5002 | Nail Knite | Paris | 0.13 5005 | Pit Alex | London | 0.11 5006 | Mc Lyon | Paris | 0.14 5007 | ...

0

Ayana

Asked: November 6, 2021In: DBMS

Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor.

0

dbms 2.3

0

Harshdalal15

Asked: November 6, 2021In: DBMS

Write a query to create a view to getting a count of how many customers we have at each level of a grade.

0

Write a query to create a view to getting a count of how many customers we have at each level of a grade.

Consider the following relation Customer: Write a query to create a view ...

0

Harshdalal15

Asked: November 6, 2021In: DBMS

DBMS-Write a query to create a view that shows for each order the salesman and customer by name.

0

Consider the following relations: Salesman salesman_id | name | city | commission ————-+————+———-+———— 5001 | James Hoog | New York | 0.15 5002 | Nail Knite | Paris | 0.13 5005 | Pit Alex | London | 0.11 5006 | Mc Lyon ...

1

Berlin

Asked: November 6, 2021In: DBMS

create table salesman

1

create a view for all salespersons. Return salesperson ID, name, and city.

1

Berlin

Asked: November 5, 2021In: DBMS

Create Local procedure to calculate the simple interest by passing the values of principal, rate and time.

1

Create Local procedure to calculate the simple interest by passing the values of principal, rate and time.