Çë½Ì ѧϰORACLEÊé¼®
ÓÐÄÄЩÊé¼®ÊÇѧϰoracle¿ª·¢±È½ÏºÃµÄÊé¼®£¿
Oracle9iHelp Oracle10gSQLRef Oracleר¼Ò¸ß¼¶±à³Ì ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éOracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£© »ù´¡µÄ£º Oracle 10g ÈëÃÅÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩 OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g ½ø½×·½ÃæµÄ£º oracleʵÓü¼ÊõÏê½â Oracle 9i/10g±à³ÌÒÕÊõ Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯ ×îÈ«ºÍ×îȨÍþµÄ£º oracle×Ô´øÎĵµÒýÓà »ù´¡µÄ£º Oracle 10g ÈëÃÅÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩 OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g ½ø½×·½ÃæµÄ£º oracleʵÓü¼ÊõÏê½â Oracle 9i/10g±à³ÌÒÕÊõ Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯ ×îÈ«ºÍ×îȨÍþµÄ£º oracle×Ô´øÎĵµ up... ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ¡¶Oracle DBA Åàѵ½Ì³Ì¡· ¡¶Oracle Database 10g SQL¿ª·¢Ö¸ÄÏ¡· ¡¶ÉîÈë½âÎöOracle——DBAÈëÃÅ¡¢½ø½×ÓëÕï¶Ï°¸À
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dnam ......
Á½¸ö±í Çë¿´ "Persons" ±í£º name banji shunxu yiyang 01 1 yiyang 02 1 lili 01 2 ½ÓÏÂÀ´Çë¿´ "xueke" ±í£º name kemu shunxu yiy ......