Write a PL / SQL block to display the details of projects which have software having a
Fantastic news! We've Found the answer you've been seeking!
Question:
Write a PL / SQL block to display the details of projects which have software having a price more than 100. This block should display ProjCode, ProjTitleName, SWTitle, and SWPrice.?
Given the schema below : Developer (DevCode, DevName, DevAddr, DevEmail, DevTel) Proj (ProjCode, ProjTitlee, BeginDate, EndDate SW (SWCode, SWName, SWPrice, ProjCode) Task (DevCode, ProjCode)
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: