SQLServer ºÍOracle³£Óú¯Êý¶Ô±È
1
.¾ø¶ÔÖµ
S:
select
abs
(
-
1
) value
O:
select
abs
(
-
1
) value
from
dual
¡¡¡¡
2
.È¡Õû(´ó)
S:
select
ceiling
(
-
1.001
) value
O:
select
ceil(
-
1.001
) value
from
dual
¡¡¡¡
3
.È¡Õû£¨Ð¡£©
S:
select
floor
(
-
1.001
) value
O:
select
floor
(
-
1.001
) value
from
dual
¡¡¡¡
4
.È¡Õû£¨½ØÈ¡£©
S:
select
cast
(
-
1.002
as
int
) value
O:
select
trunc(
-
1.002
) value
from
dual
¡¡¡¡
5
.ËÄÉáÎåÈë
S:
select
round
(
1.23456
,
4
) value
1.23460
O:
select
round
(
1.23456
,
4
) value
from
dual
1.2346
¡¡¡¡
6
.eΪµ×µÄÃÝ
S:
select
Exp
(
1
) value
2.7182818284590451
O:
select
Exp
(
1
) value
from
dual
2.71828182
¡¡¡¡
7
.È¡eΪµ×µÄ¶ÔÊý
S:
select
log
(
2.7182818284590451
) value
1
O:
select
ln(
2.7182818284590451
) value
from
dual;
1
¡¡
¡¡
8
.È¡10Ϊµ×¶ÔÊý
S:
select
log10
(
10
) value
1
O:
select
log
(
10
,
10
) value
from
dual;
1
¡¡¡¡
9
.ȡƽ·½
S:
select
SQUARE
(
4
) value
16
O:
select
power
(
4
,
2
) value
from
dual
16
¡¡¡¡
10
.ȡƽ·½¸ù
S:
select
SQRT
(
4
) value
2
O:
select
SQRT
(
4
) value
from
dual
2
¡¡¡¡
11
.ÇóÈÎÒâÊýΪµ×µÄÃÝ
S:
select
power
(
3
,
4
) value
81
O:
select
power
(
3
,
4
) value
from
dual
81
¡¡¡¡
12
.È¡Ëæ»úÊý
S:
select
rand
() value
O:
select
sys.dbms_random.value(
Ïà¹ØÎĵµ£º
¾¹ý³¤Ê±¼äѧϰOracle£¬Äã¿ÉÄÜ»áÓöµ½Oracle tnsÅäÖÃÎÊÌ⣬ÕâÀォ½éÉÜOracle tnsÅäÖÃÎÊÌâµÄ½â¾ö·½·¨¡£×î½üæ×Ű²×°OracleÊý¾Ý¿â£¬±¾À´Í¦¼òµ¥µÄ£¬¿ÉÀÏÊdzöÏÖÎÊÌ⣬×îºó×Ô¼ºÔÚÍøÉÏÕûÀíÁËһЩtns´íÎó½â¾ö·½·¨£¬Ï£Íû¶Ô³õѧÕßÓÐÒæ¡£
³£¼ûÎÊÌâ:
1¡¢ORA-12541:tns:ûÓмàÌýÆ÷£º
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í» ......
ÎÒÃÇ¿ÉÒÔͨ¹ýSTART WITH . . . CONNECT BY . . .×Ó¾äÀ´ÊµÏÖSQLµÄ ²ã´Î²éѯ£¬¶øOracle 10g ΪÆäÌí¼ÓÐí¶àÁËеÄαÁС£Ê®¶àÄêÒÔÀ´£¬Oracle SQL ¾ßÓÐÒÀÕÕ²ã´Î¹ØÏµ½øÐвéѯµÄ¹¦ÄÜ¡£ÀýÈ磬Äã¿ÉÒÔÖ¸¶¨Ò»¸öÆðʼÌõ¼þ£¬È»ºó¸ù¾ÝÒ»¸ö»ò¶à¸öÁ¬½ÓÌõ¼þÀ´È·¶¨º¢×ÓÐеÄÄÚÈÝ¡£¾ÙÀýÀ´Ëµ£¬ÏÖÔÚ¼ÙÉèÎÒÓÐÒ»¸ö±í£¬ÀïÃæ¼Ç ......
truncate,delete,dropµÄÒìͬµã
×¢Òâ:ÕâÀï˵µÄdeleteÊÇÖ¸²»´øwhere×Ó¾äµÄdeleteÓï¾ä
Ïàͬµã:truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã:
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigger),Ë÷Òý(index); ÒÀÀµÓÚ¸Ã±íµ ......
»ù±¾µÄSql±àдעÒâÊÂÏî
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½
µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊÉ ......
ÉÌÒµºÍÊý¾Ý¿âºÜ¶àʱºò±ØÐë¿çÊ±Çø¹¤×÷£¬´Ó9i¿ªÊ¼£¬oracle»·¾³¿ªÊ¼ÓÐÁËÊ±ÇøÒâʶ£¬Í¨¹ýÖ¸¶¨Êý¾Ý¿âµÄÊ±ÇøºÍʹÓÃTIMESTAMP WITH TIME ZONEºÍTIMESTAMP WITH LOCAL TIME ZONEÊý¾ÝÀàÐÍÀ´ÊµÏָù¦ÄÜ¡£
TIMESTAMP WITH TIME ZONE²»»á´æ´¢Êý¾Ý¿âÊ±Çø£¬µ«ÊÇÓÐÒ»¸öָʾÓÃÀ´ËµÃ÷¸Ãʱ¼äËùʹÓõÄÊ±Çø¡£TIMESTAMP WITH LOCAL TIME ZONE»áͬ ......