lilin745997
- 浏览: 29485 次
- 性别:
- 来自: 北京
-
最新评论
文章列表
12.1 子程序
运行在服务器端，快；简化应用程序开发；提高数据库安全
12.1.1 过程
1．定义过程
例12.1_1
以系号为参数，输出该系的平均工资、最高工资、最低工资
CREATE OR REPLACE PROCEDURE display_teacher(v_no teachers.department_id%TYPE)
AS
v_wage teachers.wage%TYPE;
v_maxwage teachers.wage%TYPE;
v_minwage teachers.wage%TYPE ...
11.1.2 在SELECT语句中使用记录1．使用%ROWTYPE属性定义记录例11.1_1SET SERVEROUTPUT ON DECLARE v_student Students%ROWTYPE; BEGIN SELECT * INTO v_student FROM Students WHERE student_id = 10201; DBMS_OUTPUT.PUT_LINE ('姓名 性别 专业'); DBMS_OUTPUT.PUT_LINE (v_student.name||' '||v_ ...
- 2009-12-03 17:08
- 浏览 823
- 评论(0)
10.1 PL/SQL语言基础
10.1.1 PL/SQL块简介例10.1_1 最简单的PL/SQL块A bare minimum anonymous block: SET SERVEROUTPUT ON BEGIN DBMS_OUTPUT.PUT_LINE('This a minimum anonymous block'); END;/例10.1_2
DECLARE v_sname VARCHAR2(10); BEGIN SELECT name INTO v_sname FROM Students W ...
- 2009-12-03 17:08
- 浏览 1130
- 评论(0)
9.1 数据控制语言（DCL）9.1.1 数据库权限3．用户（1）建立用户Creating a User例9.1_1 建立用户wang并指定口令为officeCONNECT system/huali1963CREATE USER wang IDENTIFIED BY office;CONNECT wang/office
例9.1_2 建立用户xiaoli并指定口令为finance。CONNECT system/huali1963CREATE USER xiaoli IDENTIFIED BY finance DEFAULT TABLESPACE users TEMPORARY TA ...
- 2009-12-03 17:08
- 浏览 1031
- 评论(0)
8.1 数字函数8.1.1 数字函数概述1．ABS(x)例8.1_1 求88和-88的绝对值。SELECT ABS(88), ABS(-88) FROM dual;
2．ACOS(x)例8.1_2 求ACOS(1)和ACOS(-1)的值。SELECT ACOS(1), ACOS(-1) FROM dual;
3．ASIN(x)例8.1_3 求ASIN (0.5)和ASIN (-0.5)的值。SELECT ASIN (0.5), ASIN (-0.5) FROM dual;
4．ATAN(x)例8.1_4 求ATAN (5)和ATAN (-5)的值。SELECT ATAN (5), AT ...
- 2009-12-03 17:07
- 浏览 955
- 评论(0)
7.1 数据操作语言（DML）7.1.1 插入数据（INSERT）例7.1_1 INSERT INTO Students VALUES(10138,10101,'王一', '男', '26-12月-1989','计算机');
例7.1_2 INSERT INTO Students (student_id,monitor_id,name,dob,sex,specialty) VALUES(10139,10101,'王二', '20-12月-1989', '男','计算机');
例7.1_3 INSERT INTO Teachers (teacher_id,name,department ...
- 2009-12-03 17:07
- 浏览 780
- 评论(0)
6.1 内连接查询
6.1.1 简单内连接
1．相等连接
例6.1_1
SELECT teacher_id, name, department_name
FROM Teachers, Departments
WHERE Teachers.department_id = Departments.department_id;
6.1.2 复杂内连接
1．使用筛选条件
例6.1_8
SELECT s.student_id, s.name, count(*) AS 所修课程门数
FROM Students s, Students_grade sg ...
- 2009-12-03 17:06
- 浏览 631
- 评论(0)
5.1 子查询
5.1.1 单行子查询
1．在WHERE 子句中使用子查询例5.1_1
工资低于平均工资的教师
SELECT * FROM Teachers
WHERE wage <
(SELECT AVG(wage)
FROM Teachers);
例5.1_2
和王天仪同专业的学生
SELECT * FROM Students
WHERE specialty =
(SELECT specialty FROM Students
WHERE name = '王天仪');
2．在HAVING子句中使 ...
- 2009-12-03 02:37
- 浏览 1149
- 评论(0)
4.1 简单查询
4.1.1 查询指定列
例4.1_1 教师（姓名，职称，工资，参加工作时间）
SELECT name, title, wage, hire_date
FROM teachers;
例4.1_3 学生（*）不可以改变列的顺序
SELECT * FROM students;
例4.1_6 学生（专业）带DISTINCT关键字
SELECT DISTINCT specialty FROM students;
4.1.2 改变输出
SELECT name AS "姓名" ...
- 2009-12-03 00:45
- 浏览 943
- 评论(0)
数据控制语言DCL
系统权限：
create session,create sequence,create synonym;create table,create any table,drop table,drop any table;create procedure,create any procedure;create user,drop user;create view
对象权限：
select,insert,update,delete,execute
创建用户：
create user wang identified by office;
create ...
- 2009-12-02 15:48
- 浏览 1598
- 评论(0)
数据操作语言DML
操作数据库时注意数据库的完整性
insert into students
values(1001,1011,'张三','男',26-12月-1989','计算机');
insert into teachers(teacher_id,name,department_id)
values(10001,'张三',101);
insert into students_computer
(select * from student
where specialty='计算机');
update students set dob='16-12月 ...
- 2009-12-01 16:34
- 浏览 1036
- 评论(0)
一、安装JDK
运行JDK 5.0安装程序jdk-1_5_0_06-windows-i586-p.exe，安装过程中所有选项保持默认；最后配置JDK的环境变量：在“我的电脑”上点右键—>“属性”—>“高级”—> “环境变量(N)”。
新建系统变量JAVA_HOME：C:\Program Files\Java\jdk1.5.0_06 新建系统变量CLASSPATH：.;%JAVA_HOME%\lib;（注意：点号表示当前目录，不能省略） 在系统变量Path的值的前面加入以下内容：%JAVA_HOME%\bin;(注意:这里的分号不能省略) 到这里，JDK安装 ...
- 2009-11-29 17:22
- 浏览 3164
- 评论(0)