复杂sql语句proc写法（动态写法）

EXEC SQL BEGIN DECLARE SECTION;
  char  szSql[1024*5];

  int     iCount;
EXEC SQL END DECLARE SECTION;

memset(szSql,0x00,sizeof(szSql));

sprintf("select count(*) from tablename");

 

EXEC ORACLE OPTION( HOLD_CURSOR=YES );

EXEC SQL PREPARE STMT FROM :szSql;

EXEC SQL DECLARE course_lm CURSOR FOR STMT;

 

EXEC SQL OPEN course_lm;

 

EXEC SQL FETCH course_lm INTO :iCount;

 

printf("表tablename里面有[%d]条数据\",iCount);

 

EXEC SQL CLOSE course_lm;