这种情况其实可以使用TRANSLATE和replace组合使用就能完全达到目的了。 比如要将“深圳”、“北京”等作为关键词语,在显示内容是要将这些词语过滤掉不显示: Sql代码 --首先使用TRANSLATE将关键词语统一转换成一个特殊的字符串,比如这里的X SQL> select TRANSLATE('上海北京天津重庆广州深圳武汉','深圳北京','XXXX') f...
SELECT REPLACE('AbCaBc','ABC','123') FROM dual;--将A替换成1，B替换成2，C替换成3 SELECT TRANSLATE('AbCaBc','ABC','123') FROM dual;
REPLACE('AbCaBc','ABC','123')FROM dual;--将A替换成1，B替换成2，C替换成3 SELECT TRANSLATE('AbCaBc','ABC','123')FROM dual;
1.TRANSLATE这个函数的格式:TRANSLATE ( '原本的值','需要被替换的值','替换后的值') 2.便于理解的例子: 例子A(‘原本的值’中如果有值不存在于‘需要被替换的值’,不存在于‘替换后的值’)的查询效果: 1 SELECTTRANSLATE ('ABCDEFGH','ABCDEFG','1234567')ASNEW_STRFROMDUAL; 转换思路('需要被替换的...
替换字符 REPLACE ---STUFF 将字串中的每个词首字母大写 INITCAP ---N/A 翻译字符串 TRANSLATE ---N/A 字符串长度 LENGTH--- DATELENGTH or LEN 列表中最大的字符串 GREATEST--- N/A 列表中最小的字符串 LEAST ---N/A 如果为NULL则转换字串 NVL-...
CREATE OR REPLACE FUNCTION SF_PUB_STRMINUSINT (p_beg in varchar2, p_end in varchar2 ) return int /** AUTH FUNC 两个随机号相减得数 **/ AS v_ret int; vs_geb varchar2(30); vs_str varchar2(30); vn_beg int; vs_dne varchar2(30); vn_end int; begin --反转 select reverse(p_...
55.Oracle数据库SQL开发之 高级查询——使用TRANSLATE函数 欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/49805769 TRANSLATE(x,from_string,to_string)函数在x中查找from_string中的字符,并将其转换成to_string中对应的字符。
2. In the Global Change Data Object dialog box, click Browse to select the currently used data object (the data object you want to replace). 3. Click Browse by the second field to select the replacement data object, and clock OK. 3.6.10 Setting Active Data Retrieval Interval When you ...
“Fourth-generation languages (4GLs) and low code development tools have been around for decades, and many are tied to a database. For the most part, however, they stand outside the database, interacting as an external client. Oracle APEX resides inside the database system, which enables ...
“Fourth-generation languages (4GLs) and low code development tools have been around for decades, and many are tied to a database. For the most part, however, they stand outside the database, interacting as an external client. Oracle APEX resides inside the database system, which enables ...