数据库编程笔记（五） Pro*C: 建立数据库并发连接

/*建立数据库并发连接*/
char userName[20],passWord[20],server[20],temp[20];
strcpy(userName,"scott");
strcpy(passWord,"tiger");
strcpy(server,"orcl");
EXEC SQL CONNECT :userName IDENTIFIED BY :passWord USING :server;--建立默认连接

EXEC SQL DECLARE system DATABASE;
strcpy(userName,"system");
strcpy(passWord,"manager");
strcpy(server,"orcl");
EXEC SQL CONNECT :userName IDENTIFIED BY :passWord  AT system USING :server;--建立非默认连接

EXEC SQL AT system SELECT user INTO :temp FROM dual; --使用非默认连接

EXEC SQL SELECT user INTO :temp FROM dual;    --使用默认连接