-
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
-
Assuming TXN_OCT2000 is your partition:
select count(1) from hsbcloader.txn partition (TXN_OCT2000);
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|