This is a discussion on Please help , about OCI Number format within the Oracle Database forums, part of the Database Server Software category; --> HI, everyone! In OCI program, I want to get the number field value of a table just the same ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| HI, everyone! In OCI program, I want to get the number field value of a table just the same as select it in sqlplus. e.g. SELECT * FROM ttt; SQL> select * from ttt ID F ---------- ---------- 1 1.1234 2 1.1234 3 1.1234 4 1.34421 1748 2.3424 34444 234.3 1.1111E+38 4 1.1000E+34 5 3.4123E+49 5747 But, in my OCI program, when defined with SQLT_STR, never get the above value, just like: 1 1.1234 2 1.1234 3 1.1234 4 1.34421 1748 2.3424 34444 234.3 111111111111111111111111111111111111111 4 11000000000000000000000000000000000 5 3412341413214240000000000000000000000000000 5747 How to implement like the sqlplus??? |