Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL ServerÀィORACLEÁ´½Ó·þÎñÆ÷µÄͼ½â

 Ê×ÏȼÆËã»úÉϱØÐë°²×°oracle£¬²¢ÅäÖú÷þÎñÃû
  °²×°oracleµÄ¹ý³ÌÖÐÒ»°ã»áÒªÇó½¨Á¢Ò»¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔÖ®ºóÔÙ´´½¨
Õâ¸öºóÃæÓÐÒ»¸ö Êý¾Ý¿âÅäÖÃÖúÀí £¨´´½¨ÐÞ¸ÄÊý¾Ý¿âµÄ£¬Ò»°ãÃÜÂë´´½¨ÒªÇó×Öĸ¿ªÍ·£¬´óÓÚ7λɶµÄ£©ºÍÒ»¸önetÅäÖÃÖúÀí£¨Ìí¼Ó»òÕßÐÞ¸ÄÒ»¸öÊý¾Ý¿â·þÎñÃû£©£¬Ò»°ãÓÃplsql developerÔ¶³Ì²Ù×÷oracleÊý¾Ý¿â£¬µÇ½½çÃæÈçÏÂͼ£º
Êý¾Ý¿âµÄÏÂÀ­¿ò£¬¾ÍÊÇnet·þÎñÃû£¬oracleµÄ³£¹æÕ˺ţ¬ÓÐĬÈϵÄÃÜÂ룬µ±È»£¬×Ô¼º¿ÉÒÔ¸ü¸ÄÃÜÂ룬ÔÚÉÏÃæÊý¾Ý¿âÅäÖÃÖúÀíÀï¿ÉÒÔ¸ÄÃÜÂ룬Ëø¶¨ÆäËûµÄһЩĬÈÏÕ˺ŵȣ¬ÓÐʱ£¬Õâ¸ö½çÃæµÇ½Ìáʾ ¼àÌýɶµÄûÆô¶¯£¬ÕâʱÐèÒªÔËÐÐservices.msc£¬À´Æô¶¯oracleµÄ¼àÌý·þÎñ¡£
ÏÖÔÚÕýÊÇ˵ÔõôÔÚÁ´½Ó·þÎñÆ÷ÉÏ×öoracleµÄÁ´½Ó·þÎñÆ÷£¬¼ÆËã»úÉÏÐèҪװÉÏmssqlºÍoracle£¬²¢ÅäÖúÃoracleµÄ·þÎñÃû£¬È»ºó£º
Á¬½Ó·þÎñÆ÷ÊÇ×Ô¼ºËæ±ã¶¨µÄ£¬Ìṩ³ÌÐòÃû³Æ±ØÐëÑ¡¶Ô£¬Êý¾ÝÔ´¾ÍÊǸոÕÅäÖúõÄoracle·þÎñÃû£¨oracleµÄ·þÎñÃûÒ»°ãÊÇÊý¾Ý¿â£¬ÓÐʱ¿ÉÒÔÖØÃüÃû·þÎñÃû£¬µ«¶ÔÓ¦µÄÊý¾Ý¿â²»±ä£¬ËùÒÔºóÃæµÄÕ˺ÅÃÜÂëÒªÌîд¶Ô£©
 
È»ºóÔÚ°²È«ÐÔÀÌîдoracleÖÐÄǸöÊý¾Ý¿â¶ÔÓ¦µÄµÇ½Õ˺ţ¬ÃÜÂëµÈ£º


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Ҳ̸SQL¸÷ÖÖÁ¬½Ó£¨JOIN£©

×î½ü¹«Ë¾ÔÚÕÐÈË£¬Í¬ÊÂÎÊÁ˼¸¸ö×ÔÈÏΪÊý¾Ý¿â¿ÉÒÔµÄӦƸÕß¹ØÓÚ¿âÁ¬½ÓµÄÎÊÌ⣬»Ø´ð²»¾¡ÀíÏë¡«
ÏÖÔÚÔÚÕâдд¹ØÓÚËüÃǵÄ×÷ÓÃ
¼ÙÉèÓÐÈçÏÂ±í£º
Ò»¸öΪͶƱÖ÷±í£¬Ò»¸öΪͶƱÕßÐÅÏ¢±í¡«¼Ç¼ͶƱÈËIP¼°¶ÔӦͶƱÀàÐÍ£¬×óÓÒÁ¬½Óʵ¼Ê˵ÊÇÎÒÃÇÁªºÏ²éѯµÄ½á¹ûÒÔÄĸö±íΪ׼¡«
1£ºÈçÓÒ½ÓÁ¬ right join »ò right outer join£º
ÎÒÃÇÒÔÓÒ±ß ......

OracleÓαêʹÓù¥ÂÔ

Sql´úÂë
1.
´ÓÓαêÌáÈ¡Êý¾Ý
2. ´ÓÓαêʧȥһÆðÊý¾ÝÔËÓÃFETCHÏÂÁÿһ´ÎÌáÈ¡Êý¾Ýºó£¬Óα궼ָÏò½á¹û¼¯µÄÏÂÒ»Æð¡£Óï·¨Èç´Î£º
3. FETCH cursor_name INTO variable[,variable,...]
4. ÖÁÓÚSELECT¶¨ÒåµÄÓαêµÄÿһÁУ¬FETCH±äÁ¿ÁÐ±í¶¼Ó¦¸ÃÓÐÒ»¸ö±äÁ¿ÓëÖ®Ïà¶ÔÓ¦£¬±äÁ¿µÄ²¿ÀàÒ²ÒªÀ×ͬ¡£
Àý£º
5. SET SERVERIUTPUT ......

¾­µäsqlÓï¾ä£¬ÊµÏÖÁËÐ޸ģ¬Ôö¼Ó£¬É¾³ý£¬Åжϱí×Ö¶Î

create database test1
use test1
create table admin
(
   id int primary key ,
   name varchar(50),
   pwd  varchar(50),
)
insert into admin values(1,'aa','aa')
alter  table   admin   add   tel  varchar(50)   ......

SQLÖÐdbo.

Êý¾Ý¿âËùÓÐÕß  (DataBase Owner)
dbo   ÊǾßÓÐÔÚÊý¾Ý¿âÖÐÖ´ÐÐËùÓлµÄ°µÊ¾ÐÔȨÏÞµÄÓû§¡£½«¹Ì¶¨·þÎñÆ÷½ÇÉ«   sysadmin   µÄÈκγÉÔ±¶¼Ó³É䵽ÿ¸öÊý¾Ý¿âÄÚ³ÆΪ   dbo   µÄÒ»¸öÌØÊâÓû§ÉÏ¡£ÁíÍ⣬Óɹ̶¨·þÎñÆ÷½ÇÉ«   sysadmin   µÄÈκγÉÔ±´´½¨µÄÈκζÔÏó¶¼×Ô¶¯ÊôÓÚ   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ