ORACLE ͨ¹ýÓαêʹÓÃÀ´Á˽âcursor µÄºÃ´¦£¡
ÓÐÁËÓα꣬¾Í¿ÉÒÔ²»ÓÃÿÌõÊý¾ÝÈ¥¼ì²éÊÇ·ñ·ûºÏÌõ¼þ£¬ÏÈ¿´Ò»ÏÂÏÂÃæµÄ£º
--ÓαêʹÓã¨ÓαêÆäʵÊÇÒ»¸ö·ÅÈëÄÚ´æÁÙʱ±í£©
declare
money cms3_simcard.card_fee%type :=0; --¶¨ÒåÓë±í×Ö¶ÎÏàͬÀàÐÍ
cursor mycursor is --¶¨ÒåÓαê
select * from cms3_simcard
where return_flag = 1 and msisdn like '138%';
my_record mycursor%rowtype; --¶¨ÒåÓαê¼Ç¼ÀàÐÍ
Counter int :=0;
begin
open mycursor; --´ò¿ªÓαê
if mycursor%isopen then --Åжϴò¿ª³É¹¦
loop --Ñ»·»ñÈ¡¼Ç¼¼¯
fetch mycursor into my_record; --»ñÈ¡ÓαêÖеļǼ
if mycursor%found then --ÓαêµÄfoundÊôÐÔÅжÏÊÇ·ñÓмǼ
dbms_output.put_line(my_record.card_fee);
else
exit;
end if;
end loop;
else
dbms_output.put_line('ÓαêûÓдò¿ª');
end if;
close mycursor;
end;
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
1.²é¿´±í¿Õ¼ä:
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES*100)/A.BYTES "% FREE"
from SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE C
WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.T ......
http://space.itpub.net/9134/viewspace-166486
¾³£ÓÐÈË»áÐèÒªOracleÊý¾Ý¿âËæ×ŲÙ×÷ϵͳһÆðÆô¶¯ºÍ¹Ø±Õ£¬¶øÐÞ¸Ä/etc/oratab,ÉèÖÃÁËoracle SIDÐÐÆô¶¯ÎªYʱʵ¼ÊÉÏÊDz»ºÃÓõġ£±¾ÎÄÒÔÒ»¸öÀý×ÓÀ´Ê¾·¶ÈçºÎÈ¥×ö¡£
ÈçϸøµÄÊÇÒ»¸öexample£¬×¢Òⲿ·ÖÄÚÈÝ¿ÉÄÜÒª¸Ä£¬±ÈÈçoracleµÄÓû§Ãû¡£
1¡¢ÔÚ/sbin/init.d/Ŀ¼Ï½¨Á¢Ò»¸öÎļþ£¬ ......
1.Oracleɾ³ýÖظ´¼Ç¼.
ɾ³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´Åжϣ¬Ö»ÁôÓÐrowid×îСµÄ¼Ç¼.
delete from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
and rowid not i ......