- 博客(7)
- 收藏
- 关注
Xargs用法详解(原创)
简介之所以能用到这个命令,关键是由于很多命令不支持|管道来传递参数,而日常工作中有有这个必要,所以就有了xargs命令,例如:这个命令是错误的find /sbin -perm +700 |ls -l这样才是正确的find /sbin -perm +700 |xargs ls -l xargs 可以读入 stdin 的资料,并且以空白字元或断行字元作为分辨,将 stdin 的资料分隔...
2013-09-29 19:46:57 3956 1
Oracle 11g SQL Repair Advisor(原创)
SQL Repair AdvisorWhen a SQL statement failure results in a critical error, the new SQL Repair Advisor analyzes the statement and in many cases recommends a patch to fix the failed statement. The ...
2013-09-11 16:27:18 128
Oracle 11g Health Monitor(原创)
Health MonitorOracle Database 11g includes a new framework called the Health Monitor, which runs diagnostic checks in the database. The data base automatically runs Health Monitor checks in response...
2013-09-08 21:05:59 160
Oracle 11g Automatic Diagnostic Repository(原创)
Automatic Diagnostic RepositoryThe automatic diagnostic repository tracks all problems and incidents that occur in the database. The ADR is a file-based repository that you create for storing tradit...
2013-09-08 19:35:46 197
原创 Oracle数据类型记录
如果你要做循环的记数器,可以使用pls_integer. pls_interger,binary_integer,number中,pls_integer速度最快。Binary_Integer 与 Pls_Integer 都是整型类型.概述在ORACLE8中定义了:标量(SCALAR)、复合(COMPOSITE)、引用(REFERENCE)和LOB四种数据类型,下面详细介绍它们的特性。标量(SCA...
2013-09-05 22:51:57 74
原创 oracle分析函数
oracle分析函数--SQL*PLUS环境--1、GROUP BY子句--CREATE TEST TABLE AND INSERT TEST DATA.create table students(id number(15,0),area varchar2(10),stu_type varchar2(2),score number(20,2));insert into students valu...
2013-09-03 22:10:44 64
原创 SQL in condition expresssion
Expression Lists An expression list is a combination of other expressions.expression_list::=Description of the illustration expression_list.gifExpression lists can appear in comparison and m...
2013-09-03 22:03:04 118
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人