0cp-047
huangliang0703
这个作者很懒,什么都没留下…
展开
-
ocp-047 natural-join
89. View the Exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.To retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME,the following转载 2014-07-07 20:00:08 · 610 阅读 · 0 评论 -
OCP考题解析_043: 会话时区和ORA_SDTZ环境变量
文章来自:http://m.blog.csdn.net/blog/linwaterbin/8631039 You can set the default session time zone with the ORA_SDTZ environment variable. When users retrieve TIMESTAMP WITH LOCAL TIME ZONE dat转载 2013-10-30 13:25:19 · 729 阅读 · 0 评论 -
oracle :cube rollup
以employees表为例进行说明: 一、如果只是统计不同部门不同岗位的平均工资,直接使用group by 子句: 1 select department_id ,job_id,avg(salary) 2 from employees 3 group by (department_id ,job_id) SQL> / DEPARTMENT_ID JOB原创 2013-11-27 12:30:06 · 613 阅读 · 0 评论 -
ocp-047 delete
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table where in it is crea转载 2014-07-07 20:32:13 · 820 阅读 · 0 评论 -
133. Which three statements are true? (Choose three.)
133. Which three statements are true? (Choose three.) A. Only one LONG column can be used per table. B. A TIMESTAMP data type column stores only time values with fractional seconds. C. The BLO原创 2014-07-13 18:26:44 · 845 阅读 · 0 评论 -
ocp-043
52、You have a read-only tablespace on read-only media. You want to perform. a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the s转载 2014-07-10 22:19:55 · 547 阅读 · 0 评论 -
single-row functions
130. Which three statements are true regarding single-row functions? (Choose three.) A. They can accept only one argument. B. They can be nested up to only two levels. C. They can return multi原创 2014-07-13 17:03:55 · 1242 阅读 · 0 评论 -
group functions
129. Which three statements are true regarding group functions?(Choose three.) A. They can be used on columns or expressions. B. They can be passed as an argument to another group function. C.原创 2014-07-13 16:33:58 · 669 阅读 · 0 评论 -
自然连接 natural join
74. View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANTITY), wher原创 2014-07-02 10:23:42 · 725 阅读 · 0 评论 -
privs与roles
SQL> create user a identified by a default tablespace users; User created. SQL> create user b identified by a default tablespace users; User created. SQL> create user c identified by a default原创 2014-06-26 20:15:27 · 672 阅读 · 0 评论 -
列值为null相关知识
39. View the Exhibit and examine the description of the PRODUCT_INFORMATION table. Which SQL statement would retrieve(检索) from the table the number of products having LIST_PRICE as NULL? 比较null值用is转载 2014-06-26 19:23:47 · 684 阅读 · 0 评论 -
批量插入
生产部门有以下的需求,但是类似的表有64 张,t_cmp_type_paymentrecord1 (后缀1到64),本来想写成 64 个这样的sql ,然后用union all进行 拼接,但感觉这样拼接也累,跟同事请教,使用了另一种方法。 select * from t_cmp_type_paymentrecord1 where status=3 and paymenttype=0 an原创 2016-10-28 18:07:53 · 297 阅读 · 0 评论