Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Æô¶¯ÎÊÌâÒ»°ã½â¾ö·½·¨

oracleÆô¶¯ÎÊÌâ
Ò»£ºÊý¾Ý¿âûÓÐÆô¶¯
#sqlplus /nolog
sql>connect /as sysdba
sql>startup
 
¶þ£º¼àÌý³öÎÊÌâ
µÇ¼DB·þÎñÆ÷
ʹÓÃlsnrctl start/stop¿ªÆô/¹Ø±Õ¼àÌý
ʹÓÃlsnrctl status²é¿´×´Ì¬
ÀíӦΪ£º
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPAP)(PORT=1521)))
STATUS of the ......

OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿

OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿
ÃÜÂëÎļþÈÏÖ¤          ²Ù×÷ϵͳÈÏÖ¤                  remote_login_passwordfile   SQLNET.AUTHENTICATION_SERVICES   &nb ......

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ʵÀýÓÐϵͳȫ¾ÖÇø£¨SGA£©ºÍһЩºǫ́½ø³Ì×é³É.
ϵͳȫ¾ÖÇø£¨SGA£©Óй²Ïí³Ø£¨shared pool£©,Êý¾Ý¿â¸ßËÙ»º³åÇø£¨database buffer cache£©,ÖØ×öÈÕÖ¾»º³åÇø£¨redo log buffer£©.¹²Ïí³ØÓÖÓпâ¸ßËÙ»º´æ£¨library cache£©ºÍÊý¾Ý×Öµä¸ßËÙ»º´æ£¨dictionary cache£©×é³É¡£
ORACLE ʵÀý5¸ö±ØÐèµÄºǫ́½ø³Ì£ºSMON,PMON,DBWR,LGWR, ......

Oracle Sql ÓÅ»¯


»ù±¾µÄSql±àдעÒâÊÂÏî
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½
µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊÉ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ