ITPub博客

第 1 行出现错误:ORA-23515: 实体化视图和/或它们的索引存在于表空间中1、查这个表空间有哪些mview的语句：select table_name, tablespace_name from dba_tableswhere tablespace_name='EXAMPLE'   &...

rac 缺失本地节点node1的信息问题原因:public网卡和private网卡设置反了会出现这个问题要修改网卡的优先级，public的高于private的，具体步骤就是：右键网络邻居－》选择属性－》进入后选择windows菜单里面的高级－...

SQL> execute dbms_logmnr.add_logfile('/opt/oracle/oradata/archive/1_53_724790729.dbf',dbms_logmnr.removefile);PL/SQL procedure successfully completed.SQL> execute dbms_logmnr.add_logfile('/opt/oracle/...

ORA-07445: exception encountered: core dump [krvrdegsFF()+21] [SIGSEGV] [Address not mapped to object] 未解决，记录一下SQL> SELECT sql_redo FROM v$logmnr_contents;  SELECT sql_redo FROM v$logmnr_...

数据库恢复后错误：SQL> create user testuser identified by testuser;create user testuser identified by testuser               ...

SQL> conn sys/xxxdb@xxxdb as sysdbaERROR:ORA-01031: insufficient privileges原因：没有密码文件orapwd oracle@standby:~/product/10.2/db_1/network/admin> oerr ora 103101031, 00000, "insufficient privilege...

 SQL> host oerr ora 31400314, 00000, "log %s of thread %s, expected sequence# %s doesn't match %s"// *Cause:  The online log is corrupted or is an old version.// *Action: Find and install co...

Sun Jul 18 21:47:20 2010Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_j000_4337.trc:ORA-00600: internal error code, arguments: [4193], [362], [536], [], [], [], [], []Sun Jul 18 21:47:23 2010Doin...

ORA-00313: open failed for members of log group 4 of thread 0ORA-00312: online log 4 thread 0: '/opt/oracle/oradata/xxxdb/standbyredo04.log'ORA-27037: unable to obtain file statusLinux Error: 2: No su...

SQL>  conn testhotback/testhotback;Connected.SQL> create table test (id number,name varchar2(10));create table test (id number,name varchar2(10))*ERROR at line 1:ORA-01552: cannot use system roll...

显示系统运行时间uptimesysteminfo目录树F:>tree f:>list.txt /f[@more@]

使用set serveroutput on 命令设置环境变量serveroutput为打开状态，从而使得pl/sql程序能够再SQL*plus和SQL*plus中输出结果set serveroutput on--set serveroutput offDeclarev_empno emp.empno%Type; /*声明变量v_empno,%type:使该变量的类型与emp表中的empno类型相同*/v_emprecord emp%Rowtype;/*声明变量v_emprecord,%rowtype:使该变量的类型与emp表中的整行相同*/BeginSelect * Into v_emprecord From emp Where empno=&v_empno;dbms_output.put_line('雇员编号 '||v_emprecord.empno);dbms_output.put_line('雇员姓名 '||v_empr

参见:http://dev.yesky.com/SoftChannel/72342371928965120/20021014/1634646_1.shtmlLTRIM(c1,c2)　　把c1中最左边的字符去掉，使其第一个字符不在c2中，如果没有c2，那么c1就不会改变。SQL> select LTRIM('Mississippi','Mis') from dual;LTR---ppiSQL> select LTRIM('Mississippi','Mi') from dual;LTRIM('MI---------ssissippiSQL> select LTRIM('Mississippi','M') from dual;LTRIM('MIS----------ississippiSQL> select LTRIM('Mississippi',) from dual;select LTRIM('Mississippi',) from dual

SQL> CREATE OR REPLACE PROCEDURE COUNT_EMP 2 ( 3 reccount OUT NUMBER 4 ) 5 IS 6 BEGIN 7 SELECT COUNT(*) INTO reccount 8 FROM emp; 9 END COUNT_EMP; 10 /过程已创建。SQL> execute COUNT_EMPBEGIN COUNT_EMP; END; *ERROR 位于第 1 行:ORA-06550: 第 1 行, 第 7 列:PLS-00306: 调用 'COUNT_EMP' 时参数个数或类型错误ORA-06550: 第 1 行, 第 7 列:PL/SQL: Statement ignoredSQL> show errors没有错误。SQL> execute COUNT_EMPBEGIN COUNT_EMP; END; *ERROR 位于第 1 行:ORA-0655

plsql 控制结构参见：http://www.programbbs.com/doc/73.htm语法和用途　　　IF..THEN　　语法： IF condition THEN　Statements 1;　Statements 2;　....END IF IF..THEN...ELSE　　语法: IF condition THEN　Statements 1;　Statements 2;　....ELSE　Statements 1;　Statements 2;　....END IFIF..THEN..ELSIF循环控制　　循环控制的基本形式是LOOP语句，LOOP和END LOOP之间的语句将无限次的执行。LOOP语句的语法如下：　　LOOP 　　　statements;　　END LOOPWHILE..LOOP　　WHILE..LOOP有一个条件与循环相联系，如果条

在另一个命名程序块或匿名程序块中执行这个程序，那么就不需要EXECUTE关进字。SQL> conn scott/tiger已连接。SQL> declare 2 v_dept number; 3 begin 4 select deptno 5 into v_dept 6 from emp 7 where job='PRESIDENT'; 8 update_commission(v_dept); 9 end; 10 /PL/SQL 过程已成功完成。SQL> select sal,comm from emp where deptno=10; SAL COMM---------- ---------- 2450 24500 5000 50000 1300 13000declarev_dept number;beginselect deptnointo v_deptfrom

select..into is part of PL/SQL language which means you have to use it inside a PL/SQL block. You can not use it in a SQL statement outside of PL/SQL. select into 的是一个值，而不是一个记录集http://www.itpub.net/251630.html[@more@]

SQL> select sal,comm from emp where deptno=10; SAL COMM---------- ---------- 2450 24500 5000 50000 1300 13000SQL> execute update_commission(10,15);PL/SQL 过程已成功完成。SQL> select sal,comm from emp where deptno=10; SAL COMM---------- ---------- 2450 36750 5000 75000 1300 19500执行的参数SQL> execute update_commission(10,15);PL/SQL 过程已成功完成。SQL> select sal,comm from emp where deptno=10;

SQL> create or replace procedure update_commission 2 　(v_dept in number,v_pervent in number default 10) is 3 begin 4 　update emp 5 　set comm=sal*v_percent 6 　where deptno=v_dept; 7 end 8 / 警告: 创建的过程带有编译错误。 SQL> show error PROCEDURE UPDATE_COMMISSION 出现错误: LINE/COL ERROR -------- ----------------------------------------------------------------- 2/2 PLS-00103: 出现符号 ""在需要下列之一时： ( ; is with a

SQL> select comm from emp where deptno=10; COMM---------- SQL> declare 2 v_comm_percent constant number:=10; 3 begin 4 update emp 5 set comm=sal*v_comm_percent 6 where deptno=10; 7 end 8 /end *ERROR 位于第 7 行:ORA-06550: 第 7 行, 第 3 列:PLS-00103: 出现符号 "end-of-file"在需要下列之一时：; <an identifier><a double-quoted delimited-identifier>符号 ";" 被替换为 "end-of-file" 后继续。SQL> declare 2 v_comm_percent constant