在Oracle pro*c中将double转换为字符串

Question

在Oracle pro*c中，有没有办法将双精度值转换为字符串而不丢失任何数字？精度随从中获取值的列的数字(10，8)而变化

Answer 1

正如在注释中提到的，您可以使用TO_CHAR将其转换为字符串。在Pro*C中，它看起来像这样：

EXEC SQL DECLARE num_test_cursor CURSOR FOR SELECT TO_CHAR(num) FROM numtest; 

然后，您可以将其提取到一个变量中：

EXEC SQL FETCH num_test_cursor INTO :number_string; 

最后，使用

number_string[strcspn(number_string, " ")] = '\0';

可以删除末尾的所有填充空格字符。

测试

在SQL客户端中创建一个表，例如SQLPlus，并在其中填充一些测试条目：

CREATE TABLE numtest ( num NUMBER(10,8));
INSERT INTO numtest VALUES (99.99999999);
INSERT INTO numtest VALUES (3.141592654);
INSERT INTO numtest VALUES (0.00000001);
INSERT INTO numtest VALUES (1.23);

完整、自含式专业*C程序

exec sql begin declare section;  
char *connectString = "scott/tiger@pdb";
int limit; 
char number_string[11 + 1]; //number(10,8) + NUL 
exec sql end declare section;  
exec sql include sqlca;  

#include<stdio.h>  
#include<conio.h>  
#include<stdlib.h>  

int main(void) {  
    exec sql connect :connectString;
    if(sqlca.sqlcode == 0) {  
        printf("connected to db\n");  
    } else {  
        fprintf(stderr, "failed:%s (error code=%d)\n", sqlca.sqlerrm.sqlerrmc, sqlca.sqlcode);  
        exit(1);
    }
    EXEC SQL SELECT COUNT(*) INTO :limit FROM numtest; 
    printf("row count: %d\n", limit);

    EXEC SQL DECLARE num_test_cursor CURSOR FOR SELECT TO_CHAR(num) FROM numtest; 
    EXEC SQL FOR :limit OPEN num_test_cursor; 

    int row;
    for(row = 0; row < limit; row++) {
        EXEC SQL FETCH num_test_cursor INTO :number_string; 
    
        number_string[strcspn(number_string, " ")] = '\0';
        printf("number as string: \"%s\"\n", number_string);
    }
    
    _getch();  

    return 0;
} 

程序的调试输出确认了预期的结果：

connected to db
row count: 4
number as string: "99.99999999"
number as string: "3.14159265"
number as string: ".00000001"
number as string: "1.23"