Clever Geek Handbook

Deleting rows in oracle sql

Currently, in the address column in the test table, I have data in the following format,

12th Street

Test brochure

Test_City

but in the output I would require it in the following format

12th Street Avenue Test_City.

Can someone please tell me how to use the query to display it appropriately.

+3


source to share


2 answers


You can try this:



select regexp_replace(your_address,'[[:space:]]',' ') from your_tab;
+2


source


Just enter chr (13) and chr (10) from the line:

declare
   teststring   varchar2 (32767) := ' This is the value

that I chose';
begin
   dbms_output.put_line (teststring);
   dbms_output.put_line (replace (replace (teststring, chr (13), ''), chr (10), ' '));
end;

Result:



 This is the value

that I chose
 This is the value  that I chose

Two spaces since I entered two texts in the text.

+2


source






More articles:


All Articles