Re: Question about entry level Oracle DBA

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DD90EBC.A1E065CA_at_exesolutions.com>...
> Joel Garry wrote:
>
> > ashishgug_at_yahoo.com (Ash G) wrote in message news:<cbafeb44.0211150908.3944859f_at_posting.google.com>...
> > > I tried select sysdate from dual and it worked
> >
> > Funny, I tried it and it didn't show any time.
> >
> > > "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
> >
> > jg
> > --
> > @home is bogus.
> > Interview questions that try to elicit certain answers in a
> > non-straightforward way are even more bogus.
>
> SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS')
> FROM dual;
>
> SELECT TO_CHAR(SYSDATE, 'HH:MI:SS')
> FROM dual;
>
> Daniel Morgan

Well, that isn't select sysdate from dual, is it? Would you hire someone who said SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR HH:MM:SS') FROM dual; ? :-)

jg

--
@home is bogus.
Yes, I know it's wrong.  But would you believe anyone who said they
never made that mistake?