Question: Write an Oracle bgunix ProC program to query the tables (see below). The tables may be accessed as RayKresman. TableName where TableName is Aircraft or
Write an Oracle bgunix ProC program to query the tables (see below). The tables may be accessed as RayKresman. TableName where TableName is Aircraft or Flights. Aircraft (airplanelD number(2) primary key, airplaneName char(20), cruisingRange numberS): Flights (airplanelD number (2), flightNo number(4) primary key fromAirport char(20), toAirport char(20), distance number(4), depart timestamp, arrives timestamp, foreign key (airplaneID) references Aircraft); Queries: ane 2. Print for each flight (whose duration is between 1 hour 15 minutes to 3 hours and 15 minutes-both inclusive): flightNo, fromAirport, toAirport, flightDuration. Query 1 if an airplanelD has no flight, no need to print its info Query 2 - do not worry about time zones. Limit width of flightDuration to 20 columns. Google oracle timestamp functions to work with timestamps (for example, https://stackoverflow.com/questions/257324/oracle-how-t o-add-minutes-to-a-timestamp) Write an Oracle bgunix ProC program to query the tables (see below). The tables may be accessed as RayKresman. TableName where TableName is Aircraft or Flights. Aircraft (airplanelD number(2) primary key, airplaneName char(20), cruisingRange numberS): Flights (airplanelD number (2), flightNo number(4) primary key fromAirport char(20), toAirport char(20), distance number(4), depart timestamp, arrives timestamp, foreign key (airplaneID) references Aircraft); Queries: ane 2. Print for each flight (whose duration is between 1 hour 15 minutes to 3 hours and 15 minutes-both inclusive): flightNo, fromAirport, toAirport, flightDuration. Query 1 if an airplanelD has no flight, no need to print its info Query 2 - do not worry about time zones. Limit width of flightDuration to 20 columns. Google oracle timestamp functions to work with timestamps (for example, https://stackoverflow.com/questions/257324/oracle-how-t o-add-minutes-to-a-timestamp)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
