Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle´æ´¢¹ý³Ì

create or replace procedure inserttestdata
(
   v_count        in   number,
   v_startuserid  in   varchar2,
   v_returnval    out  number )
as
   v_opertime           varchar2(20);
   v_current_count      number(10);
   v_temp_userid        varchar2(20);
begin
   v_opertime   := to_char(sysdate,'yyyy.mm.dd');
   v_current_count      := 0;
   v_temp_userid        := v_startuserid;
  
   while 1=1 loop
   savepoint begin_tran;
   begin
      insert into ardinf(userid ,opertime)
       values(v_temp_userid ,v_opertime);
        exception
      when others then
      begin
         rollback to savepoint begin_tran;
         DBMS_OUTPUT.PUT_LINE('exception!');
         DBMS_OUTPUT.PUT_LINE(v_temp_userid);
         v_returnval := 1008;
         exit;
         --exitÖ®ºóµÄ´úÂëÎÞ·¨Ö´ÐÐ
         DBMS_OUTPUT.PUT_LINE('After exit!Before return');
         DBMS_OUTPUT.PUT_LINE(v_returnval);
         return;
         DBMS_OUTPUT.PUT_LINE(v_returnval);
      end;
   end;
   if v_current_


Ïà¹ØÎĵµ£º

Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©


Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
 Name &nbs ......

oracleÌåϵ½á¹¹Ò»

        oracleÊÇÒ»ÖÖ´óÐ͵ġ¢¿ÉÒÆÖ²µÄ¶ÔÏó¹ØÏµÐÍÊý¾Ý¿â¡£ËüÔÚÏà¹ØµÄÿһ¸öƽ̨É϶¼¿ÉÒÔÔËÐУ¬Òò´ËoracleµÄÌåϵ½á¹¹ÔÚ²»Í¬µÄ²Ù×÷ϵͳÉÏÊÇÓÐËù²»Í¬µÄ¡£±ÈÈçÔÚUNIXϵͳÉÏ£¬ÒòΪUNIXϵͳÊǹ¤×÷ÔÚ¶à½ø³ÌµÄ»ù´¡ÉÏ£¬ËùÒÔoracleÔËÐÐʱÌåÏÖΪ¶à¸ö½ø³ÌÔÚÔËÐС£È»¶øÔÚwindowsϵͳÉÏ£¬windowsÏµÍ³Ê ......

oracle ÈçºÎ°ÑÊý¾Ý¿â±äΪ·Ç¹éµµÈÕ־ģʽ

shutdown immediate
Ç¿Áв»½¨ÒéתΪ·Ç¹éµµÄ£Ê½
startup mount
alter database noarchivelog
alter database open
·Ç¹éµµ×ª¹éµµ
startup mount
alter database archivelog
alter database open
Ôڹ鵵ÈÕ־ģʽÏ£¬ÓпÉÄÜ»áÓöµ½¹éµµÈÕÖ¾´óС³¬¹ý×î´óÖµ¶ø³öÏÖÌÖÑáµÄORA-00257´íÎó£¬Ç°ÃæËµÁËÈçºÎ°Ñ¹éµµÈÕÖ¾¿Õ¼ä±ä´ó¡£¶ ......

¼±¾È£¡£¡£¡Ôõô¶¼Á¬½Ó²»µ½oracleÊý¾Ý¿â

2010-03-02 16:12:01,515 ERROR (Prototyper.java:105) - Prototype
java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connection
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(Da ......

Oracle Silent Installations(¾²Ä¬°²×°)


 
Linux Æ½Ì¨ÏÂOracle Silent Installations(¾²Ä¬°²×°)£¬Ò»Ö±¶¼Ã»Óг¢ÊÔ¹ýÓÃÕâÖÖ·½·¨À´×°Êý¾Ý¿â¡£ ÒòΪÓи߼¶µÄ¹¤¾ß£¬¾ÍûÓбØÒªÔÚÀ´ÓÃÕâÖÖ·½·¨ÁË£¬Oracle µÄ½çÃæ»¹ÊDZȽϷ½±ã£¬¶øÇÒÎÒÃÇ»¹ÓÐXmanager ¹¤¾ß£¬ËùÒÔÔÚlinux ÏÂ×°Èí¼þ£¬»¹ÊǺܷ½±ãµÄ¡£
 
Òò´ËÒ²¾ÍûÓÐÌ«ÔÚÒâÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ