Re: HELP! Default date format in SQL*Plus isn't dd-mon-yy!

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 27 Feb 2003 11:01:40 +0100
Message-ID: <b3knm5$e8s$1@dackel.pdb.sbs.de>

"R" <R_at_R.R> wrote in message news:CUk7a.94352$na.1798369_at_news2.calgary.shaw.ca...
> What my problem (now resolved) was that I was not entering the ALTER SESSION
> statement correctly to set the NLS parameters. I was trying:
>
> SET NLS_variable = whatever
>
> and
>
> ALTER SESSION NLS_variable = whaterver
>
> but it's actually
>
> ALTER SESSION SET NLS_variable = whatever
>
> I'm finding Oracle to have the most inconsistent command structure that I've
> ever seen!

What's wrong with it?
That command line says that there are (or might be) several ways of altering a session and setting variable is just one of them. Therefore the "ALTER SESSION SET ..." makes sense.

Greetings!
Volker Received on Thu Feb 27 2003 - 04:01:40 CST