本月博客排行
-
第1名
青否云后端云 -
第2名
vipbooks -
第3名
e_e - kingwell.leng
- lemonhandsome
- silverend
- jveqi
- tanling8334
- xiangjie88
年度博客排行
-
第1名
青否云后端云 -
第2名
zw7534313 -
第3名
大家都说我很棒 - liyihz2008
- wy_19921005
- gengyun12
- hbxflihua
- e_e
- luxurioust
- dbagirl
- zysnba
- robotmen
- Alsmile
- gaozzsoft
- jywhltj
- cpongo1
- leslie26
- qepwqnp
- 解宜然
- zhangdaiscott
- cuityang
- sichunli_030
- gashero
- fantaxy025025
- vipbooks
- gdpglc
- ssydxa219
- wallimn
- ranbuijj
- 淡看人生
- javashop
- jickcai
- hanbaohong
- johnsmith9th
- appalese
- gaojingsong
- weiyides
- zhangyi0618
- java-007
- AVI
- laiyangdeli
- xpenxpen
- liunancun
- 龙哥IT
- conkeyn
- nychen2000
- lyndon.lin
- ouanui
- jveqi
- panshunchang
最新文章列表
《Pro Oracle SQL》Chapter7 -- 7.7Extending Reports with GROUPING()
7.7Extending Reports with GROUPING() 用GROUPING()函数扩展报告 (page209)
Another use of GROUPING() is in the HAVING clause, where it can be used to control which aggregation levels appear in the out ...
《Pro Oracle SQL》Chapter7 --7.6Eliminate NULLs with the GROUPING() Function
7.6 Eliminate NULLs with the GROUPING() Function 用GROUPING()函数消除NULL值
(page 207)
There seems to be a problem with the output from the new query seen in Listing 7-12. While the
numbers mat ...
《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.5Putting CUBE To Work
7.5 Putting CUBE to work CUBE实战
(page 201)
When teaching us a new word in fourth grade English class, Mrs. Draper would say, “Now use it in a sentence.” ...
《Pro Oracle SQL》Chapter7 -- 7.3--7.4CUBE Extension to GROUP BY
7.3“New” GROUP BY Functionality “新”GROUP BY 功能
(page 197)
At times, it’s necessary to write SQL that appears as unruly as the convoluted example in Listing 7-5 so that the desire ...
《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.2HAVING Clause
7.2 HAVING Clause HAVING 子句 (page 195)
Results generated by GROUP BY may be restricted by the criteria found in the HAVING clause. The HAVING clause is quite versatile, resembling the WHE ...
《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.1Basic GROUP BY Usage
Chapter 7 Advanced Grouping 第七章 高级分组
Jared Still (page 213)
The GROUP BY clause is a venerable member of the SQL statement family. After learning basic SELECT statements, it is one of ...
oracle 权限相关命令
查看某个用户被授予的角色
select * from dba_role_privs where grantee='SCOTT';
查询某个角色具有的权限(一看到这句话就要想到权限有系统权限system privilege与对像 object privilege)
select * from ROLE_SYS_PRIVS where ROLE='CONNECT'
select * from R ...
Oracle EBS标准错误信息如何追踪 (Debug)
调用EBS标准API的时候,可能会返回一些让人看不懂的错误,比如最近我在开发rcv_transaction_interface的时候,数据卡在接口表里没有过去,但是返回的错误令人费解。
例如如下两个错误就让人费解:
*******************
Error: derive_vendor_rcv_line_qty-098: 1
Cause: A SQL error has occur ...
Oracle DBA在新环境下必须了解的事情
在这里,不谈那些大的方面,比如了解整个IT环境整体情况,假设你已经知道了这些,接下来需要面对的就是这些一个个活生生的database了.这里总结了一些一般的思路来面对一个全先的database,从而快速了解你面对的环境概要.
这也不是教科书,只是一些心得和体会,对于这种问题,每个人的认识的角度是不一样的.欢迎大家继续补充完善.
1、先要了解当前的Oracle数据库的版本和平台和相关信息
这个很 ...