change table structure / (add, edit, remove column of a table) at run

Question

change table structure / (add, edit, remove column of a table) at run time

i. add a column address in the PRODUCT_SELECTION table.

ii. execute SQL INSERT statement to create a record into PRODUCT _SELECTION table

iii. run the query to updates all the records having EXPIRY_DATE as 31-Dec-2022 and

increase PRICE of all the PRODUCTS by 10% of PRODUCT_PRICE.

iv. delete all the records from PRODUCT _SELECTION Table where EXPIRY_DATE is

before 31-Dec-2022.

27 Apr 2023

Answer :

Word Count : 265

To change the table structure of a table and perform various operations at runtime, you would typically use SQL statements. Here's an example of how you can achieve the tasks you mentioned:

Assuming you're using a database system that supports SQL, here's the step-by-step ___ ____ __________ _______ _____ _________ ______ ___ ____ _________ _________ ___.
____ _________ _________ _____ ________ __________ _______.
________ ________ __________ _________ _____ ____ _____ ________ _________ _____ _____ _________.
__________ ___ _______ ________ ___.
__________ ____ ______ _____ ____ __________ ___ _________ _______ _______ __________ ________.
____ ____ _____ ___ ________ ________ ____ __________.
____ _____ ____ ________ ____ ____.
______ ___ _______ _____ _______ __________ _______ ____ ____.
______ _________ ____ ____ _________ ____ ________ ________ ______ ________ ______ __________.
_________ ________ __________ _________ _______ ________ ____.
_______ ______ ___ ________ __________ ________ ______ _______ _________.
_______ ________ _______ ________ _________.
______ ___ _______ ______ _____.
__________ _____ ___ __________ ____.
_________ ________ _______ _________ _______ ________ ___ _______ _________ ______ ___ _________.
____ _________ _____ ________ __________ _____ ________.
___ _______ ____ _____ __________.
______ ___ _____ _________ ______ __________ ____ ________.
____ ________ _______ _______ _____.
_________ _____ __________ ___ ______.
__________ __________ ______ __________ _________ __________ _____ ________ ______.
________ __________ _____ ____ ______ ___ ____ ________ __________ ______ ________.
____ ________ _____ __________ ___ ____ ____ ____ __________ ___.
________ _________ _________ _______ _____ ____ ______ _____.
___ ___ _________ _________ ______ ___ ___ _______ _________ ________ __________ ________.
____ ____ ______ _____ ___.
___ ________ _________ __________ ______ ______.
______ _____ ________ _____.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★