Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Convert the variable (http://www.go4expert.com/forums/convert-the-variable-t24701/)

ckcy2005 24Jan2011 07:58

Convert the variable
 
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).n ame||'^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


All times are GMT +5.5. The time now is 16:32.