DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Tricky query.

Threaded View

  1. 03-07-2007, 02:02 PM #4
    tabreaz
    tabreaz is offline Senior Member
    Join Date
    Sep 2005
    Posts
    278
    Dear badrinathn,

    You can use SUBSTR function as
    Code:
    SELECT TO_NUMBER(SUBSTR('BOOK11', 5, Length('BOOK11')-4))
FROM DUAL;
    Last edited by tabreaz; 03-07-2007 at 06:17 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width