Pro*c when connecting to a database dbname settings __ Database

A lot of primary problems have been encountered in the research pro*c in recent years. When connecting to a database in pro*c, we typically use the configuration of a connection in "Tnsnames.ora", which is simple to write, and the syntax is as follows:

EXEC SQL Connect:username identified by:p Assword USING:d bname;

* * Here is the dbname in the "Tnsnames.ora" configured name * * *

So how do you write a dbname if you don't have the appropriate connection information configured in "Tnsnames.ora"? I found a good time on the internet did not find the right answer, I can only try. Tried a few times finally got the answer, in fact dbname settings have this similar to write the connection string in JDBC, namely: "IP Address: Port number/Instance name" For example: Connect the local Oracle Express can be written as "Localhost:1521/xe".