| 21. 5. 10. TRANSLATE |
|
|
The TRANSLATE functions transforms text by using the specified pattern: |
|
v_tx:= translate(string, search, replacement);
|
|
The TRANSLATE function takes search and replacement strings and creates character-to-character maps |
The third parameter can't be NULL or an empty string. Otherwise, the result is always NULL. |
|
SQL> declare
2 v1_tx VARCHAR2(20):='To be or not to be';
3 v2_tx VARCHAR2(20);
4 begin
5 v2_tx:= translate (v1_tx,'bo ','BO');
6 DBMS_OUTPUT.put_line(v2_tx);
7 end;
8 /
TOBeOrnOttOBe
PL/SQL procedure successfully completed.
SQL>
SQL>
|
|