User Profile

Collapse

Profile Sidebar

Collapse
Pranav Joshi
Pranav Joshi
Last Activity: Dec 27 '06, 05:04 AM
Joined: Dec 20 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Pranav Joshi
    replied to Oracle Function
    in Oracle
    Hey, Try This out:

    SELECT TRANSLATE(123.3 4,'1234567890.' ,'9999999999.') FROM dual;

    SELECT TRANSLATE(T1.F1 <=your coulmn>,'123456 7890.','9999999 999.') FROM dual;

    Regards,
    Pranav....
    See more | Go to post

      Leave a comment:

    • Pranav Joshi
      replied to Query to find the third largest row in a table
      in Oracle
      Hey Man,

      Try This...

      SELECT * FROM
      (
      SELECT ROWNUM, EMPNO, NAME, SALARY FROM employee
      ORDER BY SALARY DESC
      )
      WHERE ROWNUM < 4
      MINUS
      SELECT * FROM
      (
      SELECT ROWNUM, EMPNO, NAME, SALARY FROM employee
      ORDER BY SALARY DESC
      )
      WHERE ROWNUM < 3
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...