Question

3. Write a script that uses an anonymous block of PL/SQL code that attempts to insert a new flight into the flights table for flight_number 165. Check to see whether there is a sequence being used for flight_id and then adjust your INSERT statement accordingly. Remember, you can use select statements to determine which values are appropriate to insert. If the insert is successful, the procedure should display this message:

Answer 1

We will use script in oracle and SQl(Structured Query Language) and use of algorithms like cipher for encryption to insert a new flight into the flights table for the flight number 165 and that Cipher will show the desired message.