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

Thread: Pl/sql

  1. 12-08-2004, 03:51 AM #1
    mys
    mys is offline Junior Member
    Join Date
    Dec 2002
    Posts
    40

    Pl/sql

    Hi All


    I have written a sql query .One of the record is displayed like this.
    AAAAAA,BBBBBBB,AAAAAA,BBBBBB(which is based on a Function).The record gets added based upon a call for a product
    I Need to fetch the last value based upon the record.

    I am searching the Web,but i am unable to figure it out.
    Please help me out.I need to fix this today.


    Regards
    Reply With Quote Reply With Quote
  2. 12-08-2004, 04:27 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    INSTR(myCol, ',', -1) will give you the position of the last comma, which you can then use in SUBSTR.
    Reply With Quote Reply With Quote
  3. 12-08-2004, 05:24 AM #3
    mys
    mys is offline Junior Member
    Join Date
    Dec 2002
    Posts
    40
    Hi

    But the record in that particular cell keeps on getting added.I cant use substr to retreive the last value after comma.

    Plese help regarding this query

    Thanks in Advance
    Reply With Quote Reply With Quote
  4. 12-08-2004, 05:27 AM #4
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Sorry, I have no idea what you are trying to do.
    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