Scribd
Upload
1 views2 pages

Program 9

The document outlines a PL/SQL script to update the 'Rate' field in the 'Inventory' table by increasing it by 20%. It also includes commands to add a new field called 'Alter_No' for item numbers and assigns values to this new field for existing records. The script demonstrates the creation of the table, insertion of data, and the execution of updates and selects to show the changes.

Uploaded by

praneshmbsc2025
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1 views2 pages

Program 9

The document outlines a PL/SQL script to update the 'Rate' field in the 'Inventory' table by increasing it by 20%. It also includes commands to add a new field called 'Alter_No' for item numbers and assigns values to this new field for existing records. The script demonstrates the creation of the table, insertion of data, and the execution of updates and selects to show the changes.

Uploaded by

praneshmbsc2025
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Write a PL/SQL to update the rate field by 20% more than the current rate

in inventory table which has the following fields: Prono, ProName and
Rate. After updating the table a new field (Alter) called for Number of item
and place for values for the new field without using PL/SQL block

QUERY

CREATE TABLE Inventory (

Prono NUMBER PRIMARY KEY,

ProName VARCHAR2(30),

Rate NUMBER

);

INSERT INTO Inventory VALUES (1, 'Pen', 10);

INSERT INTO Inventory VALUES (2, 'Book', 50);

INSERT INTO Inventory VALUES (3, 'Pencil', 5);

COMMIT;

SELECT * FROM Inventory;

BEGIN

UPDATE Inventory

SET Rate = Rate * 1.20;

COMMIT;

END;

SELECT * FROM Inventory;

ALTER TABLE Inventory

ADD Alter_No NUMBER;


UPDATE Inventory

SET Alter_No = 101

WHERE Prono = 1;

UPDATE Inventory

SET Alter_No = 102

WHERE Prono = 2;

UPDATE Inventory

SET Alter_No = 103

WHERE Prono = 3;

COMMIT;

SELECT * FROM Inventory;

You might also like