《数据库管理及应用》课程电子教案（PPT课件）3.04 QL and DML in SQL SQL中的查询语言和现代语言

一、PL/SQL概述 二、PL/SQL基础 三、控制结构 四、游标 五、异常处理 六、存储子程序 七、包 八、触发器

SQL Server 2000 实用教程_第4章 SQL Server 2000数据库创建与管理

SQL Server 2000 实用教程_第5章 SQL Server 2000数据库表的创建和管理

SQL Server 2000 实用教程_第12章SQL Server 2000数据库的安全性管理

查询课程信息,根据用户需要修改某些元组的 TEACHER字段 EXEC SQL BEGIN DECLARE SECTION /*说明宿主变量dept, deptname,Hcno, CName, TEacher,New Teacher * EXEC SQL END DECLARE SECTION gets(dept); deptname=)” strcat(deptname, dept) strcat(deptname, 1%1)

Accessing SQL From a Programming Language Functions and Procedural Constructs Triggers Recursive Queries Advanced Aggregation Features OLAP

▪ Accessing SQL From a Programming Language ▪ Functions and Procedures ▪ Triggers ▪ Recursive Queries ▪ Advanced Aggregation Features

Join Expressions Views Transactions Integrity Constraints SQL Data Types and Schemas Authorization

Overview of The SQL Query Language Data Definition Basic Query Structure Additional Basic Operations Set Operations Null Values Aggregate Functions Nested Subqueries Modification of the Database