ORACLEÓαê
ORACLEÓαê
Óα꣺ÈÝÆ÷£¬´æ·Åµ±Ç°SQLÓï¾äÓ°ÏìµÄ¼Ç¼
ËùÓÐDMLÓï¾ä¶¼»áÓõ½Óαê
ÖðÐд¦ÀíÓ°ÏìµÄÐÐÊý
Óαê
¾²Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐÇ°¹ØÁª
¶¯Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐʱ¹ØÁª
Óαê
ÒþʽÓα꣺×Ô¶¯ÉùÃ÷¡¢´ò¿ª¡¢¹Ø±Õ£¬ÆäÃûSQL
ÏÔʽÓα꣺
REFÓα꣺£¨¶¯Ì¬Óα꣩
ÏÔʽÓαê²Ù×÷¹ý³Ì
ÉùÃ÷Óα꣨¹ØÁªSQLÓï¾ä£© cursor Ãû×Ö is/as sqlÓï¾ä£¨DML£©;
´ò¿ªÓαִ꣨ÐÐSQLÓï¾ä£¬Ìî³äÓα꣩ open Ãû×Ö;
´ÓÓαêÖÐÌáÈ¡Öµ£¬´æ·Åµ½ÐÐÀàÐͱäÁ¿ÖÐ fetch Ãû×Ö into ÐÐÀàÐͱäÁ¿;
¹Ø±ÕÓαê close Ãû×Ö;
declare
empR emp%rowtype;
--ÉùÃ÷Óαê(¹ØÁªSQLÓï¾ä)
cursor empCursor
is
select * from emp;
begin
--´ò¿ªÓαִ꣨ÐÐSQLÓï¾ä£¬Ìî³äÓα꣩
open empCursor;
loop
--´ÓÓαêÖÐÌáÈ¡Öµ£¬´æ·Åµ½ÐÐÀàÐͱäÁ¿ÖÐ
fetch empCursor into empR;
exit when empCursor%notfound;--ÓαêÖÐûÓÐÊý¾ÝʱÍ˳öÑ»·
dbms_output.put_line(empR.ename||' '||empR.sal);
end loop;
--¹Ø±ÕÓαê
close empCursor;
end;
SQL>
Ïà¹ØÎĵµ£º
1
2
3
×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7
½¨Á¢±í¿Õ¼ä
8
9
CREATE TABLESPACE data01
10
DATAFILE '/oracle/oradata/d ......
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£
¡¡¡¡OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó £¨Í¨¹ýnet8 assistantÖб¾µØ——>·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû
¡¡¡¡Æ ......
1.´´½¨Ñ§Éú±í£º
CREATE TABLE student (
xh number primary key,
Name varchar2(10) not null);
2. ´´½¨ÐòÁУº
CREATE SEQUENCE student_seq
START WITH 1
INCREMENT BY 1
NOCACHE;
°´»Ø³ ......
http://tech.163.com/05/0701/10/1NIODMQS00091589.html
ÒòΪÔÚPL/SQL Öв¢Ã»ÓÐÊý×é.
ÕâÊÇż²é×ÊÁÏÕҵķ¶ÀýºÍ×Ô¼ºÐ´µÄ·¶ÀýÀ´½âÊÍÈçºÎÔÚPL/SQL ÖÐʹÓÃÊý×é. Ò²ÐíºÜ¶àÈËÒÑÖªµÀ, ²»¹ý¾ÍÊÇÈò»ÖªµÀµÄÅóÓÑÃÇÁ˽âһϰɡ£
----------------------
µ¥Î¬Êý×é
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......
ORACLE Êý¾Ý¿â¶ÔÏó
——Ë÷Òý
q Ë÷ÒýÊÇÓë±íÏà¹ØµÄÒ»¸ö¿ÉÑ¡½á¹¹
q ÓÃÒÔÌá¸ß SQL Óï¾äÖ´ÐеÄÐÔÄÜ
q ¼õÉÙ´ÅÅÌI/O
q ʹÓà CREATE INDEX Óï¾ä´´½¨Ë÷Òý
q &n ......