数据库基础教程第六章答案.docVIP

数据库基础教程第六章答案 篇一：数据库系统基础教程第九章答案】 /p in the following, we use macro not_found as defined in the section. void closestmatchpc() { exec sql begin declare section; char manf, sqlstate[6]; int targetprice, /* holds price given by user */ float tempspeed, speedofclosest; char tempmodel[4], modelofclosest[4]; int tempprice, priceofclosest; /* for tuple just read from pc closest price found so far */ exec sql end declare section; exec sql declare pccursor cursor for select model, price, speed from pc; exec sql open pccursor; /* ask user for target price and read the answer into variable targetprice */