-
编辑 删除
TBase-开源版本安装部署（超详细）
本文章详细的介绍了开源的TBase版本部署方式
-
编辑 删除
OCP-051-008
View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)观察下面的表结构, 哪儿个任务需要在一个语句中包含子查询或者joinsA. listing of customers who do not have a credit limit and wer...
-
编辑 删除
OCP-051-007
7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.) 关于USING和ON子句, 哪儿个是正确的A. Both USING and ON clauses can be used for equijoins and nonequijoins. --using不能用于不等值连接B. A maximum of one pair of columns...
-
编辑 删除
OCP-051-006
6. Examine the structure of the SHIPMENTS table: 检查表SHIPMENTS 的结构name Null TypePO_ID NOT NULL NUMBER(3) PO_DATE NOT NULL DATESHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2(30) SHIPMENT_COST NUMBER(8,2)You want to generate a report that displays the PO_ID and the penal...
-
编辑 删除
OCP-051-005
5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .) A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;C. SELECT TO_CHAR(1890.55,'$99,999D99') FROM DUAL;D. SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL;E. S...
-
编辑 删除
OCP-051-004
4. Which two statements are true regarding single row functions? (Choose two.) --下列关于简单函数描述正确的是A. They accept only a single argument. --select concat('a','b') from dual; B. They can be nested only to two levels. &nb...
-
编辑 删除
OCP-051-003
3. You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.Which WHERE clause could be used in the SELECT statement to get the required output? --以下哪个子句可以找出包含 '_D123' 字符串的行A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'B...
-
编辑 删除
OCP-051-002
2. View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)A. CREATE VIEW v3AS SELECT * FROM SALES WHERE cust_id = 2034WITH CHECK OPTION;B. CREATE VIEW v1AS SELECT * FROM SALESW...
-
编辑 删除
PRVF-0002 : Could not retrieve local nodename
PRVF-0002 : Could not retrieve local nodename原因是不能解析自己的主机名称。执行hostname，得到自己的主机名称，然后添加到/etc/hosts文件中.[root@machao ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 machao::1 ...
-
编辑 删除
安装LINUX卡在Detecting hardware waiting for hardware to initialize
Linux;安装;Detecting hardware
-
编辑 删除
OCI demo整理
Oracle OCI demo下载;OCI编程；OCI调用
-
编辑 删除
Oracle11g 图形化安装
oracle 11g 图形化安装, 包括监听, EM, dbca建库等操作.
-
编辑 删除
利用sqlldr迁移数据- KDB到Oracle
利用sqlldr工具从kdb迁移数据库到oracle1. 生成要迁移的对象;2. 生成对象DDL语句;3. 在oracle中建立迁移对象并生成sqlldr控制文件4. 利用spool在kdb中生成数据文件5. 通过sqlldr导入数据文件到oracle数据库中
-
编辑 删除
Oracle在linux redhat 6.4的静默安装
Oracle在redhat 6.4上的静默安装. 数据库手动安装, 静态监听配置, em安装silence installation on Linux
-
编辑 删除
OCP-051--001
oracle 通过CTAS建表的约束关系
