Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

oracleÆæ¹ÖÎÊÌâ

ÔÚPL/SQL developerÏ´´Ò»¸ö±í£¬¶øÔÚsqlplusÏÂÈ¥Ö´ÐÐÒ»Ìõ²åÈëÊý¾Ýºó£¬ÔÙͨ¹ýPL/SQL developerÈ¥²é¿´£¬È´²é²»³öÊý¾Ý
£¬µ«Äܲé³ö±íȷʵÊÇ´æÔÚµÄ,ÎÒÓÃdesc table ²é¿´ÁËÏ£¬ÇëÎÊÕâÊÇʲôÎÊÌ⣿

ȷʵҪcommitһϣ¬Ð»ÁË£¬¸ø·Ö½áÌû

»¹ÓÐʲô²Ù×÷Òªcommit

insert/update/delete/select ,,,,for update,»ù±¾ÉÏÐм¶DMLÓ ......

²é¿´oracleÈÕÖ¾

¸÷λ£º
    ÎÒ¿ÉÒÔÓÃtoad¹¤¾ßÔÚÊý¾Ý¿â´ò¿ªµÄÇé¿öÏ¿´µ½ÈÕÖ¾µÄÄÚÈÝ£¬µ«ÊÇÎÒÏÖÔÚµÄÊý¾Ý¿âÒòΪijÖÖÔ­Òò²»ÄÜ´ò¿ªÁË£¬ÎÒÒª½øÐÐÊý¾Ý¿â»ùÓÚʱ¼äµÄ²»ÍêÈ«»Ö¸´£¬Õâ¸öʱºòÎÒÏë¿´¿´ÈÕÖ¾¼Ç¼µÄÿ¸ö¶¯×÷µÄʱ¼ä£¬Ò²¾ÍÊÇÈÕÖ¾µÄÄÚÈÝ£¬ÓÉÓÚtoadÒ²ÊÇͨ¹ýÊÓͼ¿´ÈÕÖ¾µÄ£¬ËùÒÔÊý¾Ý¿âûÓдò¿ª¾Í¿´²»µ½ÈκÎÊý¾Ý£¬ÓÐûÓÐÄǸö¹¤¾ß¿ÉÒÔÔÚ ......

OracleÈçºÎ´´½¨Êý¾Ý¿â£¿

[size=18px]OracleÈçºÎ´´½¨Êý¾Ý¿â£¿

½ñÌì³õѧOracle 10g£¬ÎÒÏÂÁËÒ»¸öOracle 10g Ex°æ±¾¡£

OracleÖеÄÊý¾Ý¿â¸ÅÄîÊDz»ÊǺÍMySQLÊý¾Ý¿â²»Ò»Ñù°¡¡£

Ôõô´´½¨Å¶£¿ÄÜÏñMySQLÄÇÑùͨ¹ýCreate Database È¥´´½¨Ã´£¿

OracleÖÐÓм¸ÖÖ´´½¨Êý¾Ý¿âµÄ·½·¨Ñ½£¿


ллŶ~~ [/size]


1. ÏȰ²×°Ê ......

¾È¼±!!oracle 10G

½ñÌìÉϿεÄʱºò¿´µ½ÁËÒ»¸öÕâÑùµÄÎÊÌ⣺¡¢
    ÀûÓÃÓαêÏÔʾ¹¤×Ê×î¸ãµÄǰÈýÃû¹ÍÔ±µÄÃû³ÆºÍ¹¤×Ê¡£ÎÒÃÇÕâÒ»½Ú½²µÄÊÇÓαêÕâ¸ö¸ÅÄÔÚÊéÖеÄʵÀýµÄ½â´ð·½·¨ÈçÏ£º
set serveroutput on
declare
v_ename varchar2(10);
v_sal number(5);
cursor emp_cursor is select ename, job from emp order by ......

ÇóÖúÓÚOracle¸ßÊÖ

ÎÒÊÇÒ»¸öOracleÐÂÊÖ ÎÒ°²×°ÍêÈí¼þºó ÊäÈëScott ºÍtiger ºó×ÜÊǵ¯³ö
error£º
ora-12560:tns:ЭÒéÊÊÅäÆ÷´íÎó¡£
¶ÔÁË
ÇëÎÊÔõô²ÅÄܳ¹µ×ɾ³ýORACLE°¡
ÎÒûÓÐÕÒµ½×Ô¶¯É¾³ýµÄÄǸöÈí¼þ
лл´ó¼ÒÁË

windowÏ£¬ÓÃOUIɾ³ý£¬È»ºóɾ³ý×¢²á±í

Äã¿ÉÒÔgһϣ¬ÍøÉÏÓв»ÉÙ½éÉܵÄ

error£º
ora-12560 ......

oracleÊý¾Ý»¹Ô­ÎÊÌ⣬ϣÍû¸ßÊÖ¸øÓë´ð°¸

ÓÐÒ»¸ödmpÎļþ£¬
ÎÒÒ²ÊÇÏÖÔÚsqlplusÖÐÖ´ÐÐÒÔϲ½Öè


// 1.´´½¨±í¿Õ¼ä
create tablespace shanxi
datafile 'D:\shanxi.dbf'
size 20480M
extent management local
segment space management auto
online;

// 2.´´½¨±íÓû§
create user Óû§Ãû identified by ÃÜÂë
def ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [176] [177] [178] [179] 180 [181] [182] [183] [184] [185]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ