Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ticket tracking system
The solution of adding a column es very good, but you can create a table to keep the closed tickets(deleted) and if you want to reopen it, just look it in that table and recreate it. Assuming that the quantity of reopened tickets is small this will work for you
Luck
-----Original Message-----
From: "root_at_fatcity.com" <root_at_fatcity.com> on behalf of "Post, Ethan" <Ethan.Post_at_ps.net> Sent: Tuesday, April 02, 2002 5:08 PM To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Subject: RE: Ticket tracking system
Manager to David...
"David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true?"
ok enough of that let's ponder some possible solutions...
-----Original Message-----
Sent: Tuesday, April 02, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise.
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: david.m.nguyen_at_xo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 03 2002 - 15:48:20 CST
![]() |
![]() |