学问之道无穷，而总以有恒为主。

1.修改C:\Windows\System32\drivers\etc\hosts文件:增加本机IP地址及主机名。2.安装EM，安装前需要配置好静态监听并启动。emca -config dbcontrol db -repos  recreate输入相关信息即可。3.启动EM set ORACLE_UNQNAME=herbert  emctl start dbconsole

276ASQL> select to_date('JUL 10 2006','MON DD YYYY') NEWDATE FROM DUAL;NEWDATE------------10-JUL-06有显示，但与格式不同BSQL> select order_date, TO_CHAR(order_date, 'MON DD YYYY') NEWCHAR 2

218. Evaluate the following query:SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual;What is the correct output of the above query?A

SQL> show userUSER is "TEST"SQL> conn oe/oeConnected.SQL> SELECT i.product_id, i.quantity_on_hand , pi.supplier_id 2 FROM product_information pi JOIN inventories i 3 ON (pi.product_id=i.prod

58. Evaluate the following statement:CREATE TABLE bonuses(   employee_id NUMBER,   bonus NUMBER DEFAULT 100   ); The details of all employees who have made sales need to be inserted in

192. Which CREA TE T ABLE statement is valid? A. CREA TE T ABLE ord_details (ord_no NUMBER(2) PRIMARY KEY , item_no NUMBER(3) PRIMARY  KEY , ord_date date NOT  NULL); B. CREA TE T ABLE ord_d

49. View the Exhibit and examine the description of EMPLOYEES and DEPARTMENTS tables. You want to display the EMPLOYEE_ID, LAST_NAME, and SALARY for the employees who get the maximum salary in their

GROUPING函数可以接受一列，返回0或者1。GROUPI NG只能在使用ROLLUP或CUBE的查询中使用。当需要在返回空值的地方显示某个值时，GROUPING()就非常有用。 1、在ROLLUP中对单列使用G ROUPING() SQL> select division_id,sum(salary)    from employees2    group by rollu

Oracle统计函数使用之ROLLUP与CUBE    Oracle的GROUP BY语句除了最基本的语法外，还支持ROLLUP和CUBE语句。如果是ROLLUP(A, B, C)的话，首先会对(A、B、C)进行GROUP BY，然后对(A、B)进行GROUP BY，然后是(A)进行GROUP BY，最后对全表进行GROUP BY操作。    如果是GROUP BY CUBE(A, B,

日期与数字字符隐示转换SQL> select * from t001 where edate='2013-10-07 00:00:00';select * from t001 where edate='2013-10-07 00:00:00'                              *ERROR at line 1:ORA-01861: literal d

UnUseDInstead of dropping a table column you are no longer using, you may elect to declare it unusedand leave it in place. Once you set a column as UNUSED, it is never again available; it is as

Q - quoting mechanism for string literalsWe make use of single quotation mark in SQL and PL/SQL to identify sting literals. If the literal itselfcontains a single quote, we need to add one more qu

《Oracle Database SQL Expert Exam Guide (Exam 1Z0-047) 》use the WitH ClauseYou can use the keyword WITH to assign a name to a subquery block. Once the name is assigned, you can reference the

128. Evaluate the following SQL statement:CREATE INDEX upper_name_idx ON product_information(UPPER(product_name));这个索引是建立在函数上的索引，仅对查询到product_name列是不会使用索引的，必须用UPPER(product_name)才能使用该索引Which q

flashback  version subquery to_date to_char timezone

23. View the Exhibit and examine the structure of the CUST table.Evaluate the following SQL statements executed in the given order:ALTER TABLE custADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id)

测试工具：http://zhengze.51240.com/

92. Evaluate the following expression using meta character for regular expression: '[^Ale |ax.r$]' Which two matches would be returned by this expression? (Choose two.) A.  Alex B.  Alax C.

68. The following are the steps for a correlated subquery , listed in random order: 1) The WHERE clause of the outer query is evaluated. 2) The candidate row is  fetched from the t able specified

151. View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Robert

61. Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR2(15), salary NUMBER(8,2),

54. Which two statements are true about sequences created in a single instance database? (Choose two.) A. The numbers generated by a sequence can be used only for one table. 翻译: 序列产生的数字只能被用于一个表

18. View the Exhibit and examine the data in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER ID, ORDER_DATE, and the total number of items in each order. Which CREATE

Syntaxto_yminterval::=Description of the illustration to_yminterval.gifPurposeTO_YMINTERVAL converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an IN

14. OE and SCOTT are the users in the database. The ORDERS table is owned by OE. Evaluate(评价) the statements issued(发行) by the DBA in the following sequence:CREATE ROLE r1;GRANT SELECT, INSERT ON

4. View the Exhibit and examine the structure of the EMP table which is not partitioned and not an indexorganized table. Evaluate the following SQL  statement:ALTER TABLE emp DROP COLUMN first_name;

84. You need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employeeemployee_id number2. Employee Name, (character data type) which st

子查询：嵌套在其他查询中的查询称之。子查询又称内部，而包含子查询的语句称之外部查询（又称主查询）。所有的子查询可以分为两类，即相关子查询和非相关子查询1>非相关子查询是独立于外部查询的子查询，子查询总共执行一次，执行完毕后将值传递给外部查询。2>相关子查询的执行依赖于外部查询的数据，外部查询执行一行，子查询就执行一次。故非相关子查询比相关子查询效率高

262. View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration(薪酬) for each employee. Total remuneration is the sum of the annual(每年的) salary

参考：http://blog.youkuaiyun.com/wkc168/article/details/5545633

1 12. View  the Exhibit and examine the details of the EMPLOYEES table. Evaluate the following SQL  st atement s: S tatement 1: SELECT employee_id, last_name, job_id, manager_id FROM employees

privileges can be inspected using the following views:1. USER_SYS_PRIVS  System privileges granted to the current user2. USER_TAB_PRIVS  Granted privileges on objects for which the user is the o

搭建047实验环境，选择的是一般用途，添加演示示例，但中途报错了如下图，未查到原因。

66. Which two statements are true regarding multiple-row subque ries? (Choose two.) A. They can contain group functions. B. They always contain a subquery within a subquery. C. They use the

23. View the Exhibit and examine the structure of the CUST table. Evaluate the following SQL statements executed in the given order: ALTER TABLE cust ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_i

在oracle连接(join)中使用using关键字34. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. Evaluate the following SQL statement: SELECT oi.order_id, product_id, o

24.View the Exhibit and examine the structure of the ORDERS table: The ORDER_ID column has the PRIMARY KEY constraint and CUSTOMER_ID has theNOT NULL constraint.Evaluate the following statem

27. View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.You want to see the product names and the date of expirat ion of warranty for all the products, if the product is pu

36. Evaluate the following statements: CREATE TABLE digits (id NUMBER(2), description VARCHAR2(15)); INSERT INTO digits VALUES (1,'ONE'); UPDATE digits  SET description ='TWO' WHERE id=1;

45. View the Exhibit and examine the structure of the CUSTOMERS table. CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table. CUSTOMERS needs to be upd