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!

concatenate number and string

870213Jun 25 2013 — edited Jun 25 2013

Hi Expert,

io
06/05/2013 09:56:00 AM07/05/2013 09:48:00 AM
08/05/2013 10:26:00 AM08/05/2013 05:33:00 PM
10/05/2013 10:10:00 AM11/05/2013 05:31:00 AM
14/05/2013 09:40:00 AM14/05/2013 05:39:00 PM
17/05/2013 09:41:00 AM17/05/2013 07:36:00 PM
28/05/2013 09:39:00 AM29/05/2013 09:39:00 AM

I want to do concatenate string with number , example I have 6 i want to add 0 before 6 result 06.

see query

select

      case

      when (floor(((o-i)*24*60*60)/3600)) > 9 then 

      floor(((o-i)*24*60*60)/3600)

      else          

      0 || to_char(floor(((o-i)*24*60*60)/3600))

      End

      Wh

from T

showing error ORA-00932 inconsistent datatypes:

please guide.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2013
Added on Jun 25 2013
6 comments
10,252 views