SQL>select * from topsi_bbc partition (part_201210) where rownum <= 10;
CGENERALBBCID CGENERALBID VBARCODE
-------------------- -------------------- --------------------------------------------------------------------------
DBIZDATE DEPARTMENTID CHANNEL STORETYPE TACCOUNTTIME
---------- ---------------- ---------- ---------------------------------------- ------------------------------------
ZINERFVVSIDSYARJEYVI 1001V610000000C1MWWH 354579052279739
,,,
WNBLQCQJJCTYFVDEUFDJ 1001V610000000C1MWWH 354579052316523
10 rows selected.
Elapsed: 00:00:00.26
SQL>select * from topsi_bbc partition for (to_date('2012-10-03','yyyy-mm-dd')) where rownum <= 10;
select * from topsi_bbc partition for (to_date('2012-10-03','yyyy-mm-dd')) where rownum <= 10
*
ERROR at line 1:
ORA-00905: missing keyword
Elapsed: 00:00:00.01
SQL>select sysdate from dual;
SYSDATE
-------------------
2012-11-04 20:33:17
Elapsed: 00:00:00.01
SQL>select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
5 rows selected.
Elapsed: 00:00:00.01