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 ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
ÏÂÔØµ ......
¾¹ý³¤Ê±¼äѧϰOracle£¬Äã¿ÉÄÜ»áÓöµ½Oracle tnsÅäÖÃÎÊÌ⣬ÕâÀォ½éÉÜOracle tnsÅäÖÃÎÊÌâµÄ½â¾ö·½·¨¡£×î½üæ×Ű²×°OracleÊý¾Ý¿â£¬±¾À´Í¦¼òµ¥µÄ£¬¿ÉÀÏÊdzöÏÖÎÊÌ⣬×îºó×Ô¼ºÔÚÍøÉÏÕûÀíÁËһЩtns´íÎó½â¾ö·½·¨£¬Ï£Íû¶Ô³õѧÕßÓÐÒæ¡£
³£¼ûÎÊÌâ:
1¡¢ORA-12541:tns:ûÓмàÌýÆ÷£º
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í» ......
£¨ºìÉ«²¿·ÖΪÐÞ¸ÄÄÚÈÝ£©
µÚÒ»²½£¬ÔÚ´ÅÅÌϽ¨Ò»¸öÎļþ¼Ð£¬×¢Òâ²»ÒªÓпոñ£¬·ñÔòoracle°²×°Ê±»á³öÏÖ¾¯¸æ¡£
µÚ¶þ²½£¬ÓÃÓÚ½øÈë°²×°½çÃæºó£¬¼ì²â»·¾³ÔÚ°²×°Îļþ¼ÐÀïËÑË÷ "refhost.xml"£¬¹²2¸öÎļþ¡£
ÓüÇʱ¾´ò¿ª£¬¿´µ½
<!--Microsoft Windows vista-->
<OPERATING_SYSTEM>
&l ......
OracleµÄÈÕÆÚº¯Êý
³£ÓÃÈÕÆÚÐͺ¯Êý
1¡£Sysdate µ±Ç°ÈÕÆÚºÍʱ¼ä
SQL> Select sysdate from dual;
SYSDATE
----------
21-6ÔÂ -05
2¡£Last_day ±¾ÔÂ×îºóÒ»Ìì
SQL> Select last_day(sysdate) from dual;
LAST_DAY(S ......
2010-04-21 14:04
oracleÖй¹ÔìÊý×éµÄÀý×Ó£º
declare
type t_varray is varray(4) of number;
arr t_varray;
begin
arr := t_varray(1,2,3,4);
for i in 1..arr.count loop
dbms_output.put_line(arr(i));
end loop;
end;
¹¹Ôì¶þάÊý×éµÄÀý×Ó£º
declare
type t_varray ......