Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TO_CHAR FUNCTION IN ORACLE FORM

704806Oct 8 2009 — edited Oct 9 2009

HI,

Table called A has column name col1
col1
12563.563
52685.563
05263.540
I would like to use SUBSTR(col1,2,6) for insert values from A table to B table by Oracle form and following values are inserted in B table
2563.5
2685.5
263.4
If I use SQLPLUS it is inserting as my requirement like
2563.5
2685.5
5263.4

Third row should be 5263.5 instead of 263.4. In Oracle form may have internal coversion function to convert character value to number values, I do not want to convert the value to number. Both table columns are varchar2 column.

What is the equal to_char function in Oracle form. If it is NLS_NUMERIC_CHARACTERS, please what are the parameters to be passed along with column.

Thanks in advance
Saravanan.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2009

Added on Oct 8 2009

#forms, #moved-from-devops

3 comments

2,123 views