Oracle SQL/PLSQL
文章平均质量分 79
pengpenglin
这个作者很懒,什么都没留下…
展开
-
存储过程编写经验和优化措施
一、适合读者对象:数据库开发程序员,数据库的数据量很多,涉及到对SP(存储过程)的优化的项目开发人员,对数据库有浓厚兴趣的人。 二、介绍:在数据库的开发过程中,经常会遇到复杂的业务逻辑和对数据库的操作,这个时候就会用SP来封装数据库操作。如果项目的SP较多,书写又没有一定的规范,将会影响以后的系统维护困难和大SP逻辑的难以理解,另外如果数据库的数据量大或者项目对SP的性能要求很,就会遇到优转载 2006-05-02 23:30:00 · 1641 阅读 · 1 评论 -
9- 最佳实践
1.Exists比Distinct更加有效:The DISTINCT keyword used in a SELECT clause eliminates duplicate rows in the result set. To eliminate those duplicates, Oracle performs a sort, and that sort requires time and原创 2007-08-14 20:40:00 · 1266 阅读 · 0 评论 -
4- 子查询
1.子查询的概念:A subquery is a SELECT statement that is nested within another SQL statement. For the purpose of this discussion, we will call the SQL statement that contains a subquery the containing s原创 2007-08-14 20:26:00 · 3530 阅读 · 0 评论 -
3- 分组操作
1.聚集函数(Aggregate Functions)语法: aggregate_function([DISTINCT | ALL] expression) 2.NULL和聚集函数: A.COUNT(Column_Name) ignores NULLs, whereas COUNT(*) doesnt.The reason COUNT(*) doe原创 2007-08-14 20:22:00 · 1509 阅读 · 0 评论 -
2- 连接
1.JOIN的基本概念:A join is a SQL query that extracts information from two or more tables or views. When you specify multiple tables or views in the FROM clause of a query, Oracle performs a join, linking r原创 2007-08-14 20:15:00 · 1566 阅读 · 0 评论 -
8- Advanced Analytic SQL(高级分析函数)
1.Analytic SQL OverviewThe types of queries issued by Decision Support Systems (DSS) differ from those issued against OLTP systems.Queries such as these are staples(来源于) of DSS, and are used by m原创 2007-08-14 20:39:00 · 1675 阅读 · 0 评论 -
6- Hierachical Querys(级联查询)
relational database is based upon sets, with each table representing a set. However, there are some types of information that are not directly amenable to the set data structure. Think, for example原创 2007-08-14 20:33:00 · 2058 阅读 · 0 评论 -
1- Where子句
1.Between…And子句:When using BETWEEN, make sure the first value is the lowest of the two values provided. While "BETWEEN 1 AND 10" and "BETWEEN 10 AND 1" might seem logically equivalent, specifying原创 2007-08-14 20:06:00 · 1574 阅读 · 0 评论 -
7- Decode和Case
1.DECODE, NVL, and NVL2简介:These functions are used to make decisions based on data values within an SQL statement without resorting(求助) to a procedural language like PL/SQL DECODE和NVL、NVL2函数语原创 2007-08-14 20:35:00 · 1738 阅读 · 0 评论 -
6- 集合运算
1.集合运算简介:There are situations when we need to combine the results from two or more SELECT statements. SQL enables us to handle these requirements by using set operations. The result of each SELEC原创 2007-08-14 20:30:00 · 2799 阅读 · 1 评论 -
5- 日期操纵
1.Oracle内在的时间存储格式: Oracles DATE datatype holds date as well as time information. Regardless of the date format we use, Oracle stores dates internally in one standard format. Internal to the d原创 2007-08-14 20:28:00 · 1716 阅读 · 0 评论 -
Oracle PL/SQL语言基础
Oracle PL/SQL语言基础PL/SQL是ORACLE对标准数据库语言的扩展,ORACLE公司已经将PL/SQL整合到ORACLE 服务器和其他工具中了,近几年中更多的开发人员和DBA开始使用PL/SQL,本文将讲述PL/SQL基础语法,结构和组件、以及如何设计并执行一个PL/SQL程序。 PL/SQL的优点 从版本6开始PL/SQL就被可靠的整合到ORACLE中了,一旦掌握PL/S转载 2006-05-02 23:20:00 · 7858 阅读 · 0 评论 -
%rowtype的几个注意点
一、%rowtype只是指明引用的记录的类型,但不保证NOT NULL约束我们知道使用%type和%rowtype可以分别指定引用的字段、记录类型,但其中有一个特别需要注意的地方:%type和%rowtype都不保证NOT NULL约束。例如:DECLARE my_empno emp.empno%TYPE; --emp.empno should not be null ...BEGIN原创 2007-10-26 22:34:00 · 11391 阅读 · 1 评论