2015年05月_夜归人_

原创 SQL基础一

1.greatest ,coalesce,least的用法2.从表中随机返回n条记录 select empno,ename from (select empno,ename from emp order by dbms_random.value()) where rownum3.select * from v where vname like '\_BCE%' ESCAPE '\';

2015-05-26 19:16:27 312

原创 Oracle 11g PL/SQL(基础二)

Understanding Exception With PL/SQLAn exception can be raised: 1.显式 2.隐式An exception can be handled: 通过handler捕获通过调用环境处理第一个不能跳回去第二个可以跳Trapping Non-

2015-05-25 11:23:41 324

原创 Oracle 11g PL/SQL(基础一)

Block Types匿名块是不存储在数据库里的，有名块可以重复调用set serveroutput on declare v_fname varchar2(20); begin select '111' into v_fname from dual; dbms_output.put_line('The result '||v_fname );

2015-05-20 16:05:36 590

原创 oracle10g/11g 新特性十三(数据库复制)

Choosing Database Duplication Techniquescreating a duplicate database for active database duplication (oracle 11g 功能)Duplicating an Active DatabaseDuplicating a Database with a

2015-05-15 14:38:11 806

原创 oracle10g/11g 新特性十二(数据库空间管理)

Database StorageSupporting 4-KB Sector DisksUsing 4-KB Sector DisksSpecifying the Disk Sector SizeTransporting TablespacesConcept:Minimum Compatibility Level

2015-05-14 08:50:30 416

原创 oracle10g/11g 新特性十一(表空间管理)

1231231231231231

2015-05-11 09:22:40 479

原创 oracle10g/11g 新特性十(数据移植)

Moving Data General Architecture

2015-05-09 22:56:55 421

原创 oracle10g/11g 新特性九(数据库诊断)

123123

2015-05-09 13:45:42 405

原创 oracle10g/11g 新特性八(SQL性能调优)

SQL Tuning Advisor:Overview1.Detect stale or missing statistics2.Tune SQL plan (SQL profile)3.Add missing index4. Restructure SQLAutomatic SQL Tuning :OverviewSQL Statement Pro

2015-05-08 23:20:39 456

原创 oracle10g/11g 新特性七(性能维护)

Performance Monitoring23132

2015-05-08 13:50:59 419

原创 oracle10g/11g 新特性六(数据库维护)

Database MaintenanceTerminology1.Automatic Workload Repository(AWR): Infrastructure for data gathering, analysis , and solutions recommendations2.AWR Baseline: a set of AWR snapshots f

2015-05-07 08:40:41 403

原创 oracle10g/11g 新特性五(用Shceduler自动化)

Simplifying Management Tasks1.Performing a series of month-end tasks on the last day of each month2.Runing a dequeue procedure as soon as a message is enqueued3.Replicating table data via mate

2015-05-05 09:24:26 653

原创 oracle10g/11g 新特性四(管理内存)

Buffer CacheUsing Multiple Buffer PoolsShared Pool

2015-05-04 13:44:59 539

原创 oracle10g/11g 新特性二(Flashback Database)

Flashback TechnologyFlashback Database Architecture

2015-05-02 15:22:01 1110

原创 oracle10g/11g 新特性三(Flashback Table)

１１１

2015-05-02 15:21:58 490

夜归人