pro cÖÐÆæ¹ÖµÄÎÊÌâ

#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <conio.h>
EXEC SQL INCLUDE sqlca;
EXEC SQL BEGIN DECLARE SECTION;
    VARCHAR  username [20];
    VARCHAR  password[20];
    VARCHAR  db_name[20];
    int depno_v = 30;
    int empno_v;
    VARCHAR empname[20];
    VARCHAR job_v[20];
    double salary_v;
    double comm_v;
EXEC SQL END DECLARE SECTION;

void sqlerror();
main()
{
  //Óû§Ãû
  strcpy(username.arr,"scott");
  username.len=strlen(username.arr);
//ÃÜÂë
  strcpy(password.arr,"tiger");
  password.len=strlen(password.arr);
//Êý¾Ý¿âÃû
  strcpy(db_name.arr, "ORACLE");
  db_name.len=strlen(db_name.arr);
  EXEC SQL DECLARE db_link DATABASE;
 
  printf("\nÁ¬½Óµ½ORACLE...");
 
  EXEC SQL WHENEVER SQLERROR DO sqlerror();
  EXEC SQL CONNECT :username IDENTIFIED BY :password AT db_link USING :db_name;
 
  printf("\nÁ¬½Óµ½ORACLE³É¹¦.");
  EXEC SQL AT db_link CREATE TABLE CLA(CNAME CHAR(12));
  printf("\n´´½¨class±í³É¹