Hello all,
In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??
(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands
6  3173  av********@hotm ail.com (Andre) wrote in message news:<4d******* *************** ****@posting.go ogle.com>... Hello all,
In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??
(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands
Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.
Sybrand Bakker
Senior Oracle DBA
<sy******@yahoo .com> schreef in bericht
news:a1******** *************** **@posting.goog le.com... av********@hotm ail.com (Andre) wrote in message
news:<4d******* *************** ****@posting.go ogle.com>... Hello all,
In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??
(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands
Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.
If he wants to know the date/time a record was changed *LAST WEEK* putting a
trigger on that table *NOW* won't give him the answer.
If you are running archive log mode the "log miner" may be able to give you
the answer.
Rob sy******@yahoo. com wrote in message news:<a1******* *************** ***@posting.goo gle.com>... av********@hotm ail.com (Andre) wrote in message news:<4d******* *************** ****@posting.go ogle.com>... Hello all,
In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??
(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands
Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.
Sybrand Bakker
Senior Oracle DBA
Sybrand provided the only practical solution on an ongoing basis;
there is another possibility if your system is in archive log mode and
you still have the archived redo logs. You can use the log minger
facility to look for the change. It will be a time consuming pain,
but if the time when this specific record was changed is a critical
issue then it may be an option.
HTH -- Mark D Powell -- av********@hotm ail.com (Andre) wrote in message news:<4d******* *************** ****@posting.go ogle.com>... Ma*********@eds .com (Mark D Powell) wrote in message news:<26******* *************** ***@posting.goo gle.com>... sy******@yahoo. com wrote in message news:<a1******* *************** ***@posting.goo gle.com>... av********@hotm ail.com (Andre) wrote in message news:<4d******* *************** ****@posting.go ogle.com>...
> Hello all,
>
> In my database I have a table with records. (Yes I have!!)
> Last week a record is changed, but I want to know on which date/time
> that was.
> Is there a oracle field in the table (like rownum) in which I can see
> the time which the recoird has changed??
>
> (please do not answer with the sollution to add an extra "field" in
> the table and let a trigger fill that field with the changingdate. It
> is too late for that :-) )
>
>
> THANKS and regards,
> Andre
> The Netherlands
Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.
Sybrand Bakker
Senior Oracle DBA
Hello Sybrand, I think you did not fully understand my question.
Offcourse I know that tables can be easily altered, but thats not my problem.
I will try the data mining method. Takes a lot of time, but I will try.
Andre
crap methods are crap methods and not changing an application for
political reasons is just stupid.
Sybrand Bakker
Senior Oracle DBA
I have not used it before, but it is my understanding that you can use 'Log
Miner'. Log Miner I believe comes with 8i and up. Also I believe it is
required the database to be in archivelog mode. My advice would be to go to
OTN and find the docs on it.
"Andre" <av********@hot mail.com> wrote in message
news:4d******** *************** ***@posting.goo gle.com... Hello all,
In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??
(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands sy******@yahoo. com wrote in message > crap methods are crap methods and not changing an application for
political reasons is just stupid.
Yeah, you are right, But crap methods build by others??
You have to live with it :-)
Thanks and regards,
Andre This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: David C. Barber |
last post by:
I'm trying to determine which user has locked a given record from VB6.
I know I can use sp_lock and sp_who, and match up the data to determine
which users have locked records in my database, however I haven't seen a way
to match the specific user to the specific record. What am I missing here?
Thanks!
*David*
|
by: Web Webon |
last post by:
Hi everybody!
I wonder if this is possible?
I need to determine if a client is using "windows classic folders" or
anything else. If I instantiate a Shell ActiveX object is there a way
of obtaining this information from javascript? (I know that the user
will get prompted about allowing such an operation, but I am willing
to live with this). Because of the way one of my pages work, I need
to know this information in order to "cover up"...
|
by: StenKoll |
last post by:
Help needed in order to create a register of stocks in a company. In
accordance with local laws I need to give each individual share a
number. I have accomplished this by establishing three tables (se
below) then I run a query giving me a running total, which give me the
first stock in the batch purchased by an individual, then I use this
number and add the number of shares in order to find the number of the
individuals' last share.
So...
|
by: MS |
last post by:
What's the best way to "store" and display a value in a text box that
changes from day to day. An example of this would be where the name of the
user is manually typed in after using the datbase, along with (say) the
date.
ATM, I have a table with (say) 4 fields. Each field is linked to a column in
a combo box. The combo box is invisible on the form. The text boxes display
previous data using code something like this...
Private Sub...
|
by: Jim M |
last post by:
Two questions:
1) I have a scheduling application (Access 2002) that allows multiple
staff members to edit notes on their meetings and appointments from
their offices. A receptionist views a limited dataset of all of their
appointments and changes the status of an appointment to "Show" as
clients come in the door. She keeps a form open all day that lists that
day's appointments for all staff in chronological order.
Once in a while,...
| | |
by: deko |
last post by:
I have a popup form with a textbox that is bound to a memo field. I've been
warned about memo fields so I'm wondering if I should use this code. Is
there any risk with changing the form's RecordSource like this? Am I asking
for trouble doing this with a memo field?
Thanks in advance.
Private Sub cmdNextNote_Click()
Dim lngNid As Long
If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord
|
by: MLH |
last post by:
Suppose, in a multi-user environment, you
have append query SQL in a VBA procedure
that looks like INSERT INTO MyTable...
and the next line reads MyVar=DMax("","MyTable...
You can never be certain that MyVar will be
set to the key-field value that was created
when the Append query ran. Now, there are
other ways to do it - I know - that will ensure
you 'nab' the correct record. But I was wondering
|
by: Andre |
last post by:
Hello all,
In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??
(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
|
by: Giampaolo Rodola' |
last post by:
Hi,
I'd like to know if there's a way to determine which is the best
buffer size to use when you have to send() and recv() some data over
the network.
I have an FTP server application which, on data channel, uses 8192
bytes as buffer for both incoming and outgoing data.
Some time ago I received a report from a guy who stated that
changing the buffers from 8192 to 4096 results in a drastical speed
improvement.
I tried to make some tests...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
