sqlÓÅ»¯ - Oracle / ¸ß¼¶¼¼Êõ

ÓÐÕâÑùÒ»¸ö²éѯÓï¾ä
Select to_char(RSN) RSN,
  to_char(SID) SID,
  to_char(OID) OID,
  PDID,
  PRID,
  to_char(GSID) GSID,
  to_char(RGSID) RGSID,
  to_char(PPOID) PPOID,
  VERSION,
  STARTDATE,
  to_char(APOID) APOID,
  APTP,
  ENDDATE,
  to_char(COID) COID,
  OLDENDDATE,
  to_char(IU) IU,
  VERSION,
  to_char(SPID) SPID,
  to_char(RFID) RFID,
  to_char(RLID) RLID,
  PRSNT,
  OBDL
  from T_PO_BB
 Where SID = '123456'
  And RSN = 100
  And (STARTDATE < ENDDATE OR ENDDATE IS NULL)
  AND NVL(ENDDATE, SYSDATE + 1) > SYSDATE
 order by SPID ASC, PRID, STARTDATE;
 
 ÏàÓ¦±íÓÐË÷Òý
 
 create index IDX_SID_B on T_PO_BB (SID)
 create unique index PK_OSN on T_PO_BB (OID, RSN)


ÔÚÖ´ÐеÄʱºòCPUÕ¼Óó¬¹ý16£¥£¬ÐèÒªÓÅ»¯£¬¸÷λ´óÏÀ¿´¿´£¬Óкη½°¸£¿

---

×Ô¼º¶¥Ò»Ï¡£¡£

---

Ò»ÆðµÈ´ý¡£¡£¡£superman

---

ÒýÓÃ

ÓÐÕâÑùÒ»¸ö²éѯÓï¾ä
Select to_char(RSN) RSN,
to_char(SID) SID,
to_char(OID) OID,
PDID,
PRID,
to_char(GSID)