PL/SQL String Replacement Guide

1 year ago
William Carter
1 minute

In PL/SQL, you can use the REPLACE function to replace strings. The REPLACE function takes three parameters: the original string, the substring to replace, and the substring to replace it with. For example:

DECLARE
   original_string VARCHAR2(100) := 'Hello, World!';
   replaced_string VARCHAR2(100);
BEGIN
   replaced_string := REPLACE(original_string, 'Hello', 'Hi');
   DBMS_OUTPUT.PUT_LINE(replaced_string); -- Output: Hi, World!
END;

In the example above, the REPLACE function replaces the original string “Hello” in “Hello, World!” with “Hi”, resulting in “Hi, World!”.

bannerAds