如果获取你梦想的Oracle DBA职位
How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Oracle DBAs commonly earning more than $130,000 and with Oracle superstars earning more than $250,000.
There are two major reasons for higher salaries among Oracle professionals. First, Oracle DBAs manage databases that are worth billions of dollars, and with big responsibilities come big salaries. Second, Oracle’s database is the world’s most robust and flexible in the industry, and it often takes years to learn all of its nuances.
Learn more about how to get an Oracle DBA job
Read about how to get a high-paying Oracle job
Read this three-part series to learn more about becoming an Oracle professional
Oracle Corp. recently published its 2009 Oracle salary survey, which showed the average salary for a DBA is $97,000, with higher salaries among those located in large cities. The salary survey also showed that experience, along with the level of job responsibility, is what makes the biggest difference when it comes to the level of one’s salary.
As a general guideline, a well-qualified Oracle professional, typically someone with a master’s degree, will earn three times his age. For example, a 30-year-old Oracle professional can expect, on average, to make $90,000 per year.
Before we continue, however, a reality check is in order. No company is going to pay you top-dollar as a junior Oracle professional unless you have demonstrated a commitment to professional database management. This commitment is best shown by successfully completing an extensive amount of college coursework. If you don’t possess at least a bachelor’s degree in software engineering, information systems or computer science, you will find it difficul
相关文档：
oracle表空间操作详解
1
2
3作者： 来源： 更新日期：2006-01-04
5
6
7建立表空间
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
索引组织表（IOT）有一种类B树的存储组织方法。普通的堆组织表是以一种无序的集合存储。而IOT中的数据是按主键有序的存储在B树索引结构中。与一般B树索引不同的的是，在IOT中每个叶结点即有每行的主键列值，又有那些非主键列值。
在IOT所对应的B树结构中，每个索引项包 ......
select lower( column_name) ||','||'--'||comments
from user_col_comments c
where c.table_name = upper('acc_fundcap')
SELECT * from USER_TAB_COMMENTS WHERE TABLE_NAME='T_META';
INSERT INTO 表名(字段名1, 字段名2) SELECT 字段名1, 字段名2 from 另外的表名; ......
先看下面的例子:oracle中两个系统表.emp,dept.
example:
1:not exists(not in)
not exists:
这条语句返回select * from scott.dept d where e.deptno=d.deptno and d.deptno=10条件满足的结果集.也就是说,
返回的结果集中不存在d.deptno=10结果集的记录,即emp表中没有dept表中d.deptno=10的记录.
SQL& ......
