Re: date

Sybrand,

Well, I may not be quite as long in the tooth as you , but I have sufficient experience to understand the why's and wherefores of the software business. (Un)Fortunately, I have no experience of Oracle and little of SQL because I have not needed them up to the present. Fate has recently dealt me a surprise Oracle card and I have to visit for a very brief period and then go on to other things. I live and work in the forest, many miles from any technological center (>300) and have zero contact with technological peers. Because of this, I sometimes have to embarass myself and ask dumb questions in a very public forum. You have apparently latched onto this and are enjoying yourself delivering arrogant advisories about how us lazy young starters (I was actually a very early Usenet user when I lived in California) are too incompetent to become DBAs etc. Now please read the following: I am not a DBA, I do not wish to become a DBA, I respect the expertise of effective DBAs, especially when they help dummies like me. Following this, please get off my case.....

d

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:954337532.24875.0.pluto.d4ee154e_at_news.demon.nl...
> Come on, sysdate and dual are in the SQL Language manual. I know more and
> more people are entrusted with DBA duties before they know anything about
> Oracle, and usually the first thing they do is posting to usenet. No
support
> contracts, no courses, no nothing.
> In the time I started with Oracle, there was no Internet, no Usenet, so
> basically I had to find it all out of my own. At least it made me LEARN
> something.
> And yes the laziness of current starters sometimes irates me, I admit.
Rest
> assured I won't respond to ANY of your future questions.
>
>
> Sybrand Bakker, Oracle DBA
>
>
>
> Dave Larkins <davidl_at_mint.net> wrote in message
> news:8bsv0c$bdi$1_at_ruby.mint.net...
> > Hi Sybrand,
> >
> > Oracle 8i DBA Handbook, Oracle Press/Osbourne. Index mentions neither
> > "sysdate" nor "dual", in my mind reasonable grounds to as a question on
a
> > newsgroup. Fully expected some patronizing responses like yours. All I
can
> > say is that you don't need to reply if it is below your mighty DBA
skills.
> > (!)
> >
> > By the way, I read the newsgroup, you really don't have to mail your
> > cretinous repiles to my personal address.
> >
> > Dave
> > Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> > news:954308653.12643.3.pluto.d4ee154e_at_news.demon.nl...
> > >
> > > Dave Larkins <davidl_at_mint.net> wrote in message
> > > news:8briv3$lp6$1_at_ruby.mint.net...
> > > > Actually not running SQL*Plus but EmbeddedSQL in Powerbuilder. Even
> so,
> > > this
> > > > gave me all the info I needed, many thanks. I was suprised I did not
> > find
> > > > any reference to it by searching the Oracle documentation, a new
> Oracle
> > > > Press DBA handbook, all the popular web tutorials etc. Is this
> something
> > > > ODBAs get with their mothers milk?
> > > >
> > > > Paul Druker <pdruker_at_metaway.com> wrote in message
> > > > news:lmbE4.1831$784.29618_at_typhoon.southeast.rr.com...
> > > > > Usually by
> > > > >
> > > > > select sysdate from dual
> > > > > /
> > > > >
> > > > > in your SQL*Plus prompt.
> > > > >
> > > > >
> > > > > "Dave Larkins" <davidl_at_mint.net> wrote in message
> > > > > news:8brdgs$j5i$1_at_ruby.mint.net...
> > > > > > How does one get the system date and time from an Oracle
database?
> > > > > > Thanks Dave
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > No, either they search better, or they go to a course where they learn
> > that.
> > >
> > > Regards,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > >
> > >
> >
> >
>
>
Received on Wed Mar 29 2000 - 08:40:14 CST