Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ClientÈçºÎʹÓÃPLSQL Developer

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
      Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
      ÏÂÔØµ ......

Oracle tnsÅäÖõÄ6ÖÖ³£¼û´íÎó½â¾öÎÊÌâ

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

ÔÚWindows 7 ϰ²×° Oracle 10g ¹ý³Ì

£¨ºìÉ«²¿·ÖΪÐÞ¸ÄÄÚÈÝ£©
µÚÒ»²½£¬ÔÚ´ÅÅÌϽ¨Ò»¸öÎļþ¼Ð£¬×¢Òâ²»ÒªÓпոñ£¬·ñÔòoracle°²×°Ê±»á³öÏÖ¾¯¸æ¡£
µÚ¶þ²½£¬ÓÃÓÚ½øÈë°²×°½çÃæºó£¬¼ì²â»·¾³ÔÚ°²×°Îļþ¼ÐÀïËÑË÷ "refhost.xml"£¬¹²2¸öÎļþ¡£
ÓüÇʱ¾´ò¿ª£¬¿´µ½
 <!--Microsoft Windows vista-->
  <OPERATING_SYSTEM>
  &l ......

OracleµÄÈÕÆÚº¯Êý

 
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 ......

OracleÖеÄÊý×é

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ