[SOLVED] Dbs211 lab 07 – database application development

Objective:
In this lab students learn:
• How to connect to an Oracle server from a C++ program.
• How to write and execute SQL queries in a C++ program.Individual Submission:
Your submission will be a single text-based .cpp file including your C++ program for
the Database Application lab.
L07_ID_LASTNAME.cpp
Your submission needs to have your username and password in the .cpp file. If any other
username is used or left empty, will be marked ‘0’.Lab Requirements and Submission:
In this lab, you need to write a C++ program to execute the following queries and display
the result returned by each query. For the output format, see the sample output.
1. Display Employee Number, First Name, Last Name, Phone Number, and
Extension of all Employees who work in San Francisco. See the following Sample
output. (Sort the report according to the employee number)2. Display Employee Number, Last Name, Phone Number, and Extension for all
managers. (You can use column reportsto to find the managers’ employee
number)Your program will output only the following reports.
Remove any outputs (messages) from your program that you have used for testing
you code such as printing “The connection is successful”.C++ sample code to execute a query(this is not your submission code)