Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Simply enabling the option won’t enable those buttons. That option needs
to be enabled and you need a threaded session created in that Editor tab. This
means that a query must be executed in the editor tab to create the threaded
session. The dataset might also need to be editable.
OK, once we start betas up again, this will be an option. So your nulls can go
from this:
“Yeah, that’s right, I’m null! What are you going to do about
it???!?! Huh? Huh?? Yeah, I’m talking to you!! I’m Null!
NUUUUUUUUUULLLLLLLLLLLLLLLLLLLL!”
The auditors would want it to be scripted anyway to be able to document exactly
what was run. So put together a script that includes SELECT SYSDATE FROM DUAL
before and after your query, use the script, and give them the script output.
Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
Interestingly enough the answer is no. In those cases when they need us to run
1-time queries they just set an appointment, come over to my desk and make sure
that i run exactly what they send.
As the result i send them a screen shot of TOAD (they accept only jpeg files, no
text files or spreadsheets). It would be nice to have a date/time on that jpeg.
Gee, one-time statements? Result sets small enough to fit on one screen?
Auditors looking over your shoulder to make sure it’s done as requested?
I’m wondering what kind of statements these are. Is this DROP USER x,
while he/she is being held in a conference room and fired? Is this UPDATE
FINANCIAL_RESULTS SET NET_INCOME = NET_INCOME + 1000000?
If it’s a SELECT statement, can you simply add SYSDATE as another column
in the SELECT? Then it’ll show up in the screen shot on every row.
Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
