SQL ServerÀィORACLEÁ´½Ó·þÎñÆ÷µÄͼ½â
Ê×ÏȼÆËã»úÉϱØÐë°²×°oracle£¬²¢ÅäÖú÷þÎñÃû
°²×°oracleµÄ¹ý³ÌÖÐÒ»°ã»áÒªÇó½¨Á¢Ò»¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔÖ®ºóÔÙ´´½¨
Õâ¸öºóÃæÓÐÒ»¸ö Êý¾Ý¿âÅäÖÃÖúÀí £¨´´½¨ÐÞ¸ÄÊý¾Ý¿âµÄ£¬Ò»°ãÃÜÂë´´½¨ÒªÇó×Öĸ¿ªÍ·£¬´óÓÚ7λɶµÄ£©ºÍÒ»¸önetÅäÖÃÖúÀí£¨Ìí¼Ó»òÕßÐÞ¸ÄÒ»¸öÊý¾Ý¿â·þÎñÃû£©£¬Ò»°ãÓÃplsql developerÔ¶³Ì²Ù×÷oracleÊý¾Ý¿â£¬µÇ½½çÃæÈçÏÂͼ£º
Êý¾Ý¿âµÄÏÂÀ¿ò£¬¾ÍÊÇnet·þÎñÃû£¬oracleµÄ³£¹æÕ˺ţ¬ÓÐĬÈϵÄÃÜÂ룬µ±È»£¬×Ô¼º¿ÉÒÔ¸ü¸ÄÃÜÂ룬ÔÚÉÏÃæÊý¾Ý¿âÅäÖÃÖúÀíÀï¿ÉÒÔ¸ÄÃÜÂ룬Ëø¶¨ÆäËûµÄһЩĬÈÏÕ˺ŵȣ¬ÓÐʱ£¬Õâ¸ö½çÃæµÇ½Ìáʾ ¼àÌýɶµÄûÆô¶¯£¬ÕâʱÐèÒªÔËÐÐservices.msc£¬À´Æô¶¯oracleµÄ¼àÌý·þÎñ¡£
ÏÖÔÚÕýÊÇ˵ÔõôÔÚÁ´½Ó·þÎñÆ÷ÉÏ×öoracleµÄÁ´½Ó·þÎñÆ÷£¬¼ÆËã»úÉÏÐèҪװÉÏmssqlºÍoracle£¬²¢ÅäÖúÃoracleµÄ·þÎñÃû£¬È»ºó£º
Á¬½Ó·þÎñÆ÷ÊÇ×Ô¼ºËæ±ã¶¨µÄ£¬Ìṩ³ÌÐòÃû³Æ±ØÐëÑ¡¶Ô£¬Êý¾ÝÔ´¾ÍÊǸոÕÅäÖúõÄoracle·þÎñÃû£¨oracleµÄ·þÎñÃûÒ»°ãÊÇÊý¾Ý¿â£¬ÓÐʱ¿ÉÒÔÖØÃüÃû·þÎñÃû£¬µ«¶ÔÓ¦µÄÊý¾Ý¿â²»±ä£¬ËùÒÔºóÃæµÄÕ˺ÅÃÜÂëÒªÌîд¶Ô£©
È»ºóÔÚ°²È«ÐÔÀÌîдoracleÖÐÄǸöÊý¾Ý¿â¶ÔÓ¦µÄµÇ½Õ˺ţ¬ÃÜÂëµÈ£º
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
×î½ü¹«Ë¾ÔÚÕÐÈË£¬Í¬ÊÂÎÊÁ˼¸¸ö×ÔÈÏΪÊý¾Ý¿â¿ÉÒÔµÄӦƸÕß¹ØÓÚ¿âÁ¬½ÓµÄÎÊÌ⣬»Ø´ð²»¾¡ÀíÏë¡«
ÏÖÔÚÔÚÕâдд¹ØÓÚËüÃǵÄ×÷ÓÃ
¼ÙÉèÓÐÈçÏÂ±í£º
Ò»¸öΪͶƱÖ÷±í£¬Ò»¸öΪͶƱÕßÐÅÏ¢±í¡«¼Ç¼ͶƱÈËIP¼°¶ÔӦͶƱÀàÐÍ£¬×óÓÒÁ¬½Óʵ¼Ê˵ÊÇÎÒÃÇÁªºÏ²éѯµÄ½á¹ûÒÔÄĸö±íΪ׼¡«
1£ºÈçÓÒ½ÓÁ¬ right join »ò right outer join£º
ÎÒÃÇÒÔÓÒ±ß ......
Sql´úÂë
1.
´ÓÓαêÌáÈ¡Êý¾Ý
2. ´ÓÓαêʧȥһÆðÊý¾ÝÔËÓÃFETCHÏÂÁÿһ´ÎÌáÈ¡Êý¾Ýºó£¬Óα궼ָÏò½á¹û¼¯µÄÏÂÒ»Æð¡£Óï·¨Èç´Î£º
3. FETCH cursor_name INTO variable[,variable,...]
4. ÖÁÓÚSELECT¶¨ÒåµÄÓαêµÄÿһÁУ¬FETCH±äÁ¿ÁÐ±í¶¼Ó¦¸ÃÓÐÒ»¸ö±äÁ¿ÓëÖ®Ïà¶ÔÓ¦£¬±äÁ¿µÄ²¿ÀàÒ²ÒªÀ×ͬ¡£
Àý£º
5. SET SERVERIUTPUT ......
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) ......
Êý¾Ý¿âËùÓÐÕß (DataBase Owner)
dbo ÊǾßÓÐÔÚÊý¾Ý¿âÖÐÖ´ÐÐËùÓлµÄ°µÊ¾ÐÔȨÏÞµÄÓû§¡£½«¹Ì¶¨·þÎñÆ÷½ÇÉ« sysadmin µÄÈκγÉÔ±¶¼Ó³É䵽ÿ¸öÊý¾Ý¿âÄÚ³ÆΪ dbo µÄÒ»¸öÌØÊâÓû§ÉÏ¡£ÁíÍ⣬Óɹ̶¨·þÎñÆ÷½ÇÉ« sysadmin µÄÈκγÉÔ±´´½¨µÄÈκζÔÏó¶¼×Ô¶¯ÊôÓÚ ......