User Profile

Collapse

Profile Sidebar

Collapse
maddurivenkys
maddurivenkys
Last Activity: Nov 22 '07, 02:54 PM
Joined: Nov 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • maddurivenkys
    replied to ORA-00907: missing right parenthesis
    in Oracle
    Hi,

    Try belwo one it will work for you.

    [code=oracle]
    select * from emp where sal=(case when sal>2000 and sal<5000 then 2000 else 3000 end)
    [/code]

    Let know if you face any issues.
    See more | Go to post
    Last edited by amitpatel66; Nov 22 '07, 11:57 AM. Reason: code tags

      Leave a comment:

    • maddurivenkys
      started a topic Where V1 In (select Fun(1)
      in Oracle

      Where V1 In (select Fun(1)

      Hi All,

      I wrote a function which will return varchar i.e '10','11','12', '13' and I am passing this value in IN cluase in SELECT query as
      [code=oracle]
      SELECT * FROM VV WHERE V1 IN (SELECT FUN(1) FROM DUAL).
      [/code]

      Where, FUN(1) is my function name, which accpets NUMBER as IN parameter and it will return VARCHAR. i.e '10','11','12', '13' .

      When I ran the above query I am getting...
      See more | Go to post
      Last edited by amitpatel66; Nov 22 '07, 04:40 AM. Reason: code tags
      No activity results to display
      Show More
      Working...