oracle²»ÄÜÕý³£Ìí¼ÓÊý¾Ý
´ó¼ÒºÃ£¬ÎÒµÄÎÊÌâÈçÏ£º
Ê×ÏÈ£¬ÎÒÔÚcommandWindows Ö´ÐÐsqlÓï¾ä¡£Ö´ÐкóµÄÌáʾÊÇ£º
SQL> insert into client_info(clientid) values(1);
1 row inserted
µ«Êǵ±ÎҲ鿴±íʱ£¬È´Ã»Óз¢ÏÖÐÂÔö¼ÓµÄÊý¾Ý¡£²¹³ä˵Ã÷£ºÎÒµÄÊý¾Ý±íÀïÃæÔÊÐí¸÷ÏîΪ¿ÕµÄ¡£
ûÓÐcommit
Ö´ÐÐÒ»¸öcommit;¾Í¿ÉÒÔÁË
Ö´ÐÐÍêÖ®ºó£¬°´Ï F10°´Å¥ »òÕßд commit; È»ºó»Ø³µ ¼´¿É£¡
good luck!
commit;¾ÍokÁË
ͬÒâÂ¥ÉϵÄ
commit
commit, È»ºóÔÙ¿´¿´
ºÇºÇ£¬»Ø¸´ÍíÁË£¬Ð»Ð»´ó¼Ò£¡Ôõô¸ø·Ö°¡£¬ÎÒÊÇÐÂÊÖ£¬»¹²»¶®¡£
µÚÒ»¸ö¶àµã·Ö£¬ÆäËûƽ·Ö£¬Ð»Ð»£¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
´æ´¢¹ý³Ì£º
create or replace procedure insert_emp
(empid in number,
empname in varchar2,
empsal in number)
as
begin
insert into emp(empno,ename ......