Home » SQL & PL/SQL » SQL & PL/SQL » Archiving of Quote Data
Archiving of Quote Data [message #415803] Wed, 29 July 2009 06:28 Go to next message
dilipn_nitw@yahoo.com
Messages: 16
Registered: July 2009
Location: India
Junior Member

Hi Friends,

I have the following requirement -

Please proceed to systematically clean up PWR Quotations with the following conditions for all ORGS:

1. Quotes with a "QUOTE START DATE " of 2007 and under WITH NO link to ASL, BOD, Not Approved, no Quote End Date; archive this history so that it is not visable to the current PWR quote screen.

2. Quotes with a "QUOTE END DATE" that is over 1 year old;
archive this history so that it is not visable to the current PWR quote screen.


I had not worked on this kind of requirement before.

Thanks In Advance!

Thanks & Regards
Ramya Nomula
Re: Archiving of Quote Data [message #415808 is a reply to message #415803] Wed, 29 July 2009 06:35 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You could possibly do it with select, insert and delete statements once you have figured out how it is actually set up inside the database. (What table with what columns there are)

Re: Archiving of Quote Data [message #415812 is a reply to message #415803] Wed, 29 July 2009 06:54 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
dilipn_nitw@yahoo.com wrote on Wed, 29 July 2009 13:28
Hi Friends,

I have the following requirement -

[snip]

I had not worked on this kind of requirement before.


Did the thought ever occur to you to ask the person who handed you this requirement? You'd rather ask total strangers then show the person who assigns you work that you might need some extra clarification or that you're not up to your work.
Guess what happens if you clear this one, only with our help.
Re: Archiving of Quote Data [message #416052 is a reply to message #415812] Thu, 30 July 2009 05:07 Go to previous messageGo to next message
dilipn_nitw@yahoo.com
Messages: 16
Registered: July 2009
Location: India
Junior Member

Thanks Frank!


Thanks & Regards
Ramya Nomula
Re: Archiving of Quote Data [message #416167 is a reply to message #415803] Thu, 30 July 2009 23:50 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
When getting clarification from your requestor, maybe you can ask them if archival is really necessary or if their goal is really just to eliminate the rows from showing on the screen. If the real goals is simply to not show the rows to the outside world then you should at least consider the possibility of using a view layer to hide the rows.

A simple where clause in the view would cuase the rows not to show, and would not require you to actually fiddle with the data in any way. Additionally, it can easily be altered to bring back the data or include additional row exclusion criteria should your requestor find they made a mistake, or find that they like removing the data and want to remove more.

The downside is of course that you need to rename your original table and substitute a view in its place. But then again, if your application was built with any smarts, you are likely already working with a view anyway.

Its just a thought.

Good luck, Kevin
Re: Archiving of Quote Data [message #416197 is a reply to message #416167] Fri, 31 July 2009 02:30 Go to previous message
dilipn_nitw@yahoo.com
Messages: 16
Registered: July 2009
Location: India
Junior Member

Thanks a lot Kevin!

Good point,i will check the same with the user.

Thanks & Regards
Ramya Nomula
Previous Topic: update required
Next Topic: Compile UTL_FILE PACKAGE BODY
Goto Forum:
  


Current Time: Thu Feb 06 19:00:37 CST 2025