ITPub博客

1,配置secure crt及rhel5上面的NLS_LANG内容如下：-bash-3.1$ env|grep LANGNLS_LANG=SIMPLIFIED CHINESE_CHINA.utf8LANG=en_US.UTF-8 2，sqlloader导入数据的控制文件内容如下：-bash-3.1$ more insert_ba...

1,改变其文件扩展名为txt，然后打开转变后的txt文件2,另存为utf8编码3,经总结：csv及txt对于上传到linux上面，扩展名是无关重要的，哈哈  

truncate table e_schoolinfoselect constraint_name,table_name,status from user_constraints;alter table e_schoolinfo disable constraint pk_e_schoolinfo cascade;select schoolid,schoolname,city,distric...

[root@localhost ~]# who -r  --第一个标红表示当前运行级别，第二个标红表示上次运 行级别         run-level 3  2010-07-02 05:38    &nb...

1，在操作系统的系统变量中配置     JAVA_HOME=D:\oracle\product\10.2.0\db_1\jdk  --JAVA_HOME不区分大小写##注：目录只用写到jdk就成，不用写下面的bin，我就写到bin,死活连接不上!&...

SQL> drop table c_subjecttypeinfo purge;drop table c_subjecttypeinfo purge           *ERROR at line 1:ORA-02449: unique/primary keys in table referenc...

http://h1yn.itpub.net/post/2084/245634

SQL> create or replace procedure p_find_question_by_title(v_title varchar2,o_result out sys_refcursor)  2  --在线答疑显示所有问题  3    4  --显示的列：学段，科目,题目内容...

SQL> create or replace procedure p_query_all_question(o_result sys_refcursor)  2  --在线答疑显示所有问题  3    4  --显示的列：学段，科目,题目内容,提问者，浏览数，状态，更...

http://asdic.广告  dbms_workload_repository dba_scheduler_jobs  dbms_scheduler latch contention

SQL> create view v_e_teacherloginfo as select * from e_teacherlogininfo;View created.SQL> select name,type,referenced_owner,referenced_name,dependency_type from user_dependencies;NAME  &n...

1  create or replace procedure p_dept(v_deptno number,v_dname out varchar2,v_loc out varchar2)  2  as  3  begin  4  select dname,loc into v_dname,v_loc from dept whe...

SQL> select * from tab where tname like 'PL%';TNAME                        &nbs...

1,运行regedit2,依次展开hkey_local_machine/software/wow6430node/orac,le3,最后点选右侧的NLS_LANG，进行对应修改就可以了

http://www.nipei.com/article/10450

intersect取二结果集的交集,且去除重复值union取二结果集的并集,且去除重复值 union all同上,但区别之处在于,不会去除重复值  minus 取二结果集的差集;大意为取结果集一不在结果集二的(,去除重复值)的结果...

RMAN> configure channel device type disk format '/oracle/orclarch/%U_%d';new RMAN configuration parameters:CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oracle/orclarch/%U_%d';new RMAN conf...

SQL> r  1  declare  2  v_sid v$session.sid%type; #定义如下两个type类型，用于接收cursor  3  v_serial# v$session.serial#%type;  4  cursor cur_session is select si...

1  create or replace procedure p_adjust_salary(emp_id number,sal in out number)  2   is  3     emp_job varchar2(10);  4     avg_sa...

SQL> var x refcursorSQL> exec pkg_e_teacherlogininfo.p_veriry_teacher_login('1','1',:x);PL/SQL procedure successfully completed.SQL> print :xLOGINID        &...