ITPub博客

<p>最近开始研究大数据，从mongada官网下载的zip文件解压后没有找到bin目录，有人遇到过这个情况吗？</p>

将：= #columnName#替换为like '%$columnName$%'即可，例如：= #FileId#替换为like '%$FileId$%'[@more@]

选择表中的某一行记录：(理解：rownum是oracle系统顺序分配为从查询返回的行的编号) select * from (select rownum a,t.* from testtab t) where a=2; select * from (select rownum a,t.* from testtab t) where a=3; select * from (select rownum a,t.* from testtab t) where a=4; 不能为： select * from (select rownum,t.* from testtab t) where rownum=2;或 select * from testtab where rownum=2; 返回多行记录： select * from testtab where rownum<=10; 返回某段记录：(

EXP、IMP命令语句可以说是Oracle数据库管理员的利器，用好这两个命令会使数据库管理工作事半功倍。先来看看EXP、IMP命令的用途： 一、用途： 1、在不同的系统平台间移植数据。 2、数据库的备份和恢复手段之一。 3、用于用户间的数据移动。二、基本语法和实例： 1、EXP: 有三种主要的方式（完全、用户、表） 1、完全： EXP SYSTEM/MANAGER BUFFER=64000 FILE=C:FULL.DMP FULL=Y 如果要执行完全导出，必须具有特殊的权限 2、用户模式： EXP SONIC/SONIC BUFFER=64000

record：该集合可以存储一对多的标量属性。 pl/sql表：是pl/sql代码中的“表”，只存在应用运行期间(内存里)，类似“数组”，稀疏的，大小可以动态增长，可以有负下标，但不能存储在数据库表中。 varray：与pl/sql区别是可以在表列中存储，是密集的，不能删除单独记录，不能有负下标，固定大小的集合。 nested table：可以在表列中存储，稀疏的，可以删除单独记录，不能有负下标，大小可变。 1、记录： SQL> declare 2 type emp_rec_t is record( 3 no number, 4 name varchar2(10) 5 ); 6 emp1 emp_rec_t; 7 emp2 e

In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective? A.AFTER CREATE B.AFTER SUSPEND C.BEFORE CREA

select d.value || '/' || lower(rtrim(i.instance, chr(0))) || '_ora_' || p.spid || '.trc' trace_file_name 　　 from (select p.spid from v$mystat m, v$session s, v$process p where m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr) p, (select t.instance from v$thread t, v$parameter　v where v.name = 'thread' and (v.value = 0 or t.thread# = to_number(v.value))) i, (select value from v$parameter where name = 'use

select t1.rp_no,count(*) from zgire t1,zgwsg t2where t1.rp_no = t2.rp_no(+) and t1.rp_type = t2.rp_type(+)group by t1.rp_noorder by t1.rp_no; 等价于 select t1.rp_no,count(*) from zgire t1left outer join zgwsg t2on t1.rp_no = t2.rp_no and t1.rp_type = t2.rp_typegroup by t1.rp_noorder by t1.rp_no;[@more@]

select *from t_cs_personcust twhere (is_new = '001' or is_new = '011' or is_new = '101' oris_new = '111')and not exists (select distinct cust_idfrom t_cs_personcust_appwhere (is_new = '001' or is_new = '011' oris_new = '101' or is_new = '111')and message_no = '初始导入'and cust_id = t.cust_id); 检索数据2796条，检索时间 3.516 秒 select *from t_cs_personcust twhere (is_new = '001' or is_new = '011' or is_new = '101' oris_new = '111')and cust_id not in (select distinct cust_idfrom t_cs_personcust_a

DECLARE List1 TableList; BEGIN SELECT DateType(payperiod) BULK COLLECT INTO List1 FROM period_tab; FOR c1 IN ( SELECT payperiod FROM TABLE( CAST( List1 AS TableList)) ) LOOP DBMS_OUTPUT.PUT_LINE( c1.payperiod ); END LOOP; END;[@more@]

select *from (select t.*,dense_rank() over(partition by yield_day order by product_id desc) drfrom t_pd_cashproductyieldcon t)where dr = 1;[@more@]

问题描述：[Gaia2.5] DEBUG 2011-02-09 13:28:01,338 [java.sql.Connection:42] - {conn-100213} Connection[Gaia2.5] DEBUG 2011-02-09 13:28:01,352 [java.sql.PreparedStatement:48] - {pstm-100214} PreparedStatement: {call pac_ac_center.pro_precount (?,?,?)}[Gaia2.5] DEBUG 2011-02-09 13:28:01,352 [java.sql.PreparedStatement:49] - {pstm-100214} Parameters: [2011-02-01, li_xiang][Gaia2.5] DEBUG 2011-02-09 13:28:01,352 [java.sql.PreparedStatement:50] - {pstm-100214} Types: [java.sql.Date, java.lang.String]=