Pro*C is an embedded SQL programming language used to access and manipulate Oracle databases from within C or C++ programs. It involves using preprocessor commands to incorporate SQL statements directly into code and provides a more efficient way to access databases compared to traditional methods. Individuals with Pro*C skills are able to develop high-performance database applications and improve the overall efficiency of a system.