原文链接：http://www.cnblogs.com/xiaotiannet/p/3846966.html感谢原作者：破剑冰-Oracle中Clob类型处理解析 上一篇分析：ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值 最近为Clob字段在插入数据时发现当字符的字节数（一个半角字符一个字节，一个全角字符两个字节）在2000-4000之间时报错（ORA-01461:仅可以插入LONG列的LONG值赋值）。经过不断查找资料和自己的试验该问题终于得到解决，下边我将自己的心得给大家做一个分享。 ...
一,创建Data Block是数据库中最小的I/O单元01,建立一个新的表空间查看默认表空间位置select TABLESPACE_NAME,FILE_NAME from dba_data_files; 创建一个表空间放其他的地方把create tablespace test2 datafile /orcl/app/table/test2.dbf size 20m reuse autoextend on next 20m maxsize UNLIMITED extent management local; 02,创建用户 查看CDBselect name,cdb from v$database;查看pDbSQL> select pdb_id,pdb_name,dbid,s...
原 Oracle SQL的硬解析和软解析https://blog.csdn.net/tianlesoftware/article/details/5458896版权声明： https://blog.csdn.net/tianlesoftware/article/details/5458896 我们都知道在Oracle中每条SQL语句在执行之前都需要经过解析，这里面又分为软解析和硬解析。在Oracle中存在两种类型的SQL语句，一类为 DDL语句(数据定义语言)，他们是从来不会共享使用的，也就是每次执行都需要进行硬解析。还有一类就是DML语句(数据操纵语言...
---最大连续交易天数 select t2.customer_no,max(t2.co) from (select t1.customer_no,t1.yp-t1.rn rk,count(1) cofrom (select ctd.customer_no,ctd.order_time yp,row_number() over(partition by ctd.customer_no order by ctd.order_time) rnfrom posp_boss.customer_trans_day ctdwhere ctd.order_time >= to_date(20180101, yyyymmdd)order by ctd.customer_no,ctd.order_time)t1group by t1.customer_no,t1.yp-t1.rn)t2g...
35.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date,6),1) "Review" FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the first Monday after the completion of six months of the hi...
32.choose the best answer View the Exhibit and examine the data in EMP and DEPT tables. In the DEPT table, DEPTNO is the PRIMARY KEY. In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing the DEPTNO column in the DEPT table. What would be the outcome of the following statements executed in the given sequence? DROP TABLE emp; FLASHBACK TABLE emp TO BEFORE DROP; INSERT...
30.choose the best answer Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: SQL> CREATE TABLE DEPARTMENT_DETAILS (DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) , HOD VARCHAR2(50)); SQL> CREATE TABLE COURSE_DETAILS (COURSE_ID NUMBER PRIMARY KEY, COURSE_NAME VARCHAR2 (50) , DEPARTMENT_ID NUMBER REFERENCES DEPARTMENT_DETAILS(DEPARTMENT_ID)); You want to gener...
Oracle OCP 11G 051答案解析目录 1 http://blog.csdn.net/rlhua/article/details/121849992 http://blog.csdn.net/rlhua/article/details/129056813 http://blog.csdn.net/rlhua/article/details/129063094 http://blog.csdn.net/rlhua/article/details/129098235 http://blog.csdn.net/rlhua/article/details/129100276 http://blog.csdn.net/rlhua/article/details/129...
? 别人整理我的052解析，感谢。文档地址：http://pan.baidu.com/s/1gtYay ? ?V8.02和V9.02对比V8.02 V9.021：http://blog.csdn.net/rlhua/article/details/12624275 40,1092：http://blog.csdn.net/rlhua/article/details/12753653 1223：http://blog.csdn.net/rlhua/article/details/12624403 604：http://blog.csdn.net/rlhua/article/details/12624539 无此题5：http://blog.csdn.net/rlhua/article/details/12625115 706：http...
Oracle OCP 11G 053（1-200）答案解析目录V13.02版本,711题File Version: 3.2，200题Version: 5.41http://blog.csdn.net/rlhua/article/details/16369867 4902http://blog.csdn.net/rlhua/article/details/16527169 4913http://blog.csdn.net/rlhua/article/details/14057145 1427004http://blog.csdn.net/rlhua/article/details/14057199 1346925http://blog.csdn.net/rlhua/article/details/15617393 4946http://blog.csdn....
1.定义 触发器：是存储在服务器中的程序单元，当数据库中某些事件发生时（比如insert\update\delete），数据库自动启动触发器，执行触发器中的相应操作。 2.触发的时间： before 在指定的事件发生之前执行触发器 after 在指定的事件发生之后执行触发器 3.触发的事件： (1)Insert,update,delete,create(创建对象时),alter,drop (2)logon/logoff(用户的登录或注销时执行触发器) (3)startup/shutdown(数据库打开或关闭时执行触发器) 4...
CREATE OR REPLACE PROCEDURE wdgj_in_result_gen(p_json_varchar IN VARCHAR2,p_code out number,p_message out varchar2) AS ---------------------------------------------------------- --将接口返回的数据插入到中间表【订单主表 WDGJ_RESULT_RETAIL】和【订单子表 WDGJ_RESULT_RETAILITEM】中： --（字段对照关系见接口地址以及本文档的下一个需求的表结构） --如果调用存储过程成功，则返回成功。 --...
Oracle OCP 1Z0-050（39题）解析 QUESTION 39: Evaluate the following function code: CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE RELIES_ON (EMPLOYEES) IS avgsal NUMBER(6); BEGIN SELECT AVG(SALARY)INTO avgsal FROM EMPLOYEES WHERE DEPARTMENT_ID = dept_id; RETURN avgsal; END get_dept_avg; Which statement is true regarding the above function? A. The cached result becomes inval...
Oracle OCP 1Z0-050（26题）解析 QUESTION 26: Evaluate the following code: SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN :sql_stmt := SELECT COUNT(*) FROM customers WHERE cust_state_province =CA; :task_name := MY_QUICKTUNE_TASK; DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQL ACCESS_ADVISOR, :task_name, :sql_stmt); END; What is the outcome of this block of code? A. I...
举几个例子来说明ALL和ANY的用法 1. SELECT * FROM TABLEA WHERE FLD > ALL(SELECT FLD FROM TABLEA) 这相当于 SELECT * FROM TABLEA WHERE FLD > (SELECT MAX(FLD) FROM TABLEA) 2. SELECT * FROM TABLEA WHERE FLD > ANY(SELECT FLD FROM TABLEA) 这相当于 SELECT * FROM TABLEA WHERE FLD > (SELECT MIN(FLD) FROM TABLEA) 3. SELECT * FROM TABLEA WHERE FLD = ANY(SELECT FLD FROM TABLEA) 这相当于 SELECT * FROM TABLEA WHE...