- 博客(250)
- 收藏
- 关注
原创 ASCIISTR,ASCII,CHR函数的区别
今天偶然看到一个函数ASCIISTR,搜了下,似乎没看到有详细介绍这个函数的,所以找到联机文档,研究了一下,和大家分享:一、ASCII函数 ASCII函数,是将字符转成ASCII码的值.SQL> select ascii('a') from dual;ASCII('A')---------- 97SQL> select ascii
2017-03-23 22:35:47
11517
原创 Linux环境下部署tomcat中间件
一、 准备工作使用ftp或WinSCP工具将jdk和tomcat传输到linux服务器上。Tomcat和jdk可在互联网上下载,或加入技术交流群(qq群号:185713331)看群共享下载。 二、安装jdk切换到存放安装文件的目录下,然后执行安装命令 给予jdk安装文件对于的权限 执行安装操作 Jdk安装完成后显示如下:
2017-03-13 22:13:05
5252
转载 SQL * Loader详解
该文转自 http://www.cnblogs.com/benio/archive/2011/10/14/2211171.html在 Oracle 数据库中,我们通常在不同数据库的表间记录进行复制或迁移时会用以下几种方法:1. A 表的记录导出为一条条分号隔开的 insert 语句,然后执行插入到 B 表中2. 建立数据库间的 dblink,然后用 create t
2015-12-13 12:38:36
2822
原创 OCP-1Z0-051 补充题库 第45题 CREATE VIEW
一、原题You work as a database administrator at ABC.com. You study the exhibit carefully.Exhibit:You want to create a SALE_PROD view by executing the following SQL statements: CREATE VIEW
2015-04-03 22:51:02
2167
原创 OCP-1Z0-051 补充题库 第44题 NATURAL JOIN自然连接
一、原题View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables.You issue the following query:SQL>SELECT p.prod_id,prod_name,prod_list_p
2015-04-03 22:14:49
1890
原创 OCP-1Z0-051 补充题库 第43题 子查询
一、原题Exhibit contains the structure of PRODUCTS table: Evaluate the following query: What would be the outcome of executing the above SQL statement?A. It produces an errorB. I
2015-04-03 15:25:14
1588
原创 OCP-1Z0-051 补充题库 第42题 DROP TABLE命令的影响
一、原题You issue the following command to drop the PRODUCTS table:SQL>DROP TABLE products;What is the implication of this command? (Choose all that apply.)A. All data in the table are deleted b
2015-04-03 15:06:37
2305
原创 OCP-1Z0-051 补充题库 第41题 nvl函数的使用
一、原题See the structure of the PROGRAMS table:Which two SQL statements would execute successfully? (Choose two.) A. SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE)FROM programs; B. SELE
2015-04-03 14:36:47
1913
原创 OCP-1Z0-051 补充题库 第40题 聚合函数的使用
一、原题Which two are true about aggregate functions? (Choose two.)A. You can use aggregate functions in any clause of a SELECT statement.B. You can use aggregate functions only in the column list o
2014-10-26 22:54:31
2328
原创 OCP-1Z0-051 补充题库 第39题 日期运算
一、原题You need to calculate the number of days from 1st Jan 2007 till date:Dates are stored in the default format of dd-mm-rr.Which two SQL statements would give the required output? (Choose two.)
2014-10-16 00:13:56
3238
原创 OCP-1Z0-051 补充题库 第38题 nvl用法
一、原题See the Exhibit and Examine the structure of the CUSTOMERS table:Using the CUSTOMERS table, you need to generate a report that shows an increase in the creditlimit by 15% for all customers.
2014-10-16 00:10:06
3453
原创 OCP-1Z0-051 补充题库 第37题
一、原题See the exhibit and examine the structure ofthe CUSTOMERS and GRADES tables:You need to display names and grades ofcustomers who have the highest credit limit.Which two SQL statements woul
2014-10-16 00:08:06
3235
1
原创 OCP-1Z0-051 补充题库 第36题 约束
一、原题 Which CREATE TABLE statement is valid? A. CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date DATE NOT NULL); B. CREATE TABLE ord_details (ord
2014-08-13 23:17:47
2740
原创 OCP-1Z0-051 补充题库 第35题 LONG类型
一、原题Examine the description of the EMP_DETAILS table given below:Exhibit:Which two statements are true regarding SQL statements that can be executed on theEMP_DETAIL table? (Choose two.)A. A
2014-06-28 00:37:45
2777
原创 OCP-1Z0-051 补充题库 第34题 COUNT函数
一、原题Which two statements are true regarding the COUNT function? (Choose two.)A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULLvalue in any of the columns
2014-06-27 00:54:06
3292
原创 OCP-1Z0-051 补充题库 第33题 sql*plus命令
一、原题Which are /SQL*Plus commands? (Choose all that apply.)A. INSERTB. UPDATEC. SELECTD. DESCRIBEE. DELETEF. RENAME答案: D二、题目翻译下面哪个是SQL*Plus命令?(选择所有合适的选项)三、题目解析只有describe是sql*plu
2014-06-27 00:32:33
2645
原创 OCP-1Z0-051 补充题库 第32题 ALL、ANY、IN
一、原题View the Exhibit and examine the structure of the PROMOTIONS table.You have to generate a report that displays the promo name and start date for all promos thatstarted after the last promo i
2014-06-27 00:19:57
3072
原创 OCP-1Z0-051 补充题库 第31题 subquery子查询的注意事项
一、原题Which two statements about sub queries are true? (Choose two.)A. A sub query should retrieve only one row.B. A sub query can retrieve zero or more rows.C. A sub query can be used only in S
2014-06-25 23:40:17
3392
原创 OCP-1Z0-051 补充题库 第30题 oracle中的NULL值
一、原题View the Exhibit and examine the description for the CUSTOMERS table.You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, whereCUST_INCOME_LEVEL has NULL in the CUS
2014-06-25 00:07:30
2456
原创 OCP-1Z0-051 补充题库 第29题 INSERT语句中有子查询
一、原题View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITYthat have the same data types and size as the
2014-06-24 23:52:15
3076
原创 OCP-1Z0-051 补充题库 第28题 Date类型
一、原题Which two statements are true regarding working with dates? (Choose two.)A. The default internal storage of dates is in the numeric formatB. The RR date format automatically calculates the c
2014-06-24 23:39:06
2734
原创 OCP-1Z0-051 补充题库 第27题 UNION的注意事项
一、原题Which statement is true regarding the UNION operator?A. The number of columns selected in all SELECT statements need to be the sameB. Names of all columns must be identical across all SELECT
2014-06-24 00:00:10
2703
1
原创 OCP-1Z0-051 补充题库 第26题 单行函数特点
一、原题Which two statements are true regarding single row functions? (Choose two.)A. They can be nested only to two levelsB. They always return a single result row for every row of a queried table
2014-06-23 14:08:01
3511
原创 OCP-1Z0-051 补充题库 第25题 TRUNC和ROUND
一、原题Evaluate the following SQL query;SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;What would be the outcome?A. 200B. 16C. 160D. 150E. 100答案: C二、题目解析ROUND(156.00,-1)round表示四
2014-06-23 13:59:59
4795
原创 OCP-1Z0-051 补充题库 第24题 SYNONYM同义词
一、原题Examine the statement:Create synonym emp for hr.employees;What happens when you issue the statement?A. An error is generated.B. You will have two identical tables in the HR schema with d
2014-06-23 13:51:09
2445
原创 OCP-1Z0-051 补充题库 第23题 表连接中别名的使用
一、原题Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees e JOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORDER BY dept_name;The statement
2014-06-23 00:12:14
3148
1
原创 OCP-1Z0-051 补充题库 第22题 SYNONYM同义词
一、原题The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on theORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following
2014-06-22 23:46:58
2860
原创 OCP-1Z0-051 补充题库 第21题 SEQUENCE序列注意事项
一、原题Which two statements are true about sequences created in a single instance database? (Choosetwo.)A. CURRVAL is used to refer to the last sequence number that has been generatedB. DELETE w
2014-06-22 23:31:07
2939
2
原创 OCP-1Z0-051 补充题库 第20题 约束的注意事项
一、原题Which two statements are true regarding constraints? (Choose two.)A. A constraint can be disabled even if the constraint column contains dataB. A constraint is enforced only for the INSERT o
2014-06-20 23:03:34
2750
原创 OCP-1Z0-051 补充题库 第19题 限制替代变量的输入值
一、原题Examine the structure of the EMPLOYEES table:You want to create a SQL script file that contains an INSERT statement. When the script is run,the INSERT statement should insert a row with the
2014-06-20 22:50:21
2759
原创 OCP-1Z0-051 补充题库 第18题 DELETE语句的特性
一、原题Evaluate the following SQL statements:DELETE FROM sales;There are no other uncommitted transactions on the SALES table.Which statement is true about the DELETE statement?A. It removes al
2014-06-20 22:25:42
2266
原创 OCP-1Z0-051 补充题库 第17题 约束的注意事项
一、原题Evaluate the following SQL statements:The above command fails when executed. What could be the reason?A. The BETWEEN clause cannot be used for the CHECK constraintB. SYSDATE cannot be used
2014-06-20 22:10:05
2965
原创 OCP-1Z0-051 补充题库 第16题 rownum的用法
一、原题Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INTSQL and who completed the course in the year 1999
2014-06-20 17:24:51
2334
原创 OCP-1Z0-051 补充题库 第15题 子查询和join
一、原题The COMMISSION column shows the monthly commission earned by the employee.Which two tasks would require sub queries or joins in order to be performed in a single step?(Choose two.)A. listi
2014-06-20 09:48:17
2823
原创 OCP-1Z0-051 补充题库 第14题 关于表约束的视图
一、原题Which view should a user query to display the columns associated with the constraints on a tableowned by the user?A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUM
2014-06-19 13:28:12
2402
原创 OCP-1Z0-051 补充题库 第13题 MERGE INTO语句
一、原题Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which MERGE statement is valid?A.MERGE INTO new_employees cUSING employees eON (c.employee_id = e.employee_id)WHEN MAT
2014-06-19 12:50:27
2627
原创 OCP-1Z0-051 补充题库 第12题 oracle函数分类
一、原题Which four are types of functions available in SQL? (Choose 4)A. stringB. characterC. integerD. calendarE. numericF. translationG. dateH. conversionAnswer: B,E,G,H二、题目翻译下面哪
2014-06-18 18:37:02
2481
原创 OCP-1Z0-051 补充题库 第11题 SQL和SQL*Plus的区别
一、原题Which statement correctly describes SQL and /SQL*Plus?A. Both SQL and /SQL*plus allow manipulation of values in the database.B. /SQL*Plus recognizes SQL statements and sends them to the serv
2014-06-07 17:43:44
3271
3
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人