- 论坛徽章:
- 0
|
假如有一张表,有100个字段,分别为:id,t,v1,v2... ...v98
请问怎么用proc实现select?
应该不是一下最笨得方法吧?请大侠赐教!
int senid;
char timestr[200];
float v[98];
EXEC SQL WHENEVER SQLERROR GOTO CONTINUES;
oraca.orastxtf = ORASTFERR;
EXEC SQL CONNECT :exchangename IDENTIFIED BY :exchangepass USING :exchange_name;
EXEC SQL PREPARE JKLOADPLAN FROM SELECT id,to_char(t,'yyyy-mm-dd hh24:mi:ss') ,v1,v2,... ... ,v98 from exchange.jkrundata ;
EXEC SQL DECLARE CurJKLOADPLAN CURSOR FOR JKRUNDATA;
EXEC SQL OPEN CurJKLOADPLAN ;
EXEC SQL WHENEVER NOT FOUND DO break;
EXEC SQL FETCH CurJKLOADPLAN INTO :senid,:timestr,:v1, :v2... ...,:v98; |
|