Re: date

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 - 07:41:13 CST