Çë½Ì ѧϰORACLEÊé¼®
ÓÐÄÄЩÊé¼®ÊÇѧϰoracle¿ª·¢±È½ÏºÃµÄÊé¼®£¿
Oracle9iHelp
Oracle10gSQLRef
Oracleר¼Ò¸ß¼¶±à³Ì
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî)
È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±é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 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
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 ......
ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?
ûÓÐÁªÏµµÄ
exp, imp
ÎÒÒª°ÑÆäÖеÄÁ½ ......