Re: Getting the last_day in a SQL variable

From: Nigel Thomas <>
Date: Fri, 10 Jul 2009 13:20:14 +0100
Message-ID: <>

Ian has solved David's immediate problem, but just to answer the original question

I'm trying to do a sql script (please see below) but i cant figure out how
>> to get in a variable the value of the LAST_DAY in a month... any tips?

If you ever really need to get query result into a SQL*Plus variable (for example, so you can use it in another SQL*Plus directive like TTITLE or a SPOOL filename), you want to use COLUMN x .... NEW_VALUE. See Rene Nyffenegger's example <> or this OTN example<> .

NEW_VALUE is a part of the SQL*Plus COLUMN command<> .

Regards Nigel

Received on Fri Jul 10 2009 - 07:20:14 CDT

Original text of this message