I want to narrow my query to a particular partition on the table. I looked up how to do it and I keep getting an error. Can anyone help?
SQL> select count(1) from hsbcloader.txn (TXN_OCT2000);
select count(1) from hsbcloader.txn (TXN_OCT2000)
*
ERROR at line 1:
ORA-00933: SQL command not properly ended