Question: write this db code use sqlplus..don't copy from any site. Test given input. - Consider the folowing tables. Hare, FK imples Foreign Key. *+You need
write this db code use sqlplus..don't copy from any site.
Test given input.
- Consider the folowing tables. Hare, FK imples Foreign Key. *+You need to create the tables and insert data as shown in the given tablest*t - Take abum ID \{abumid as user input. n. If the abbumiD is vid: - Show the dates on ahich the indididal tracks of that album ware released. Also show the number of tracks in each of the album released by the same artist. b. If the abbundD is invid, print "Album does not exist". - You must use cursor to search aNbumiD \& find relense dates and tracks, searching implementation will be inside a procedure, track finding (of the same artist) will be inside a function. Package, exception and trigger must also be used
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
