Studio has no special support for Oracle DB or other DBs. That is, the compiler recognizes no special syntax and has no special switches. You just compile the C or C++ code using the appropriate headers and libraries. I should add that that Studio gives you the best performance on Solaris.
For specific questions about Oracle DB programming in C and C++, try a database developer forum. Start here: