Skip to Main Content

SQL & PL/SQL

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!

Oracle 12c - Sql Query - Character to Number

SANPATMar 14 2022 — edited Mar 15 2022

Dear Friends
I want to select the data which is in character form (34:44) which i want to convert to number as (34.44).
I tried the following Query but its giving the error message, can you please suggest the correct syntex . clock_in is in Character ("34:44")
SELECT EMP_NO, TO_NUMBER('clock_in', '99.99'), OFF_DUTY,CLOCK_IN,CLOCK_OUT FROM ATT_BIOMATRIX_DRAFT

Sanjay

Comments

rohanwalia

Can you provide the code you used to create selectManyChoice.

Also try posting in

Thanks

user1254328

This is the snippet...

Following is my selectManyChoice ...

    <af:selectManyChoice   id="dmnc" value="#{MyBean.port}" selectAllVisible="false" contentDelivery="lazy" autoSubmit="true" 

                  partialTriggers="t1:headerLL t1:it7 t1:headerModern t8:headerHistoric"

            disabled="#{! MyBean.correlate}">                 

                      <f:selectItems value="#{MyBean.actualList}" id="i3"/>

                   

                    </af:selectManyChoice>

Issue happens only in FireFox...

Tested in IE and Chrome - no issue.

ngsankar

what version of firefox you are using?

rohanwalia

Can you let us know your jdev version please?

Thanks

Daniel Merchán

Hi.

Are your Firefox version certified with your WebCenter/JDeveloper version?. Check the certification matrix.

Did you clear Firefox cache?. Maybe there is previous executions with style being in conflict.

Are you using ADF Skinning or External CSS to apply styling to default HTML tags?.

     If yes, please remove all the CSS and try again. If it works is something related to your CSS

   

If not. Are you able to reproduce in a Test Case? If yes, please provide to us or open an Oracle-SR, maybe can be a bug.

I hope this helps.

Regards.

user1254328

we are using Jdev 11.1.1.6 and Firefox is 30.0 (Hope these versions are supported)

Daniel Merchán

Hi.

If you have access to Oracle My Support (MoS) you can find the certifications of your current version.

You have to go to Ceritifications Tab and search for ADF 11.1.1.6.

You will find the following certifications for the browsers:

- Google Chrome (10+)

- IE 6,7,8,9

- Safari 4.x, 5.x

- Firefox 5+, 3.x

You have to consider migrate to ADF 11.1.1.7 version (it means WebCenter 11.1.1.7 and 11.1.1.8 versions) as 11.1.1.6 is not supported yet and Oracle will suggest you patching your environment.

I hope this information helps.

Regards.

1 - 7

Post Details

Added on Mar 14 2022
3 comments
117 views