ORACLE 11G DBA course given in English.
This course is aim to train the great DBA with good English speaking.
In recent years, more demands of Oracle DBA, but most of Senior DBAs are required to speak good English.
English has become the great barrier for more peoples in their career development, you must have the deep feeling about it if you work in the foreign company.
In IT English course, Learning IT knowledge in English just like killing two birds with one stone, not only it can help you to master of Professional IT English terminologies as soon as possible, but it can help you to take the reins of IT technology, enjoy yourself to listen to the Professional English IT lectures.
Therefore, Oracle 11G DBA courses come to you at the right time, this is for those who has the basic English background and willing to be the Professional Oracle DBA.
Requirements: good English listening, no need of Database or relevant computer experience.
First 10 registers could get the discount, please contact me as soon as you can.
Of course, you can cancel your membership at any time. There is no risk. Try my VIP Program for you and speak English confidently, grow more successful and become a true DBA.
Learn path:
1.The SQL introuduction
2.PLSQL introuduction
3.Database Architecture
4.Backup and Recovery
5.Performance Tuning
6.High availability
And also provide the On demand course per the customer requirements.
For more information, please contact me by MSN
baiwentao@hotmail.com
相关文档：
本视图包括Shared pool中SQL语句的完整文本，一条SQL语句可能分成多个块被保存于多个记录内。
V$SQLTEXT中的常用列
HASH_VALUE：SQL语句的Hash值
ADDRESS：sql语句在SGA中的地址
SQL_TEXT：SQL文本。
PIECE：SQL语句块的序号
V$SQLTEXT中的连接列
Column View ......
以上为转载,多数并未验证.
其中,select trunc(sysdate,'dd') from dual,得到的是: 2009-3-23 上午12:00:00 ,与下文并不一样!
oracle trunc()函数的用法
1.TRUNC(for dates)
TRUNC函数为指定元素而截去的日期值。
其具体的语法格式如下：
TRUNC（date[,fmt]）
其中：
date 一个日期值
fmt 日期格式，该日期将 ......
序列(SEQUENCE)是序列号生成器，可以为表中的行自动生成序列号，产生一组等间隔的数值(类型为数字)。其主要的用途是生成表的主键值，可以在插入语句中引用，也可以通过查询检查当前值，或使序列增至下一个值。
创建序列需要CREATE SEQUENCE系统权限。序列的创建语法如下：
CREATE SEQUENCE 序列名
[INCREMENT BY n]
[ST ......
1. 创建视图：
CREATE OR REPLACE VIEW SM_V_UNIT_AUTH AS
SELECT T2.UNIT_ID,
T2.SUPER_UNIT_ID,
T1.AUTH_ID,
T1.AUTH_NAME,
T1.A ......
初学linux+oracle，采用的本地虚拟机安装linux的方式，版本是Red Hat 5，唯一跟虚拟机安装其他系统不同的是：定制，选IDE硬盘，否则安装过程提示找不到硬盘失败。
本文重点是Oracle安装过程，版本 10.1.0。
3、安装相关的开发包（rpm包）：
rpm -q binutils co ......
