Re: HOW TO EXECUTE DELETE RECORD [2 Attachments]
Marvin Rios <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
I' m use tool SQL TRACKER and result is -------------------------------------------------------------------------------- Timestamp: 09/03/2012 16:30:23 DELETE FROM SMART3G.HUA_ALGORITHM_HOR WHERE FECHA = '2011-11-07 00:00:00' AND HORA = 0.100000000e+001 fec=['2011-11-07 00:00:00'] hor=[0.100000000e+001] Elapsed time: 0.468 -------------------------------------------------------------------------------- Timestamp: 09/03/2012 16:30:23 DELETE FROM SMART3G.HUA_ALGORITHM_HOR WHERE FECHA = '2011-11-07 00:00:00' AND HORA = 0.100000000e+001 fec=['2011-11-07 00:00:00'] hor=[0.100000000e+001] Elapsed time: 0.468 ++++++++++++++++++++++ Perform several tests and wrote the code as follows and it worked in TOAD DELETE FROM SMART3G.HUA_ALGORITHM_HOR WHERE FECHA =: fec AND HORA =: hor; add two points view attach File. ________________________________ From: "Simoneau, Roger" <[email protected]> To: "'[email protected]'" <[email protected]> Sent: Friday, March 9, 2012 2:33 PM Subject: RE: [toad] HOW TO EXECUTE DELETE RECORD. >> differences in NLS_DATE_FORMAT … >> my bet is you won’t have the problem anymore I’d actually be surprised if that fixed the particular issue identified. The error wasn’t along the lines of “ORA-01843: not a valid month” which is the type of error one would expect during a bad run-time conversion on a date value. It was “ORA-00904: “HOR”: invalid identifier”. In the action of that error there is the phrase “It may not be a reserved word.” Roger S. ________________________________ This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.