What is Pro*C ?

Pro*C means creating a program that’s embedded with SQL statements. It’s possible to access Oracle database from C program using Pro*C.

Pro*C is a programming language used for writing embedded SQL programs in C or C++ applications. It is an extension of the C/C++ programming language that allows SQL statements to be embedded within C/C++ code.

Pro*C allows developers to write programs that interact with a database management system (DBMS) using SQL statements, and then use the results of those queries in their C or C++ programs.

This can be useful in many different applications, such as developing enterprise applications, creating reports and data analysis tools, or building database-backed web applications.

Why ?

One of the main benefits of using Pro*C is that it allows for better performance and efficiency when working with databases. By embedding SQL statements directly in the C/C++ code, developers can avoid the overhead of passing data back and forth between the application and the database, which can help to reduce the amount of time and resources required to execute SQL statements.

Pro*C is primarily used with the Oracle Database, although it may also be used with other database management systems that support embedded SQL.