如题:查询列名中以拼音字母a开头的记录
with tt as
(
select '安' name from dual union all
select '被' from dual union all
select '走' from dual union all
select '神' from dual union all
select '哎' from dual
)
select * from tt where substr(name,1,1) between '阿' and '澳';SQL> with tt as
2 (
3 select '安' name from dual union all
4 select '被' from dual union all
5 select '走' from dual union all
6 select '神' from dual union all
7 select '哎' from dual
8 )
9 select * from tt where substr(name,1,1) between '阿' and '澳'
10 ;
NAME
--------------------------------
安
哎
现在我的疑问是:
1.为什么是between '阿' and '澳'?
2.为什么结果为“安”和“哎”?望高手帮忙解答下!
with tt as
(
select '安' name from dual union all
select '被' from dual union all
select '走' from dual union all
select '神' from dual union all
select '哎' from dual
)
select * from tt where substr(name,1,1) between '阿' and '澳';SQL> with tt as
2 (
3 select '安' name from dual union all
4 select '被' from dual union all
5 select '走' from dual union all
6 select '神' from dual union all
7 select '哎' from dual
8 )
9 select * from tt where substr(name,1,1) between '阿' and '澳'
10 ;
NAME
--------------------------------
安
哎
现在我的疑问是:
1.为什么是between '阿' and '澳'?
2.为什么结果为“安”和“哎”?望高手帮忙解答下!
解决方案 »
- 不用PLSQL,直接敲命令怎么导出SQL语句查询出来的结果呢
- linux下root用户连接oracle提示没有权限:insufficient privileges
- oracle 中删除表空间如何同时删除数据文件,用脚本实现
- 求助,java连接oracle时出错!!!
- 我的ORACLE查询语句为什么老提示表名无效呀,在线等
- 紧急问题求救
- 哪边可以下到oracle high-performance sql tuning这本书的原版?
- 急求大神帮忙,小弟快顶不住了
- 【紧急求助!】oracle触发器中如何获取某一个表的insert和delete语句操作失败
- 求各位老师们给个查询语句实现下面的要求,谢谢!
- 动态游标ref cursor
- oracle 数据类型问题
select ascii('被') a,'被' x from dual union all
select ascii('走') a,'走' x from dual union all
select ascii('神') a,'神' x from dual union all
select ascii('哎') a,'哎' x from dual union all
select ascii('澳') a,'澳' x from dual union all
select ascii('阿') a,'阿' x from dual
order by x应该根据ascii排序的。
where条件采用的是ascii去判断的 这里不是字符串‘阿’和‘澳’,而是他们的ASCII值,因为是between and ,
ASCII('安')
-----------
45234
SQL> select ascii('哎') from dual;
ASCII('哎')
-----------
45221
SQL> select ascii('阿') from dual;
ASCII('阿')
-----------
45218
SQL> select ascii('澳') from dual;
ASCII('澳')
-----------
45252
SQL>