OracleÓαêʹÓù¥ÂÔ
Sql´úÂë
1.
´ÓÓαêÌáÈ¡Êý¾Ý
2. ´ÓÓαêʧȥһÆðÊý¾ÝÔËÓÃFETCHÏÂÁÿһ´ÎÌáÈ¡Êý¾Ýºó£¬Óα궼ָÏò½á¹û¼¯µÄÏÂÒ»Æð¡£Óï·¨Èç´Î£º
3. FETCH cursor_name INTO variable[,variable,...]
4. ÖÁÓÚSELECT¶¨ÒåµÄÓαêµÄÿһÁУ¬FETCH±äÁ¿ÁÐ±í¶¼Ó¦¸ÃÓÐÒ»¸ö±äÁ¿ÓëÖ®Ïà¶ÔÓ¦£¬±äÁ¿µÄ²¿ÀàÒ²ÒªÀ×ͬ¡£
Àý£º
5. SET SERVERIUTPUT ON
6. DECLARE
7. v_ename EMP.ENAME%TYPE;
8. v_salary EMP.SALARY%TYPE;
9. CURSOR c_emp IS SELECT ename,salary from emp;
10. BEGIN
11. OPEN c_emp;
12. FETCH c_emp INTO v_ename,v_salary;
13. DBMS_OUTPUT.PUT_LINE('Salary of Employee'|| v_ename ||'is'|| v_salary);
14. FETCH c_emp INTO v_ename,v_salary;
15. DBMS_OUTPUT.PUT_LINE('Salary of Employee'|| v_ename ||'is'|| v_salary);
16. FETCH c_emp INTO v_ename,v_salary;
17. DBMS_OUTPUT.PUT_LINE('Salary of Employee'|| v_ename ||'is'|| v_salary);
18. CLOSE c_emp;
19. END
20.
21. Õâ¶Î´úÂëÎÞÒÉÊÇ·ÇÇúÖ±³£Àͼݵģ¬Èç¹ûÓжàÐлص½½á¹û£¬¿ÉÒÔÔËÓÃÑ»·²¢ÓÃÓαêÊôÐÔΪÖÕ½áÑ»·µÄÌõ¼þ£¬ÒÔÕâÖÖÐÎʽÌáÈ¡Êý¾Ý£¬³ÌÐòµÄ¿É¶ÁÐԺͼò½àÐÔ¶¼¼«Îª°Î¸ß£¬Ï²¿ÎÒÃÇÔËÓÃÑ»·´ÓÐÂдÉÏÍ·µÄ³ÌÐò£º
22.SET SERVERIUTPUT ON
23.DECLARE
24.v_ename EMP.ENAME%TYPE;
25.v_salary EMP.SALARY%TYPE;
26.CURSOR c_emp IS SELECT ename,salary from emp;
27.BEGIN
28.OPEN c_emp;
29. LOOP
30. FETCH c_emp INTO v_ename,v_salary;
31. EXIT WHEN c_emp%NOTFOUND;
32. DBMS_OUTPUT.PUT_LINE('Salary of Employee'|| v_ename ||'is'|| v_salary);
33.END
34.
35.¼ÇÒª±äÁ¿
36. ¶¨ÒåÒ»¸ö¼ÇÒª±äÁ¿ÔËÓÃTYPEÏÂÁîºÍ%ROWTYPE£¬¶ÔÓÚ%ROWsTYPEµÄ¸ü¶àÐÅÏ¢Çë²ÎÔÄÓйØÎļþ¡£
37. ¼ÇÒª±äÁ¿ÓÃÀ´´ÓÓαêÖÐÌáÈ¡Êý¾ÝÐУ¬Ó¦ÓαêÈ¡ÉáºÜ¶àÁеÄʱ·Ö£¬ÄÇôʩÓüÇÒª±ÈΪÿÁÐÐûÑÔÒ»¸ö±äÁ¿Òª±ãÀûµÃ¶à¡£
38. µ±ÔÚ±íÉÏÔËÓÃ%ROWTYPE²¢½«´ÓÓαêÖÐÌͳöµÄÖµ·ÅÈë¼ÇÒªÖÐʱ£¬ÈçÆäҪȡÉá±íÖÐÈ«²¿ÁУ¬ÄÇôÔÚSELECT×Ó¾äÖÐÓ¦ÓÃ*±È½«È«²¿ÁÐÃûÁгöÀ´ÒªµÃ¶à¡£
Àý£º
39.SET SERVERIUTPUT ON
40.DECLARE
41.R_emp EMP%ROWTYPE;
42.CURSOR c_emp IS SELECT * from emp;
43.BEGIN
44.OPEN c_emp;
45. LOOP
46. FETCH c_emp INTO r_emp;
47. EXIT WHEN c_emp%NOTFOUND;
48. DBMS_OUT.PUT.PUT_LINE('Salary of Employee'||r_emp.ename|
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÒÔÏ»شðÊôÓÚתÔØ£º
¾³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨Ë ......
net use \\ip\ipc$ " " /user:" " ½¨Á¢IPC¿ÕÁ´½Ó
net use \\ip\ipc$ "ÃÜÂë" /user:"Óû§Ãû" ½¨Á¢IPC·Ç¿ÕÁ´½Ó
net use h: \\ip\c$ "ÃÜÂë" /user:"Óû§Ãû" Ö±½ÓµÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use h: \\ip\c$ µÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use \\ip\ipc$ /del ɾ³ýIPCÁ´½Ó
net use h: /del ɾ³ýÓ³Éä¶Ô·½µ½±¾µ ......
<Ò»>ʵÏÖɱËÀij¸öÓû§µÄ¿Í»§¶ËÁ¬½Ó½ø³Ì
1.ÒÔ¹ÜÀíÔ±Éí·ÝµÇ¼ºó²é¿´V$SESSIONµÄÊÓͼ½á¹¹
SQL> desc v$session;
Ãû³Æ &n ......
¹ØÓÚoracleµÄÐм¶Ëø
¡¡¡¡ÔÚoracleÖÐ,Ðм¶ËøÖ»¶ÔÓû§ÕýÔÚ·ÃÎʵÄÐнøÐÐËø¶¨¡£
¡¡¡¡Èç¹û¸ÃÓû§ÕýÔÚÐÞ¸ÄijÐУ¬ÄÇôÆäËûÓû§¾Í¿ÉÒÔ¸üÐÂͬһ±íÖиÃÐÐÖ®ÍâµÄÊý¾Ý¡£
¡¡¡¡Ðм¶ËøÊÇÒ»ÖÖÅÅËûËø£¬·ÀÖ¹ÆäËûÊÂÎñÐ޸ĴËÐУ¬µ«ÊDz»»á×èÖ¹¶ÁÈ¡´ËÐеIJÙ×÷
¡£
¡¡¡¡ÔÚʹÓÃINSERT¡¢UPDATE¡¢DELETE ºÍSELECT…FOR UPDATE µÈÓï¾äʱ ......