var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: String functions
I started practicing string functions.
is there any string function which can replace multiple spaces in data with a single space?
can any one list the string functions available in oracle with syntax or help me by reffering a source to learn them.
Here's an inelegant solution:
SET field1 = REPLACE(field1, ' ', ' '); --replace two spaces with one space
Run recursively until zero rows updated.
(You'll need to register--free)
Oops...forgot the WHERE clause:
WHERE field1 LIKE '% %'
Without this, you won't know when you're done.
If you can choose a character that will never be in your strings, you can do it rwithout recursivity :
With '*' :
SQL> select replace(replace(replace(' with only one space ',' ','* '),' *',''),'*','') result from dual;
with only one space
But you need such a character.