Oracle单行函数练习 1. 选择部门30中的所有员工 Select * from emp where deptno=30 2. 列出所有办事员的姓名、编号和部门编号 Select empno,ename,deptno from emp where job='CLERK'; 3. 找出佣金高于薪金的员工 Select * from emp where comm>sal; 4. 找出佣金高于薪金的60%的员工 Select * from emp where comm>sal*0.6
练习题 1. 列出所有员工的姓名、部门名称和工资 Select e.ename,d.dname,e.sal From emp e,dept d Where e.deptno=d.deptno; 2. 列出所有部门的详细信息和部门人数 Select d.deptno,d.dname, d.loc,count(e.empno) From emp e,dept d Where e. deptno(+)=d.deptno Group by d.deptno,d.dname,d.loc; 3. 列出所有
sum(sal) over (partition by deptno order by ename) 按部门“连续”求总和 sum(sal) over (partition by deptno) 按部门求总和 sum(sal) over (order by deptno,ename) 不按部门“连续”求总和 sum(sal) over () 不按部门,求所有员工总和,效果等同于sum(sal)
http://ecx.images-amazon.com/images/I/51NG5mF-SAL._SS500_.jpgby Russ OlsenAddison-Wesley Professional Ruby SeriesObie Fernandez, Series EditorThe Addison-Wesley Professional Ruby Series provides readers with practical, people-oriented, and in-depth
C# 编程连接oracle数据库方法 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.OracleClient; namespac
INSERT INTO table_name (column1,column2,...) values ( value1,value2, ...); 示例 insert into emp (empno,ename) values(9500,'AA'); 把 一个表中的数据插入另一个表中 INSERT INTO 示例 create table a as select * from emp where 1=2; insert into a select * from emp where sal
-- 首先,以超级管理员的身份登录oracle sqlplus sys/bjsxt as sysdba --然后,解除对scott用户的锁 alter user scott account unlock; --那么这个用户名就能使用了。 --(默认全局数据库名orcl) 1、select ename, sal * 12 from emp; --计算年薪 2、select 2*3 from dual; --计算一个比较纯的数据用dual表 3、select sysdate from dual;