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

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 tnsÅäÖõÄ6ÖÖ³£¼û´íÎó½â¾öÎÊÌâ

¾­¹ý³¤Ê±¼äѧϰOracle£¬Äã¿ÉÄÜ»áÓöµ½Oracle tnsÅäÖÃÎÊÌ⣬ÕâÀォ½éÉÜOracle tnsÅäÖÃÎÊÌâµÄ½â¾ö·½·¨¡£×î½üæ×Ű²×°OracleÊý¾Ý¿â£¬±¾À´Í¦¼òµ¥µÄ£¬¿ÉÀÏÊdzöÏÖÎÊÌ⣬×îºó×Ô¼ºÔÚÍøÉÏÕûÀíÁËһЩtns´íÎó½â¾ö·½·¨£¬Ï£Íû¶Ô³õѧÕßÓÐÒæ¡£
³£¼ûÎÊÌâ:
1¡¢ORA-12541:tns:ûÓмàÌýÆ÷£º
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í» ......

oracle·þÎñÓ²¼þÉý¼¶ µ÷Õû²ÎÊý

author£ºskate
time£º2010-05-13
1)If memory increases and you're 64-bit,  e.g  8G to 16G,  Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration,  some  parameters, based on CPU_co ......

oracle Êý¾ÝÀàÐÍÏê½â ÈÕÆÚÐÍ

oracle Êý¾ÝÀàÐÍÏê½â---ÈÕÆÚÐÍ
      oracleÊý¾ÝÀàÐÍ¿´ÆðÀ´·Ç³£¼òµ¥£¬µ«ÓÃÆðÀ´»á·¢ÏÖÓÐÐí¶à֪ʶµã£¬±¾ÎÄÊÇÎÒ¶ÔORACLEÈÕÆÚÊý¾ÝÀàÐ͵ÄһЩÕûÀí£¬¶¼ÊÇ¿ª·¢ÈëÃÅ×ÊÁÏ£¬Óë´ó¼Ò·ÖÏí£º
×¢£ºÓÉÓÚINTERVAL¼°TIME ZONEʵ¼ÊÓõñȽÏÉÙ£¬ËùÒÔ±¾ÎÄÄÚÈÝÎ´Éæ¼°ÕâÁ½¸ö·½Ãæ¡£
1¡¢³£ÓÃÈÕÆÚÐÍÊý¾ÝÀàÐÍ
1.1¡¢DATE
......

Oracle ¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y
CITY VARCHAR2(20) Y
SQL> select * from test;
COUNTRY CITY
-------------------- --------------------
Öйú ̨±±
Öйú Ïã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ