ITPub博客

周六早上请示了上司，[@more@]说一个会议可去可不去，便将这事儿放在了一边儿。周六中午与家人一块儿饮酒，兴致一高，不能自控，在岳父家睡到晚上10点，醒来时什么事都耽误了，上司的上司的电话都漏了，后悔呀！以后要控制自己，情商太低了。

偶然的机会需要接触MySQL,一番较量下来，倒也顺利，利用周未整理了一下，摘录一些内容如下：[@more@]如何安装和配置？在mysql网站上注册用户wworacle@gmail.com/oracle下载5.0.37-community版本的非安装包，我是为了省事，才下载的非安装版并解压到c:mysql1 修改c:windowsmy.ini,指明basedir和datadir# set basedir to your installation pathbasedir=c:/mysql# set datadir to the location of your data directory# datadir=E:/mydata/data 如果把数据库放到非basedir/data目录下需要设置此参数，我准备把税局的库拷到默认目录下，所以没

安装、配置、导出XML数据[@more@]由于工作需要，今天下载安装了MYSQL 503，并将latin1字符集数据导出为XML文件，以向oracle导入， 中间有备注字段类型，以BASE64压缩。具体内容如下:

(无技术内容)[@more@]1 目标明确(业务需求性能需求测试目标)2 过程清晰(测试计划测试案例) 3 检验结果(分析报告) 4 流程改进(问题解决报告书) 5 全员重视(测试参预人员与角色定位) 性能测试多数使用LoadRunder,而对单机软件的功能性测试使用早期的winruner或现在的QTP(Quick Test Professional)进行测试。LoadRunder基于协议，而WinrunerQTP基于GUI. 负载测试是以满足需求为目的，而压力测试是以扩展需求为目的。

小小寰球，有几个苍蝇碰壁。嗡嗡叫，几声凄厉，几声抽泣。蚂蚁缘槐夸大国，蚍蜉撼树谈何易。正西风落叶下长安，飞鸣镝。多少事，从来急；天地转，光阴迫。一万年太久，只争朝夕。四海翻腾云水怒，五洲震荡风雷激。要扫除一切害人虫，全无敌。[@more@]

http://wworacle.blog.163.com星期天出去照了几张相,发在163的BLOG上[@more@]

处理一个查询语句的三个阶段以及相关后台进程的简单介绍[@more@]sql之28 sql的执行 处理一个查询语句的三个阶段第一阶段：Parse: Search for identical statement in the shared pool Check syntax, object names, and privileges Lock objects used during parse Create and store execution plan第二阶段：Execute: Identify rows selected第三阶段：Fetch: Return rows to user process 对shared pool的理解The shared pool has two primary components：Library cache and Data dictionary cache在shared pool中主要有两种区域：一

Writing Advanced Scripts时需要注意的细节[@more@]1 在使用SQL输出SQL之前，需要注意的问题是以下设置SQL> set echo offSQL> set feedback offSQL> set pagesize 0SQL> select 'drop table '||object_name|| ';'……..否则会出现headfeedback等不需要的内容等价的操作SQL> set echo off feedback off heading off 2 关于默认的输出路径如果是从CMD命令行启动的SQLPLUS，则输出在启动时所在目录；如果是使用sqlplus快捷方式启动的sqlplusw ，则输出在D:oracleora92bin;也与启动命令时所在目录一致。 Char(10) 换行符 3 定义

行编辑命令及文件操作命令,在没有PLSQL或TOAD图形工具的情况下,就靠它混了[@more@]行编辑命令Command DescriptionA[PPEND] text Adds text to the end of the current lineC[HANGE] / old / new Changes old text to new in the current lineC[HANGE] / text / Deletes text from the current lineCL[EAR] BUFF[ER] Deletes all lines from the SQL bufferDEL Deletes current lineDEL n Deletes line nDEL m n Deletes lines m to n inclusiveI[NPUT] Inserts an indefinite number of linesI[NPUT] text Inserts a line consisting of t

前面已经把建库的过程给讲过了，这里对备库关闭的情况做一个补充[@more@]当我把备库的主机关掉后，发生了以下情况：alert.log文件中出现Errors in file d:oracleadmingswebbdumpgsweb_arc0_2976.trc:ORA-12535: TNS:operation timed out...Wed Apr 11 16:00:33 2007Errors in file d:oracleadmingswebbdumpgsweb_arc0_2976.trc:ORA-16058: standby database instance is not mounted当我把备库启来以后Wed Apr 11 16:06:33 2007ARC1: Begin FAL archive (thread 1 sequence 124 destination gsweb2)Wed Apr 11 16:06:33 2007ARC0: Begin F

根据TOM的提示,使用外部表来查看数据库的警告日志文件[@more@]conn system/managergrant create any directory to scott;grant drop any directory to scott;conn scott/tigercreate or replace directory data_dir as 'D:oracleadmingswebbdump';-- grant read,write on directory data_dir to scott ;CREATE TABLE alert_log( text_line varchar2(255))ORGANIZATION EXTERNAL( TYPE ORACLE_LOADER DEFAULT DIRECTORY DATA_DIR ACCESS PARAMETERS ( records delimited by newline fields REJECT ROW

Oracle 9i Extensions to DML and DDL Statements-- 大纲：Use the following types of multitable inserts?Unconditional INSERT?Pivoting INSERT?Conditional ALL INSERT?Conditional FIRST INSERT:) Create and use external tables:) Name the index at the time of creating a primary key constraint[@more@]unconditional insert: all into_clauseThe oracle server executes each insert_into_clause once for each row returned by the subquery.在使用all关键字时，oracle将执行每个insert，不进行排除SQL> insert all 2 i

灵格斯lingoes又小又方便[@more@]有需要的兄弟可以上网搜,也可以找我要

使用分级获取，生成树状报表(use hierarchical queries to create tree-structured reports)[@more@]--语法 SELECT [LEVEL], column, expr...FROM table[WHERE condition(s)][START WITH condition(s)][CONNECT BY PRIOR condition(s)];WHERE condition: expr comparison_operator expr--第一种方式：Walking the Tree: From the Bottom UpSQL> select employee_id,last_name,job_id,manager_id 2 from employees 3 start with employee_id=101 4 connect by prior manager_id=employee_id;EMPLOYEE_ID LAST_NAME JOB_ID MA

Advanced Subqueries[@more@]sql之20高级查询Advanced Subqueries--'嵌套子查询与关联子查询的区别'Nested Subquery Execution:) The inner query executes first and finds a value.:) The outer query executes once, using the value from the inner query.Correlated Subquery Execution:) Get a candidate row (fetched by the outer query).:) Execute the inner query using the value of the candidate row.:) Use the values resulting from the inner query to qualify or disqualify the candidate.:) Repeat until no candida

Advanced Subqueries'内联视图的应用'[@more@]'查询每个部门中大于本部门平均工资的员工名单及本部门的平均工资'SQL> select a.last_name,a.salary,a.department_id,b.salavg 2 from employees a,(select department_id,avg(salary) salavg 3 from employees 4 group by department_id) b 5 where a.department_id=b.department_id 6 and a.salary>b.salavg;LAST_NAME SALARY DEPARTMENT_ID SALAVG---------- ---------- ------------- ----------Hartstein 13000 20 9500Mourgo

Concatenated Groupings Example[@more@]SQL> select department_id,job_id,manager_id,sum(salary)2 from employees3 group by department_id,rollup(job_id),cube(manager_id);DEPARTMENT_ID JOB_ID MANAGER_ID SUM(SALARY)------------- ---------- ---------- -----------SA_REP 149 700010 AD_ASST 101 440020 MK_MAN 100 1300020 MK_REP 201 600050 ST_MAN 100 580050 ST_CLERK 124 1170060 IT_PROG 102 900060 IT_PROG 103 4800080 SA_MAN 100 1050080 SA_REP 149 1960090 AD_PRES 2400090 AD_VP 100 34000110 AC_MGR 101 12000

复合列 group by rollup(department_id,(job_id,manager_id));[@more@]SQL> select department_id,job_id,manager_id,sum(salary)2 from employees3 group by rollup(department_id,(job_id,manager_id));DEPARTMENT_ID JOB_ID MANAGER_ID SUM(SALARY)------------- ---------- ---------- -----------SA_REP 149 7000700010 AD_ASST 101 440010 440020 MK_MAN 100 1300020 MK_REP 201 600020 1900050 ST_MAN 100 580050 ST_CLERK 124 1170050 1750060 IT_PROG 102 900060 IT_PROG 103 4800060 5700080 SA_MAN 100 1050080 SA_REP 149

ROLLUP等在GROUP BY中的使用[@more@]ROLLUP在GROUP BY中的使用SELECT department_id, job_id,SUM(salary)FROM employeesWHERE department_id < 60GROUP BY ROLLUP(department_id, job_id);DEPTNO JOB AVG(SAL)------- --------- ----------10 CLERK 130010 MANAGER 245010 PRESIDENT 500010 2916.6666720 CLERK 95020 ANALYST 300020 MANAGER 297520 1968.7530 CLERK 95030 MANAGER 285030 SALESMAN 140030 1566.6666740405050 ANALYST 300050 30002073.21429结果：除了分组外，还加上按DEPTNO的小计cube在GROUP BY中的使用SQL> /DE

天下事有难易乎？[@more@]天下事有难易乎？为之，则难者亦易矣；不为，则易者亦难矣。人之为学有难易乎？学之，则难者亦易矣；不学，则易者亦难矣。 吾资之昏，不逮人也，吾才之庸，不逮人也；旦旦而学之，久而不怠焉，迄乎成，而亦不知其昏与庸也。吾资之聪，倍人也，吾才之敏，倍人也；屏弃而不用，其与昏与庸无以异也。圣人之道，卒于鲁也传之。然则昏庸聪明之用，岂有常哉！ 蜀之鄙，有二僧：其一贫，其一富。贫者语于富者曰：“吾欲之南海，何如？”富者曰：“子何恃而往？”曰：“吾一瓶一钵足矣。”富者曰：“吾数年来欲买