Convert the variable

Discussion in 'Oracle' started by ckcy2005, Jan 24, 2011.

  1. ckcy2005

    ckcy2005 New Member

    Joined:
    Mar 24, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    I got a variale which passing by other problem to pl/sql
    colBuf="USER,NAME,LOC,DATE"


    need to make it like this
    tempcolBuf=||'^B'||bfary(i).user||'^B'||bfary(i).name||'^B'||bfary(i).loc||'^B'||bfary(i).date||'^B'

    anyone can help? any command can use? or loop?
    hopefully can get the solution by syntax...

    Thank you
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice