Heh, yes Norm, I already accepted that my original expectation was wrong and
that has been corrected.
As I never relied on that functionality, I never had need to look it up in the
documentation. It’s also never played a role with me in the kind of
example the other responder posted about deleting all the data as I always
double check my work through various queries to make sure it’s exactly
what I wanted. If it wasn’t, I explicitly rolled back. If it was, I
explicitly commited.
In short: the default behavior of SQL Plus with regards doing an implicit commit
has never played a role in my case because it’s never had anything to do.
Heh, yes Norm, I already accepted that my original
expectation was wrong and that has been corrected.
That's me told then!
No seriously, I knew that you knew, I simply used your comment as a
handy place to tie on the extract from the docs.
As I never relied on that functionality, I never had need to
look it up in the documentation.
No neither have I. I remember way way way back in the mists of time,
when I did my first Oracle course, SQL and PL/SQL for Oracle 7. And on
day one, we were introduced to SQLPlus with a warning that we should always commit or rollback explicitly because SQLPlus will commit on
exit or may rollback on exit - depending on how things go. So, I always
have manually typed commit (or rollback) before exit since that very
day.
I think you and I both know it makes sense to be explicit - especially
when dealing with computers!
When I'm using a development tool (or library) I always check for the
default setting of auto-commit - and make sure it is set to give me the
full control that I need, and not set to something that someone else
thinks I need.
In short: the default behavior of SQL Plus with regards
doing an implicit commit has never played a role in my case
because it's never had anything to do.
I agree 100%!
Cheers,
Norm. [TeamT]
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
… it makes sense to be explicit – especially when dealing
with computers!
Heh, doesn’t that just tickle the funny bone every time an end-user
remarks something along the lines “why can’t it just do what I
wanted instead of what I asked?”
I’m still shocked though when a fellow developer – the more
experienced, the more shocked I am – honestly expresses the same question.
It doesn’t happen often, I can count on one hand the number of developers
who have expressed that. It simply boggles the mind when someone who is
“reasonably learned in the field” expresses such a lack of basic
knowledge.
Heh, doesn’t that just tickle the funny bone every time an end-user
remarks something along the lines “why can’t it just do what I wanted
instead of what I asked?”
My favourite, when I make yet another spelling mistake in a long Unix
directory name, or obscure Unix command, is "why doesn't it know what I
meant to type?".
Roll on Artificial Intelligence. Then Toad will know what we want to do
and have it done before we can figure out what it was we wanted to do,
and why!
most OS's cache keystrokes with an algorithm called intelli-sense
intelli-sense is supposed to remember the last command that started with
the n series of characters you have just typed
so the letter l will recall 'ls' and the letter r will recall 'rm'
all of which works fine up until the time you want 'r' to mean 'right' and 'l'
to mean 'left'
unless of course you wanted to rm right ...and ...list only the left
Martin Gainty
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
would appreciate a link to the beta when you get the chance thanks greg! Martin
______________________________________________ Verzicht und
Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht
ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten
wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung
einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von
Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der
leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt
uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous
n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour
satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou
la copie de ceci est interdite. Ce message sert à l’information seulement et
n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les
email peuvent facilement être sujets à la manipulation, nous ne pouvons
accepter aucune responsabilité pour le contenu fourni.
now we need a sign for Ed’s classic reply to the fellow who changed the topic
from Toad to something about animal rights (or lack thereof), which was along
the lines of “Left Turn, off the cliff !”
