ACTUALPRICE : Actual Price of the product ordered. NUMBER(8,2) QTY : Quantity of the product ordered. NUMBER(8) ITEMTOT : Total amount of the product. (QTY * ACTUALPRICE) NUMBER(8,2) ...
-- Create tables using PL/SQL BEGIN -- Create Medicine table EXECUTE IMMEDIATE 'CREATE TABLE Medicine ( Code INT PRIMARY KEY, Name VARCHAR (8), Price DECIMAL (5, 2), Quantity INT )'; -- Create ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results