1.查询语句
select *from emp;
select *from dept;
select * from salgrade;
select ename ,sal *12 from emp;/*年薪*/
select 2*3 from emp;/*计算表达式*/
select ename ,sal*12 as "anuual sal" from emp;/* ""保持大小写,年薪*/
select 2*3 from dual;/*用于计算*/
select ename || sal from emp;/*字符串连接||*/
select distinct deptno from emp ;/*消除重复行*/
select distinct deptno ,job from emp;
select *from emp where deptno = 10;
select *from emp where ename = 'clerk';
select *from emp where deptno <> 10;
select ename , sal from emp where sal between 800 and 1500;
select ename , sal from emp where sal >-800 and sal <= 1500;
select ename , sal, comm from emp where comm is null;
select ename , sal, comm from emp where comm is not null;
select ename , sal, comm from emp where ename in ('king', 'smith','abc');
select ename , sal, hiredate from emp where hiredate > '20-2-1981';
select ename
个人的尚学堂数据库oracle笔记(1)
最新推荐文章于 2023-12-07 11:18:46 发布
这篇博客详细介绍了Oracle数据库的基本查询语句,包括选择特定字段、计算表达式、字符串连接、去除重复行、条件筛选、排序及日期转换等功能。同时,也涵盖了数据插入操作和表的创建,为读者提供了丰富的数据库操作示例。
摘要由CSDN通过智能技术生成