User Profile

Collapse

Profile Sidebar

Collapse
Mans
Mans
Last Activity: Feb 9 '14, 04:11 PM
Joined: Feb 1 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Mans
    replied to result coming twice , no conversion
    in Oracle
    Rabbit, i am trying to get my result like convert upper to lower and lower to upper in same string
    example : select 'AbcDEfgH' from dual;
    and i am expecting result as
    output: aBCdeFGh
    all lower convert to upper and upper convert to lower.
    See more | Go to post

      Leave a comment:

    • Mans
      started a topic result coming twice , no conversion
      in Oracle

      result coming twice , no conversion

      Hi,
      I have tried to convert upper to lower and lower to upper in single string it's coming but not with same.

      select upper(substr('m aN',0,3))||lowe r(substr('maN', 3)) from dual;
      Result:

      UPPER(
      ------
      MANn

      but it should come like 'MAn'
      See more | Go to post
      No activity results to display
      Show More
      Working...