-
PLSQL - remove row with cond
I have the following tables:
Resident=(resident_id (PK), resident_name)
Requiest_for_repair=(request_id (PK), Total_cost,reuest_date)
Party_room=(resident_id (PK), start_date, Total_cost)
Event=(Event_id (PK), category, start_date)
Unit_for_sale_lease=(resident_id (PK), Appt_no (PK), Start_date)
Filerequest(resident_id (FK),request_id (FK))
Here is the requirement:
Write a PLSQL program to remove part_room schedule, an event, request for repair, or unit for sale or lease from DB.
In case of party room or repair schedule, provide resident_name, total_cost apply.
Call me if you have a question, I know I am not too clear.
Lava
-
re
remove based on what condition..
can u reframe your question...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|