1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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