- 博客(10)
- 资源 (2)
- 问答 (2)
- 收藏
- 关注
原创 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
原创 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
原创 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
原创 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
原创 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
原创 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
原创 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
原创 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
原创 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
使用Spring对Service层进行测试,无法查询到刚刚插入的记录?
2008-06-19
使用HQL查询Oracle日期字段,报"Invalid number"
2008-05-22
TA创建的收藏夹 TA关注的收藏夹
TA关注的人