Answer:
Car car = new Car();
Explanation:
Here we declare a variable called car which is a reference to an object of type Car.
Next we create a new object of type Car by using the new keyword. Here we are invoking no argument constructor of class Car. In case the car class has other constructors which take additional arguments, we could have initialized our object using the corresponding version of new.
The reference variable car is initialized then to the newly created object of type Car as described in the previous step. Now we can use the car reference variable to invoke relevant methods defined in the Car class.
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;
Which programming language are you working in?
Here is how you could achieve this in Python:
establish a counter, starting at 1.
While your counter is 10 or less, do two things:
print the counter,
and increase the counter by 1.
code:
counter = 1
while counter <= 10:
print(counter)
counter = counter + 1
Those last two lines should be indented.
I'd suggest he uses
LOOKUP Function.
You can use the LOOKUP function when you need to look in a
single column or row and find a value from the same position in a corresponding
column or row. We have a much improved VLOOKUP that can also be used to search
one row or column or multiple rows and columns.
