如何从表中查询出某列的值包含“tab”字符或“回车”字符的数据 在我的某列中包含有特殊字符,我想查询出这样的数据select * from table_name where column_name = ......谁能帮个忙,这个条件如何写呀 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 “回车”"换行" 的ascii码 10 和13tab 好像 是 9where tab_str = chr(9)chr() 是将 ascii 码转换成 字符ascii() 是 将字符转换成ascii码 SQL> select ascII(' ') from dual; ASCII('')---------- 32SQL> select ascII(' 2 ') from dual; ASCII('')---------- 10SQL> select chr(13) from dual;C-SQL> select 'tab ' from dual where instr('tab ' ,' ')>0;'TAB----tabSQL> select 'enter'||chr(10)||'enter' from dual 2 where instr('enter'||chr(10)||'enter',chr(10))>0;'ENTER'||CH-----------enterenterSQL> select'awofnaweo'||chr(10)||'dfwef' from dual 2 where instr('awofnaweo'||chr(10)||'dfwef',chr(10))>0;'AWOFNAWEO'||CH---------------awofnaweodfwefSQL> select 'awofnaweo'||chr(13)||'dfwef' from dual 2 where instr('awofnaweo'||chr(13)||'dfwef',chr(13))>0;'AWOFNAWEO'||CH---------------awofnaweodfwefSQL> SQL> select ascII(' ') from dual; ASCII('')---------- 32SQL> select ascII(' 2 ') from dual; ASCII('')---------- 10SQL> select chr(13) from dual;C-SQL> select 'tab ' from dual where instr('tab ' ,' ')>0;'TAB----tabSQL> select 'enter'||chr(10)||'enter' from dual 2 where instr('enter'||chr(10)||'enter',chr(10))>0;'ENTER'||CH-----------enterenterSQL> select'awofnaweo'||chr(10)||'dfwef' from dual 2 where instr('awofnaweo'||chr(10)||'dfwef',chr(10))>0;'AWOFNAWEO'||CH---------------awofnaweodfwefSQL> select 'awofnaweo'||chr(13)||'dfwef' from dual 2 where instr('awofnaweo'||chr(13)||'dfwef',chr(13))>0;'AWOFNAWEO'||CH---------------awofnaweodfwefSQL> SQL> select ascII(' ') from dual; ASCII('')---------- 32SQL> select ascII(' 2 ') from dual; ASCII('')---------- 10SQL> select chr(13) from dual;C-SQL> select 'tab ' from dual where instr('tab ' ,' ')>0;'TAB----tabSQL> select 'enter'||chr(10)||'enter' from dual 2 where instr('enter'||chr(10)||'enter',chr(10))>0;'ENTER'||CH-----------enterenterSQL> select'awofnaweo'||chr(10)||'dfwef' from dual 2 where instr('awofnaweo'||chr(10)||'dfwef',chr(10))>0;'AWOFNAWEO'||CH---------------awofnaweodfwefSQL> select 'awofnaweo'||chr(13)||'dfwef' from dual 2 where instr('awofnaweo'||chr(13)||'dfwef',chr(13))>0;'AWOFNAWEO'||CH---------------awofnaweodfwefSQL> 根据这个自己改,这个是查找字符窜中有%的记录select * from table_name where column_name like '%\%%' escape '\'; 请教一个oracle索引的问题 oracle 一个表中有100条记录这样查询表中的第80条到90条记录 关于单独存放BLOB文件表空间的问题 关于表的部分反转. ORACLE 和MS-SQL里的语句如SELECT 的逻辑理念都不一样,大家举一下这方面的例子. 还有一个问题:sysman的帐号与system\sys有什么区别? 一个触发器的比较复杂的问题 求高手帮我查看一下我的Oracle语句有什么地方错误,有点麻烦 修改表空间数据文件的大小的问题? 日期问题:如何查询该天的数据 请问如何设置sqlj的路径 请问能否在pl\sql中执行exp备份命令?
tab 好像 是 9where tab_str = chr(9)chr() 是将 ascii 码转换成 字符
ascii() 是 将字符转换成ascii码
----------
32SQL> select ascII('
2 ') from dual; ASCII('')
----------
10SQL> select chr(13) from dual;C
-
SQL> select 'tab ' from dual where instr('tab ' ,' ')>0;'TAB
----
tabSQL> select 'enter'||chr(10)||'enter' from dual
2 where instr('enter'||chr(10)||'enter',chr(10))>0;'ENTER'||CH
-----------
enter
enter
SQL> select'awofnaweo'||chr(10)||'dfwef' from dual
2 where instr('awofnaweo'||chr(10)||'dfwef',chr(10))>0;'AWOFNAWEO'||CH
---------------
awofnaweo
dfwef
SQL> select 'awofnaweo'||chr(13)||'dfwef' from dual
2 where instr('awofnaweo'||chr(13)||'dfwef',chr(13))>0;'AWOFNAWEO'||CH
---------------
awofnaweo
dfwefSQL>
----------
32SQL> select ascII('
2 ') from dual; ASCII('')
----------
10SQL> select chr(13) from dual;C
-
SQL> select 'tab ' from dual where instr('tab ' ,' ')>0;'TAB
----
tabSQL> select 'enter'||chr(10)||'enter' from dual
2 where instr('enter'||chr(10)||'enter',chr(10))>0;'ENTER'||CH
-----------
enter
enter
SQL> select'awofnaweo'||chr(10)||'dfwef' from dual
2 where instr('awofnaweo'||chr(10)||'dfwef',chr(10))>0;'AWOFNAWEO'||CH
---------------
awofnaweo
dfwef
SQL> select 'awofnaweo'||chr(13)||'dfwef' from dual
2 where instr('awofnaweo'||chr(13)||'dfwef',chr(13))>0;'AWOFNAWEO'||CH
---------------
awofnaweo
dfwefSQL>
----------
32SQL> select ascII('
2 ') from dual; ASCII('')
----------
10SQL> select chr(13) from dual;C
-
SQL> select 'tab ' from dual where instr('tab ' ,' ')>0;'TAB
----
tabSQL> select 'enter'||chr(10)||'enter' from dual
2 where instr('enter'||chr(10)||'enter',chr(10))>0;'ENTER'||CH
-----------
enter
enter
SQL> select'awofnaweo'||chr(10)||'dfwef' from dual
2 where instr('awofnaweo'||chr(10)||'dfwef',chr(10))>0;'AWOFNAWEO'||CH
---------------
awofnaweo
dfwef
SQL> select 'awofnaweo'||chr(13)||'dfwef' from dual
2 where instr('awofnaweo'||chr(13)||'dfwef',chr(13))>0;'AWOFNAWEO'||CH
---------------
awofnaweo
dfwefSQL>
select * from table_name where column_name like '%\%%' escape '\';