How to remove trailling numbers when using the update function (database toolbox)

Question

Blue 2023-10-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2036371-how-to-remove-trailling-numbers-when-using-the-update-function-database-toolbox

回答： Sulaymon Eshkabilov 2023-10-20

采纳的回答： Sulaymon Eshkabilov

在 MATLAB Online 中打开

Hi,

Im using the update function from the database toolboox to update data in an Oracle database

conn = database(env, user, pass)
tablename = 'depth_table';
whereclause = 'where set_id = 1';
p_var = 'depth_p';
d = [1,1,1,1]';
p = table(0.01 * ones(height(d), 1), 'VariableNames', {'depth_p'});
update(conn, tablename, p_var, p, whereclause)

The problem is that the 0.01 value in Matlab becomes 0.010000000003456346 in Oracle (its a simple number field in Oracle). How can I stop this from happening ?

Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sulaymon Eshkabilov 2023-10-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2036371-how-to-remove-trailling-numbers-when-using-the-update-function-database-toolbox#answer_1337726

在 MATLAB Online 中打开

Maybe to store data in a single() format instead of double (default in MATLAB), and also, round up the values, e.g.:

t = linspace(0, 2*pi, 10);
t = round(t, 3, 'significant'); % Round to 3 significant digits 
ts = single(t);
F = sin(t);
F = round(F, 3, 'significant'); % Round to 3 significant digits 
Fs = single(F);
T = array2table(ts');
T.Fun = Fs'
T = 10×2 table
    Var1       Fun   
    _____    ________

        0           0
    0.698       0.643
      1.4       0.985
     2.09       0.868
     2.79       0.344
     3.49      -0.341
     4.19      -0.867
     4.89      -0.984
     5.59      -0.639
     6.28    -0.00319