Answer:
The procedure in SQL is created as follows
Explanation:
--creating the procedure
CREATE OR REPLACE PROCEDURE prc_inv_amounts (W_IN IN NUMBER)
AS
--defining variables
W_CK NUMBER := 0;
W_SUBT NUMBER := 0;
W_TAX NUMBER := 0;
BEGIN
--Authentication process of the invoice
SELECT COUNT(*) INTO W_CK FROM INVOICE WHERE INV_NUMBER := W_IN;
--Transaction confirmation
IF W_CK = 1 THEN
SELECT SUM(LINE_TOTAL) INTO W_SUBT FROM LINE
WHERE
--checking the invoice for the desired invoice number
LINE.INV_NUMBER = W_IN;
W_TAX :=W_SUBT * 0.08;
--updating the invoice
UPDATE INVOICE
--setting the new values
SET INV_SUBTOTAL = W_SUBT,
INV_TAX = W_TAX,
INV_TOTAL =W_SUBT + W_TAX
WHERE INV_NUMBER = W_IN;
--ending the if statement
END IF;
--ending the procedure
END;
Answer:
In assembly language, two instructions control the use of the assembly language procedure.
CALL pushed the control to the return address onto the stack and transferred the control.
RET instruction returns the address that placed on the stack by a call instruction.
Explanation:
Action RET instruction
- The RET instruction pops the address and returns off the stack, which is pointed by the stack pointer.
- The stack is LIFO in memory at a particular location, and the pointer points offset from the stack location.
RET instruction does its job by consulting the register and memory state at the point when it is executed.
In RET instruction, only register and memory state is executed. Call instruction must save that address that figure out in a register and memory location.
Answer:
The answer to this question can be given as:
code:
class CollegeCourse
{
String Dept;
int CourseNumber;
double Credits;
double fee;
}
Explanation:
We all know that class is a collection of data members and member functions. In the above code we use the following syntax for class declaration that can be given as:
Syntax of class declaration :
class class_name
{
data member & member function
}
In the above code firstly we declare a class that is CollegeCourse. In this class, we define a variable that name and datatype is already given in the question that is String Dept, int CourseNumber, double Credits, double fee. In the variables first variable data type is string. It is used for store string value like ('us','xxx','aaa').The second variable datatype is an integer. It is used for store integer value like (1,23,5,56). The third and fourth variable datatype is the same that is double. This data type is used to store the floating-point value.
Joseph Henry in about 1835. He is American and he made something called a relay.
Answer:
Contact the company to find out what the problem is.
Explanation:
