Oracle·ÖÒ³ÌÖÂÛ
oracle·ÖÒ³£¿£¿£¿
ÔÚmysqlÖÐÖ»Òªlimit x,y¾Í¿ÉÒÔ·ÖÒ³³É¹¦£¬ÄÇoracle ÖÐÊÇÔõô×öµÄÄØ£¿
=================================================
·½·¨Ò»£º
SELECT id,rown
from (SELECT id, ROWNUM rown
from (SELECT id
from table
WHERE (************)
ORDER BY ********)
WHERE ROWNUM <= ÿҳÌõÊý*Ò³ºÅ)
WHERE (rown BETWEEN ÿҳÌõÊý*Ò³ºÅ-£¨Ã¿Ò³ÌõÊý-1£© AND ÿҳÌõÊý*Ò³ºÅ)
¸ã²»¶¨ºÍÎÒÁªÏµ lhw@263.net
ÕâÑùÈ¡³öµÚ11-20Ìõ¼Ç¼!
select * from (
select rownum r,a from yourtable
where rownum <= 20
order by name )
where r > 10
=========================================================
[code=SQL]
select * from
(select rownum r , e.*
--¸ù¾ÝÌõ¼þ²éÕÒ³öËùÒªµÄ¼Ç¼
from
(select * from emp where Ìõ¼þ order by ×Ö¶Î ) e
)
where r between ÆðʼÐÐ and ½áÊøÐÐ
[/code]
======================================================
·½·¨Èý£º
a_ja£¨Çà²ØêóÅ££©»Ø¸´ÓÚ 2003-06-14 12:16:29 µÃ·Ö 0
select * from you_db_table where rownum
Ïà¹ØÎĵµ£º
Oracle Purchasing²»Äܲ鿴PO»ò開PO,並ÇÒÓÃ戶ÓÐ權ÏÞ開PO¡£這樣Çé況¿ÉÄÜÓв»ÉÙͬÈÊÒ²ÓöÉÏ類ËÆ問題¡£¾ß體Çé況ÈçÏÂ圖:
Ê×ÏÈ,²é¿´Óà ......
Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º[1]
¡¡¡¡1.select name,log_mode from v$database;
¡¡¡¡NAME LOG_MODE
¡¡¡¡------------------ ------------------------
¡¡¡¡QUERY NOARCHIVELOG
¡¡¡¡2.ʹ ......
ÓÃoracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÏÖ·µ»Ø½á¹û¼¯²¢ÊµÏÖ·ÖÒ³µÄ¹¦ÄÜ¡£
Óû§´«Èë²ÎÊý
Ò»ÏÂÊÇת±ðÈ˵ĴúÂë
--°üÉùÃ÷
create or replace package p_page is
-- Author : PHARAOHS
-- Created : 2006-4-30 14:14:14
-- Purpose : ·ÖÒ³¹ý³Ì
TYPE type_cur IS REF CURSOR; &n ......
¡¡ ¹ØÓÚOracleµÄÐÔÄܵ÷Õû£¬Ò»°ã°üÀ¨Á½¸ö·½Ã棬һÊÇÖ¸OracleÊý¾Ý¿â±¾ÉíµÄµ÷Õû£¬±ÈÈçSGA¡¢PGAµÄÓÅ»¯ÉèÖ㬶þÊÇÁ¬½ÓOracleµÄÓ¦ÓóÌÐòÒÔ¼°SQLÓï¾äµÄÓÅ»¯¡£×öºÃÕâÁ½¸ö·½ÃæµÄÓÅ»¯£¬¾Í¿ÉÒÔʹһÌ×ÍêÕûµÄOracleÓ¦ÓÃϵͳ´¦ÓÚÁ¼ºÃµÄÔËÐÐ״̬¡£
¡¡¡¡ ±¾ÎÄÖ÷ÒªÊǰÑһЩOracle TuningµÄÎÄÕÂ×÷ÁËÒ»¸ö¼òµ¥µÄ×ܽᣬ ......
1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......