Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    11

    Unanswered: How to construct a String using PL/SQL.

    Hi! Im a beginner in PL/SQL. Wanted to know if there was a way of making a string out of different values retrieved from the database.

    That is to say, for every specific value i receive from a select query i want to convert the values retrieved in a string. For example i want to retrieve the five values => "a", "n", "s", "w", "e", "r" and want to write into one string as "answer".

    Please someone advice an efficient way of acheiving this thru solely by PL/SQL.

  2. #2
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    user two pipes to concatinate a string

    a:='asdf' || 'qwert' || ....

  3. #3
    Join Date
    Dec 2003
    Posts
    11
    Thnx for the help ... one more thing.. if somehow i make a formula out of this

    e.g.

    that is ...the string is equivalent to

    ((Max(X) +6)/5)

    can i somehow execute the string ive extracted in PL/SQL.

  4. #4
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Yah... u have to use a package called DBMS_SQL and use the PARSE function in that..
    u have to read through oracle documentation for details

  5. #5
    Join Date
    Dec 2003
    Posts
    11
    Thnk u....uve been a great help

Posting Permissions

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