ÓÃOracleÈçºÎȥдSQLÓï¾ä - Oracle / ·Ç¼¼ÊõÇø
ÈçºÎÓÃOracle´´½¨Êý¾Ý¿â£¬ÓõÄÊÇSQLÓï¾ä¡£
ÎÒÊǸÕѧµÄ¡£×Ô¼ºÔÚÍøÉÏÕÒÁËÒ»µã£¬¾ÍÊÇ¿´²»¶®°¡¡£
Ï£ÍûÄãÃǽ«ÏêϸµÄ¡£
WINDOWS Ï ¿ØÖÆÌ¨ DBCA
³õѧÕß»¹ÊÇʹÓÃDatabase Configuration Assistant£¨DBCA£©°É
Èç¹ûwindows¿ÉÒÔÔÚ¿ªÊ¼²Ëµ¥ÖÐÕÒµ½´ËÏî
µ±È»Ò²¿ÉÓÃÃüÁîÐÐÊäÈëdbca´ò¿ª´ËͼÐνçÃæ¹¤¾ß(ͨÓÃ)
Ïà¹ØÎÊ´ð£º
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......