Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Bogotá, Colombia
    Posts
    11

    Unanswered: Find and Replace in CLOB field

    Hi,

    I want to know what is the best and easy way to find and replace a string for other in a CLOB field.

    Thanks for your help.!

  2. #2
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Red face Find and Replace

    Hi
    Welcome to the archaic world of CLOBs.
    There doesnt seem to be a solution in one step for the same.
    The way to do so, is to find the CLOB, read it into a string, and then write the modified CLOB back to the DB.
    By the way, do u want to do the same through an application or direct on DB using sqlplus. (plsql).
    Aruneesh

  3. #3
    Join Date
    Jul 2003
    Location
    Bogotá, Colombia
    Posts
    11

    Find And Replace

    Hi, thank you for you help.

    I want to do it directly in the database (pl/sql).

    How should i do it?

  4. #4
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Red face

    Hi Dude
    Unfortunately, my knowledge in that domain is limited to doing insertions, updations, search through JSP itself. I am just starting to explore the world of PL/SQL myself.
    Thanx and Regards

Posting Permissions

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