- 博客(15)
- 收藏
- 关注
原创 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 807
原创 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 新特性八(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 新特性六(数据库维护)
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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人