spool command in sql plus
From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Wed, 30 Jun 2010 08:22:48 -0700 (PDT)
Message-ID: <0793c00b-cd2e-4ccd-b226-28d7ca4439a2_at_x21g2000yqa.googlegroups.com>
I would like to pass a variable into a spool command so that a different report is created depending on the time of the create
Date: Wed, 30 Jun 2010 08:22:48 -0700 (PDT)
Message-ID: <0793c00b-cd2e-4ccd-b226-28d7ca4439a2_at_x21g2000yqa.googlegroups.com>
I would like to pass a variable into a spool command so that a different report is created depending on the time of the create
The pseudo code would be
_at_1=name || || to_char ( date etc )
spool _at_1
Does anyone know how I can achieve this using pl/sql & or substition variables
My aim is to timestamp the name of my reports
regards
Chris B
Received on Wed Jun 30 2010 - 10:22:48 CDT