发布时间：2015-02-06 11:01:17

保存文件时，报此异常。Errors occurred during the build.Errors running builder 'DeploymentBuilder' on project '项目名'.java.lang.NullPointerException第一种解决办法:有一种产生此错误的原因是因为此项目不不是由myeclipse创建的。所以你需要检查项目下的.project 文件。找到natures目录并且添加 <nature.........【阅读全文】

发布时间：2014-07-11 17:18:15

一、创建测试表 SQL> create table  testcursor as select 3333 as id, t.* from dba_objects t; Table created 二、创建索引SQL> create index idx_testcursor on testcursor(id); Index created 三、查看当前参数 SQL> show parameter cursor_sharing; NAME   &.........【阅读全文】

发布时间：2014-07-08 11:45:44

一、创建测试表SQL> Create Table Testsample As Select Object_Id, Object_Name From Dba_Objects Where 1=2; Table created 二、创建索引SQL> Create Index i_Idx_Testsample On Testsample(Object_Id); Index created 三、插入数据SQL>  Insert Into Testsample Select Object_Id, Ob.........【阅读全文】

发布时间：2014-07-07 14:41:25

一、创建测试表SQL> create table t_obj as select * from dba_objects; Table created二、创建索引SQL> create index t_obj_ind on t_obj(object_id); Index created 三、收集统计信息SQL> exec dbms_stats.gather_table_stats(user,'t_obj',cascade=>true); PL/SQL procedure successfull.........【阅读全文】

发布时间：2014-07-07 10:59:21

一、执行多次查询：SQL> beginfor i in 1..100 loopexecute immediate 'select * from emp where empno=' || i;end loop;end;/二、创建测试表SQL> create table test as select sql_text from v$sqlarea; Table created三、添加字段SQL> alter table test add constraintname varchar2(1000); Tab.........【阅读全文】