Re: Question about entry level Oracle DBA

Alan Shein wrote:

> Yes, I know, but I'd be happy to get even the partial answer instead of a
> "hmmm" look.
>
> "Martin Doherty" <martin.doherty_at_elcaro.moc> wrote in message
> news:_5cB9.7$GH3.79_at_news.oracle.com...
> > Hmmm, it's not a totally accurate answer, since the chances are good
> > that you won't see the time (unless NLS date format has been altered).
> >
> > select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') from dual;
> >
> > Martin
> >
> > Alan Shein wrote:
> >
> > >Well, yes, that is the answer, but many interviewees don't know it.
> > >
> > >
> > >"Ash G" <ashishgug_at_yahoo.com> wrote in message
> > >news:cbafeb44.0211150908.3944859f_at_posting.google.com...
> > >
> > >
> > >>I tried select sysdate from dual and it worked
> > >>"Alan" <alan_remove_this_shein_at_erols.com> wrote in message
> > >>
> > >>
> > >news:<aohrjl$mfjar$1_at_ID-114862.news.dfncis.de>...
> > >
> > >
> > >>>Daniel,
> > >>>
> > >>>To save time in interviews, start with, "What is the SQL to display the
> > >>>system date and time?" I think even you will be surprised.
> > >>>
> > >>>-Alan
> > >>>
> > >>>
> > >
> > >
> > >
> > >
> >

And if they get the first part ... it makes a follow-up question that likely will drop you down to less than 5% of applicants.

Daniel Morgan Received on Fri Nov 15 2002 - 16:13:27 CST