ÏëѧoracleÊý¾Ý¿â£¬Ôõô°ì£¿
ÎÒѧ¹ýsql server£¬ÏÖÔÚÏë×Ôѧoracle£¬ÈçºÎÏÂÊÖ£¿ÂòÊéºÃÂ𣿻¹ÊÇÍøÉÏÕÒ×ÊÁÏ£¿
Èç¹ûÂòÊéºÃ£¿½éÉܼ¸±¾ÊµÓÃÒ×¶®µÄ£¡Èç¹ûÍøÉÏѧºÃ£¬ÍƼöµã×ÊÁÏ¡£
Ìý˵ѧoracle 9i±È½ÏºÃ£¬ÎÒÏë°²×°ÄǸö£¬ÄÄÀïÓÐÏÂÔØµÄ£¿Ôõôװ£¿
ÎÒµÄÓÊÏäÊÇ£ºbobo_her_2999@163.com
QQ£º535241678
лл£¡£¡£¡
Ïëѧ¾Í¶àÁ·£¬¶àд£¬¶àʵ¼ù£¬³ý´ËÖ®Íâû±ðµÄÑ¡Ôñ¡£
9iºÍ10gµ½µ×ÄĸöºÃ£¿ÆóÒµÖÐÓÃÄĸö±È½Ï¶àѽ£¿
Ö÷Á÷10G°¡,²»¹ýѧϰµÄ»°½¨ÒéÓÃ11G°É,±È½ÏÏòϼæÈÝ
Ïëѧ¾Íѧ£¬Ïë³Ô¾Í³Ô!!
ÍÆ¼ö¼¸±¾Êé
»ù´¡µÄ£º
Oracle 10g ÈëÃÅÓëÌá¸ß
¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩
OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g
½ø½×·½ÃæµÄ£º
oracleʵÓü¼ÊõÏê½â
Oracle 9i/10g±à³ÌÒÕÊõ
Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯
×îÈ«ºÍ×îȨÍþµÄ£º
oracle×Ô´øÎĵµ
Oracle database 10g »ù´¡½Ì³Ì £¨µÚ¶þ°æ£©
ÎÒÕýÔÚѧ..
¿ª·¢»¹ÊÇά»¤£¬ÏÖÔÚÖ÷Á÷µÄÊÇ10G£¬ÍâÃæµÄ×ÊÁÏÒ²ºÜ¶à£¬ËùÒÔѧϰ½¨ÒéÓÃ10gµÄ£¬Óöµ½ÎÊÌ⣬google Ò²ÄÜÕÒµ½´ð°¸¡£
¿ª·¢µÄ»°¾Í¶à¿´Ð©SQLµÄÊ飬ά»¤µÄ»°¾Í¿´¹ÜÀíµÄ¡£
------------------------------------------------------------------------------
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
×Ô¼º°²×°Ò»¸ö10g£¬Ïë×Å·¨°ÑËû¸øÍæËÀÁË£¬È»ºóÏë×Å·¨¸øËû»Ö¸´¡£¡£È»ºóÄã¾ÍÊÇ´óÅ£ÁË¡£¡£
ÓÐSQL SER
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
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 ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......