1. select * fromemp;--选取指定列的内容select job fromemp;select ename,sal fromemp;--条件判断select sal fromempwhere sal=800;--between and 方法select * fromempwhere sal between 2000 and 3000;--嵌套的使用select job from(select * fromempwhere sal between 2000 and 3000);--单列数据的改变select sal+25 fromemp;--用like(模糊)概念 (-一个字符) (%0个或多个字符)select job fromempwhere job like ‘%LE%‘;--从in()里面的数据选出select * fromempwhere comm in(300,500);select sal,sal+25.00 AS saly fromemp;--字符串的连接 AS别名 将job换成taselect empno,empno+25||‘is a‘||job AS ta fromemp;--删除重复行 关键词DISTINCTselect DISTINCT comm fromemp;--用IS NULL 关键字判断为空的情况select * fromempwherecomm IS NULL;select comm fromempwherecomm IS NULL;
二、优先级
1 算术运算符
2 连接符
3 比较符
4 IS [NOT] NULL, LIKE, [NOT] IN
5 [NOT] BETWEEN
6 NOT
7 AND
8 OR
Oracle数据库的基本用法
标签:color 5.0 判断为空 tin from 关键字 class 优先级 取整
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源:http://www.cnblogs.com/xuekai/p/7157132.html