I am a newbie on SQL (and Oracle for that matter)and I need help with the delete and truncate command. On the textbook I am referencing, the sample code for delete and truncate removes all records from a table.
delete tbl or truncate tbl.
Can I truncate or delete the rcords from a specific column?
I have this table structure Unit, Account, Jan-Dec and depending on the current month, I need to "clear" the data for that month. Can I do this with truncate or delete, or is there another command for this? Can I have a where clause on truncate?
Any help will be greatly appreciated.
delete tbl or truncate tbl.
Can I truncate or delete the rcords from a specific column?
I have this table structure Unit, Account, Jan-Dec and depending on the current month, I need to "clear" the data for that month. Can I do this with truncate or delete, or is there another command for this? Can I have a where clause on truncate?
Any help will be greatly appreciated.