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

oracle²»ÄÜÕý³£Ìí¼ÓÊý¾Ý

´ó¼ÒºÃ£¬ÎÒµÄÎÊÌâÈçÏ£º
Ê×ÏÈ£¬ÎÒÔÚcommandWindows Ö´ÐÐsqlÓï¾ä¡£Ö´ÐкóµÄÌáʾÊÇ£º

SQL> insert into client_info(clientid) values(1);

1 row inserted

µ«Êǵ±ÎҲ鿴±íʱ£¬È´Ã»Óз¢ÏÖÐÂÔö¼ÓµÄÊý¾Ý¡£²¹³ä˵Ã÷£ºÎÒµÄÊý¾Ý±íÀïÃæÔÊÐí¸÷ÏîΪ¿ÕµÄ¡£
ûÓÐcommit

Ö´ÐÐÒ»¸öcommit;¾Í¿ÉÒÔÁË

Ö´ÐÐÍêÖ®ºó£¬°´Ï F10°´Å¥  »òÕßд commit; È»ºó»Ø³µ ¼´¿É£¡

good luck!

commit;¾ÍokÁË

ͬÒâÂ¥ÉϵÄ

commit

commit, È»ºóÔÙ¿´¿´

ºÇºÇ£¬»Ø¸´ÍíÁË£¬Ð»Ð»´ó¼Ò£¡Ôõô¸ø·Ö°¡£¬ÎÒÊÇÐÂÊÖ£¬»¹²»¶®¡£

µÚÒ»¸ö¶àµã·Ö£¬ÆäËûƽ·Ö£¬Ð»Ð»£¡


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

javaµ÷´æ´¢¹ý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

´æ´¢¹ý³Ì£º
create or replace procedure insert_emp
 (empid in number,
 empname in varchar2,
 empsal in number)
 as
 begin 
  insert into emp(empno,ename ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ