Remove page break and sweep CLOB column

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Thu, 23 Oct 2008 9:45 am

Friends has some doubts who can help me. ...

Let's just say I have a clob column with the value below (dummy data coming from the real): ZZ January.ZZZZ 0001234 YWE YR FEI OBS DT WIRE TEST-056 X 00/OO Y32013 .1 .1/XXX-XXX, AGO02, www, www .0000 .0000/C0000 .4000 .1 .1 .42 .43 .9000/0000, N00000,---,---, Y32013 .1 .1/XXX-XXX, AGO02, www, www .0000 .0000/C0000 .4000 .1 .1 .42 .43 .9000/0000, N00000, Y32013, .1 .1/XXX-XXX, AGO02, www, www .0000 .0000/C0000 .4000 .1 .1 .42 .43 .9000/0000, N00000,/;
01AGO00 01AGO00 01AGO00 01AGO00 * 00128 I need remove the values of that column and put in a single line, from the 70 position, without page break, and until the position that is the semicolon;

Well the first one I got that way: select DBMS_LOB. substr (.70 .4000 column) from the table.

However I'm not getting > take the page breaks for a clob field > perform a search to find q (a clob field;) Who can help me I thank you in advance.

Thanks My Sturm
mysturm
Location: Sao paulo

Poston Thu, 23 Oct 2008 9:54 am

I would like to complement the expected result will be:-.1 .1 X 00/Y32013/XXX-XXX, AGO02, www, www .0000 .0000/C0000 .4000 .1 .1 .42 .43 .9000/0000, N00000,---,---, Y32013 .1 .1/XXX-XXX, AGO02, www, www .0000 .0000/C0000 .4000 .1 .1 .42 .43 .9000/0000, N00000, Y32013 .1 .1/XXX-XXX, AGO02, www, www .0000 .0000/C0000 .4000 .1 .1 .42 .43 .9000/0000, N00000,/all in a single line Thanks
mysturm
Location: Sao paulo

Poston Thu, 23 Oct 2008 2:41 pm

Just to update if anyone is thinking about the solution I found, can help if someone need: select replace ((DBMS_LOB. substr (column, DBMS_LOB.InStr (column, '; ') .70)), ' ', ' ') from table
mysturm
Location: Sao paulo

Poston Thu, 23 Oct 2008 3:07 pm

Thanks for posting here to us!!! :-o
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post


Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 9 guests