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

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|


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle·ÖÎö±íºÍË÷Òý(analyze)

analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......

oracleÊý¾Ý¿âÖÐsql»ù´¡ ÉîδÀ´

oracleÊý¾Ý¿âÖÐsql»ù´¡
×÷ÕߣºØýÃû    ×ªÌù×Ô£º±¾Õ¾Ô­´´    ä¯ÀÀ´ÎÊý£º21    ÎÄÕ¼È룺admin
Ò»¡¢¹ØϵÊý¾Ý¿âµÄһЩ¸ÅÄî
¡¡¡¡
¡¡¡¡1¡¢Ö÷¼üµÄÖµÒ»°ã²»¿ÉÒԸıä
¡¡¡¡
¡¡¡¡2¡¢Íâ¼ü£ºÖ¸ÏòÁíÒ»¸ö±í»ò±¾±íµÄÖ÷¼ü»òΨһ¼üµÄ×ֶΡ£Íâ¼üµÄÖµÒ»¶¨ÒªºÍijһÖ÷¼üÏàͬ ......

oracleÈÕÆÚº¯Êý¼¯ ÉîδÀ´

OracleÔÚÈÕÆÚʹÓÃÉÏÔÊÐí¼«´óµÄÁé»îÐÔ¡£ÓÉÓÚ¿ÉÒÔÔÚÈÕÆÚ×ֶδ洢ʱ¼äºÍÈÕÆÚ£¬´Ó¶øÓк¯Êý¿ÉÒÔ¼ÈÒýÓÃÈÕÆÚÓÖÒýÓÃʱ¼ä¡£
Oracle ËùÌṩµÄһЩÈÕÆÚº¯ÊýÈçÏÂËùʾ¡£
1. SYSDATE
·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä¡£
ʾÀý
SELECT sysdate from dual;
SYSDATE
----------
05-3ÔÂ -03
2. ADD_MONTHS(d, no_of_month)
µ±Ç°ÈÕÆÚ"m"ºóÍÆ"no_o ......

¹ØÓÚoracleµÄÐм¶Ëø

¹ØÓÚoracleµÄÐм¶Ëø
¡¡¡¡ÔÚoracleÖÐ,Ðм¶ËøÖ»¶ÔÓû§ÕýÔÚ·ÃÎʵÄÐнøÐÐËø¶¨¡£
¡¡¡¡Èç¹û¸ÃÓû§ÕýÔÚÐÞ¸ÄijÐУ¬ÄÇôÆäËûÓû§¾Í¿ÉÒÔ¸üÐÂͬһ±íÖиÃÐÐÖ®ÍâµÄÊý¾Ý¡£
¡¡¡¡Ðм¶ËøÊÇÒ»ÖÖÅÅËûËø£¬·ÀÖ¹ÆäËûÊÂÎñÐ޸ĴËÐУ¬µ«ÊDz»»á×èÖ¹¶ÁÈ¡´ËÐеIJÙ×÷
¡£
¡¡¡¡ÔÚʹÓÃINSERT¡¢UPDATE¡¢DELETE ºÍSELECT…FOR UPDATE µÈÓï¾äʱ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ