hello_holly-CSDN博客

原创 ASCIISTR,ASCII,CHR函数的区别

今天偶然看到一个函数ASCIISTR,搜了下,似乎没看到有详细介绍这个函数的,所以找到联机文档,研究了一下,和大家分享:一、ASCII函数 ASCII函数,是将字符转成ASCII码的值.SQL> select ascii('a') from dual;ASCII('A')---------- 97SQL> select ascii

2017-03-23 22:35:47 11593

原创 Linux环境下部署tomcat中间件

一、准备工作使用ftp或WinSCP工具将jdk和tomcat传输到linux服务器上。Tomcat和jdk可在互联网上下载，或加入技术交流群（qq群号：185713331）看群共享下载。二、安装jdk切换到存放安装文件的目录下，然后执行安装命令给予jdk安装文件对于的权限执行安装操作 Jdk安装完成后显示如下：

2017-03-13 22:13:05 5304

转载 HTML特殊符号对照表

HTML特殊符号对照表特殊符号命名实体十进制编码特殊符号命名实体十进制编码ΑΑΑΒΒΒΓΓΓΔ&De

2015-12-15 21:25:13 2640

转载 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 2845

原创 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 2188

原创 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 1910

原创 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 1614

原创 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 2340

原创 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 1934

原创 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 2351

原创 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 3274

原创 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 3500

原创 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 3285 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 2776

原创 ORA-00119,ORA-00132解决办法

启动数据库时,报错:

2014-08-01 23:45:36 1547

原创 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 2815

原创 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 3342

原创 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 2680

原创 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 3121

原创 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 3431

原创 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 2497

原创 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 3102

原创 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 2776

原创 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 2754 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 3552

原创 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 4885

原创 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 2494

原创 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 3184 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 2895

原创 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 2968 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 2779

原创 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 2781

原创 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 2308

原创 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 3003

原创 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 2364

原创 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 2862

原创 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 2440

原创 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 2660

原创 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 2500

原创 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 3312 3

空空如也

空空如也