/* Formatted on 3/22/2018 1:30:09 PM (QP5 v5.294) */
DROP TABLE TEMP;
/
CREATE TABLE TEMP
(
TEST_COLUMN NUMBER
)
/
INSERT INTO TEMP (TEST_COLUMN)
VALUES (TO\_CHAR (0.63, '99990.999990'))
/
COMMIT;
SELECT*FROM TEMP
TEST_COLUMN
-----------
.63
While Inserting I want to add 6 Decimals like this 0.630000, This is not working
But this is working when I do it from DUAL Any thoughts ? I'm doing insert from PL/SQL But same value shows good in DBMS_output.
