Re: Default Date Format...

"show parameter blah" is exactly the same as "select * from v$parameter where name='blah';

The difference lies in the fact that "show parameter" was an internal server manager command, and could thus only be issued from within server manager. The select statement can obviously be issued from any product that is capable of issuing sql.

The difference vanished (sort of) in 8.1.5, when sqlplus acquired the ability to issue privileged commands, "show parameter" amongst them. In 8.1.5, however, sqlplus also acquired numerous extraneous and not entirely anticipated, er, "features", and accordingly, I stick with server manager. In 81.6, sqlplus suddenly got a whole lot more reliable, and I don't object to using it as my main admin. tool. Once in sqlplus in 8.1.6, which one you use is entirely up to you -but 'show parameter blah' has a certain desirable concision.

On the other hand, when you do select * from v$parameter, you get to see whether a parameter is system modifiable, session modifiable, and whether it *has* been modified. I don't recall "show parameter" ever giving me that information.

I could have sworn that nls_date_format was just an environment variable, but I'm probably wrong -if it shows in the v$ then it isn't.

Regards
HJR Spencer <spencerp_at_swbell.net> wrote in message news:2bOc6.608$Yq5.207826_at_nnrp2.sbc.net...
> maybe no one else has ever tried changing the NLS_DATE_FORMAT
> in the init.ora before. i know i haven't. then again, i've never relied
 on
> the setting of this parameter in any application either... and i don't
 rely
> on the setting at the session level either... you just never know when
> some DBA is going to come around and change things like this... lol.
>
> i don't even know how to query the value of this parameter from the
> session level... is that what "show parameter" does ? i usually query
> the v$parameter table...
>
> are there any initialization scripts or triggers that are run when you
> start svrmgrl or connect to the database ? have you tried the same
> thing in sqlplus ?
>
> it must be something very simple that's being overlooked...
>
> "The Tentative DBA...." <mick_rice_at_my-deja.com> wrote in message
> news:94rukd$kmc$1_at_nnrp1.deja.com...
> > I'm just experimenting with the default date format on an 8.1.6 test
> > database here and adjusting the init parameter NLS_DATE_FORMAT. I had
> > been under the impression that if I adjusted the parameter then the
> > default date specification for the database followed. It appears not to
> > be that simple. I must be missing something very simple !
> >
> > SVRMGR> show parameter nls_date_format;
> > NAME TYPE VALUE
> > ----------------------------------- -------
> > ------------------------------
> > nls_date_format string DD-MON-
> > YYYY
> > SVRMGR> select sysdate from dual;
> > SYSDATE
> > ---------
> > 26-JAN-01
> > 1 row selected.
> > SVRMGR> select to_char(sysdate) from dual;
> > TO_CHAR(S
> > ---------
> > 26-JAN-01
> > 1 row selected.
> > SVRMGR>
> > --
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
>
Received on Mon Jan 29 2001 - 06:40:22 CST