-
编辑 删除
oracle 10 xe 中文显示为问号问题
困扰了我两天，其实就是些错了一个东西。环境：rhel 5.4安装完xe后，在命令行启动sqlplus,创建测试表，并且输入中文数据，查询显示??看了不少帖子，做了不少尝试。未果。基于xe的小巧，一直不想放弃。我电脑配置比较...
-
编辑 删除
047题库学习笔记
需要复习4,13,15,19,20,22,24,28,31,32,34,38,41,42,43,45,48,56,61,64,65,66,67,68,70,p79,91,92,98,99,100,102,103,104,107,114,117,122,125,126,127,129,131,133,137,139,144,146,148,151,152,153,155,159,161,20...
-
编辑 删除
047试题请教
144. View the Exhibit and examine the details of the EMPLOYEES table.You want to generate a hierarchical report for all the employees who report to the employee whoseEMPLOYEE_ID is 100.Which SQL cl...
-
编辑 删除
047试题请教
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. They ...
-
编辑 删除
请教regexp_like
以下都能返回结果select 1 from dual where REGEXP_LIKE ('harddisks', 'hard+.s')select 1 from dual where REGEXP_LIKE ('harddisks', 'hard..s')select 1 from dual where REGEXP_LIKE ('harddisks', 'hard......
-
编辑 删除
047试题请教
103. View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY tables.The EMPLOYEES table maintains the most recent information regarding salary, department, and job forall the employe...
-
编辑 删除
047试题请教
93. The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERStable to the user HR.Which statement would create a synonym ORD so that HR can execute the following que...
-
编辑 删除
047试题请教
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. AlexB. AlaxC. AlxerD. Alax...
-
编辑 删除
047题目请教
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 into the BONUSES tab...
-
编辑 删除
047试题请教
15. Evaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A. Any synonym existing on the EMP table...
-
编辑 删除
047一道题目的疑惑
按月天数排列 按照管理组签到时间排列总奖励排行榜签到等级说明 11. View the Exhibit and examine the descriptions of ORDER_ITEMS and ORDERS tables.You want to display the CUSTOMER_ID, PRODUCT_ID, and to...
-
编辑 删除
我的11g卸载不掉了
环境windows xp sp311g最新版本的企业版安装，卸载时的图像见附件给我大侠帮忙看看咋整。warning.JPG
