Search & Filtering
You are given an integer N denoting an N×N matrix. Initially, each cell of the matrix is empty. You are given K tasks. In each task, you are given a cell (i,j) where cell (i,j) represents the
ith row and jth column of the given matrix.
Write a procedure and call it into main pl/sql program to find a factorial of a number.
Write a procedure to calculate factorial of a number entered by user.
Write a query to create a view that shows the average and total orders for each salesman after his or her name. (Assume all names are unique)
R1: 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 | Paul Adam | Rome | 0.13
5003 | Lauson Hen | San Jose | 0.12
R2: Orders
ord_no purch_amt ord_date customer_id salesman_id
---------- ---------- ---------- ----------- -----------
70001 150.5 2012-10-05 3005 5002
70009 270.65 2012-09-10 3001 5005
70002 65.26 2012-10-05 3002 5001
70004 110.5 2012-08-17 3009 5003
70007 948.5 2012-09-10 3005 5002
70005 2400.6 2012-07-27 3007 5001
70008 5760 2012-09-10 3002 5001
70010 1983.43 2012-10-10 3004 5006
70003 2480.4 2012-10-10 3009 5003
70012 250.45 2012-06-27 3008 5002
70011 75.29 2012-08-17 3003 5007
70013 3045.6 2012-04-25 3002 5001
Write a program in PL/SQL to show the uses of SQL%FOUND to determine if a DELETE statement affected any rows.
Write a block in PL/SQL to print the specific number of rows from a table.
Write a PL/SQL program to display the description against a grade according to the marks achieved by students in their final exams.
Write a PL/SQL program to convert a temperature in scale Fahrenheit to Celsius and vice versa.
1. You are required to create another class cuboid that inherits from rectangle. Create a header file called “cuboid.h” and implementation file called “cuboid.cpp”.
a. This class has width and length but it also has height.
b. Create accessor and mutator of this class
c. Create the following functions
i. Compute surface area.
ii. Overload the function from c-I to compute surface area of parallel sides
iii. Overload the function from c-I to compute total surface area.
iv. Compute volume.
v. Compute the length and height from center of diagonals.
Given two integers (M and N), write a program to print the first perfect square in a given range.
