REPLACE Replace or update one file with another syntax REPLACE source_path_Name destination_path [/A] [/P] [/R] [/W] REPLACE source_path_Name destination_path [/P] [/R] [/S] [/W] [/U] key path : The folder where files are to be replaced. /A : Add any missing files. /P : Prompt for confirmation (each file) /R : Replace even Read-only files /S : Include all subfolders of the destination. /W : Wait for you to insert a floppy disk. /U : Replace (update) only files that are older than the source. Limitations:When replacing in all subdirectories (/S ) you cannot ADD files (/A) or restrict to replacing older files (/U)
select replace(colm,'aaa',chr(39)) from tablename将字段colm中的'aaa'用单引号代替
REPLACE(char , search_string ,replacement_string)例如: SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL;Changes -------------- BLACK and BLUE
syntax
REPLACE source_path_Name destination_path [/A] [/P] [/R] [/W]
REPLACE source_path_Name destination_path [/P] [/R] [/S] [/W] [/U]
key
path : The folder where files are to be replaced.
/A : Add any missing files.
/P : Prompt for confirmation (each file)
/R : Replace even Read-only files
/S : Include all subfolders of the destination.
/W : Wait for you to insert a floppy disk.
/U : Replace (update) only files that are older than the source.
Limitations:When replacing in all subdirectories (/S ) you cannot ADD files (/A) or restrict to replacing older files (/U)
SELECT REPLACE('JACK and JUE','J','BL') "Changes"
FROM DUAL;Changes
--------------
BLACK and BLUE
上网下点中文的oracle函数大全之类的文档就可以解决了