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

OracleÌṩµÄÐòºÅº¯Êý

OracleÌṩµÄÐòºÅº¯Êý:
ÒÔemp±íΪÀý:
1: rownum ×î¼òµ¥µÄÐòºÅ µ«ÊÇÔÚorder by֮ǰ¾ÍÈ·¶¨Öµ.
select rownum,t.* from emp t order by ename
  ÐÐÊý
ROWNUM
EMPNO
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTNO
1
11
7876
ADAMS
CLERK
7788
1987-5-23
1100
¡¡
20
2
2
7499
ALLEN
SALESMAN
7698
1981-2-20
1600
300
30
3
6
7698
BLAKE
MANAGER
7839
1981-5-1
2850
¡¡
30
4
7
7782
CLARK
MANAGER
7839
1981-6-9
2450
¡¡
10
5
13
7902
FORD
ANALYST
7566
1981-12-3
3000
¡¡
20
6
12
7900
JAMES
CLERK
7698
1981-12-3
950
¡¡
30
7
4
7566
JONES
MANAGER
7839
1981-4-2
2975
¡¡
20
8
9
7839
KING
PRESIDENT
¡¡
1981-11-17
5000
¡¡
10
9
5
7654
MARTIN
SALESMAN
7698
1981-9-28
1250
1400
30
10
14
7934
MILLER
CLERK
7782
1982-1-23
1300
¡¡
10
11
8
7788
SCOTT
ANALYST
7566
1987-4-19
3000
¡¡
20
12
1
7369
SMITH
CLERK
7902
1980-12-17
800
¡¡
20
13
10
7844
TURNER
SALESMAN
7698
1981-9-8
1500
0
30
14
3
7521
WARD
SALESMAN
7698
1981-2-22
1250
500
30
2: row_number() over( order by ×Ö¶ÎÃû1,×Ö¶ÎÃû2,...×Ö¶ÎÃûn ) ÏÈÅÅÐòÔÙÈ·¶¨ÐòºÅ.
select row_number() over( order by ename ) as rm, t.* from emp t
   ÐÐÊý
RM
EMPNO
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTNO
1
1
7876
ADAMS
CLERK
7788
1987-5-23
1100
¡¡
20
2
2
7499
ALLEN
SALESMAN
7698
1981-2-20
1600
300
30
3
3
7698
BLAKE
MANAGER
7839
1981-5-1
2850
¡¡
30
4
4
7782
CLARK
MANAGER
7839
1981-6-9
2450
¡¡
10
5
5
7902
FORD
ANALYST
7566
1981-12-3
3000
¡¡
20
6
6
7900
JAMES
CLERK
7698
1981-12-3
950
¡¡
30
7
7
7566
JONES
MANAGER
7839
1981-4-2
2975
¡¡
20
8
8
7839
KING
PRESIDENT
¡¡
1981-11-17
5000
¡¡
10
9
9
7654
MARTIN
SALESMAN
7698
1981-9-28
1250
1400
30
10
10
7934
MILLER
CLERK
7782
1982-1-23
1300
¡¡
10
11
11
7788
SCOTT
ANALYST
7566
1987-4-19
3000
¡¡
20
12
12
7369
SMITH
CLERK
7902
1980-12-17
800
¡¡
20
13
13
7844
TURNER
SALES


Ïà¹ØÎĵµ£º

linuxÉèÖà ÈÃoracle10g×ÔÆô¶¯


ÔÚ/etc/rc.d/init.d/ ´´½¨oracle10gÎļþ
touch oracle10g
chmod a+x oracle10g
[root@test~]# vi /etc/rc.d/init.d/oracle10g
#!/bin/bash
#chkconfig:345 51 49
#description:starts the oracle database deamons
#
ORACLE_HOME=/oracle/product/10.2.0/db_1
ORACLE_OWNER=oracle
case "$1" in
start)
echo ......

ORACLE SQLÓÅ»¯ ORACLEÖ´Ðмƻ®

Last login: Mon Feb  8 14:13:19 2010 from 192.168.1.249
ipnet
-bash-3.00$
-bash-3.00$ ipnet
-bash: ipnet: command not found
-bash-3.00$ su - oracle
Password:
eastcsu: incorrect password
-bash-3.00$ eastcom
-bash: eastcom: command not found
-bash-3.00$ su - oracle
Password:
[oracl ......

Oracle 10g SQL ÓÅ»¯ÔÙѧϰ

´Ó8iµ½10g£¬Oracle²»¶Ï½ø»¯×Ô¼ºµÄSQL TuningÖÇÄÜ£¬Ò»Ð©Ãؼ®¼¶µÄÓÅ»¯¿Ú¾÷ÒѾ­Ê§Ð§¡£
   µ«ÎÒϲ»¶Ê§Ð§£¬²»Óüǿھ÷£¬²Ù¸öToad for Oracle Xpert
 £¬°´ÕÕ´ó·½ÏòÊæÊæ·þ·þµÄ
µ÷ÓŲÅÊǰ®×öµÄÊÂÇé¡£
1.Excution Plan
     Excution
PlanÊÇ×î»ù±¾µÄµ÷ÓŸÅÄ²»¹ÜÄãµÄµ÷ÓÅ´µµÃÈçºÎÌ ......

oracle ´¥·¢Æ÷

Create [or replace] trigger [ģʽ.]´¥·¢Æ÷Ãû
       Before| after |instead of  insert|delete|(update of ÁÐÃû)
       {insert|delete|(update of ÁÐÃû) }
On ±íÃû|ÊÓͼ|ģʽÃû|Êý¾Ý¿âÃû
[for each row]
When Ìõ¼þ
PL/SQL¿é
˵Ã÷£º
......

OracleÌåϵ½á¹¹Ö®£­Êý¾Ý¿â¡¢±í¿Õ¼ä¡¢ÊµÀý¼ò½é

Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£    
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼­Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼­Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼­ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ