SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL; Changes -------------- BLACK and BLUE
The following statement re-creates library library_name, using an explicit path: CREATE OR REPLACE LIBRARY library_name IS '/path/directory';