Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: NT Script

RE: RE: NT Script

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 18 Jun 2001 11:11:26 -0700
Message-ID: <F001.0032D857.20010618104618@fatcity.com>

Kevin,

sorry, I got notified that the .BAT file was stripped.

below is the text of the BAT file. Simply copy it into a notepad document, and name it TODAY.BAT

rem ************************************************
rem echo off
IF NOT '%1'=='' GOTO SetEnvVars
for /F "delims=/ tokens=1-4" %%i in ('date /t') do today.BAT %%i %%j %%k %%l
GOTO Done
:SetEnvVars
:: set DayOfWeek=%1
set Month=%2
set Day=%3
set Year=%4
:Done
rem ************************************************



Tom Mercadante
Oracle Certified Professional

> -----Original Message-----
> From: Mercadante, Thomas F
> Sent: Monday, June 18, 2001 1:47 PM
> To: 'kevin_at_dulcian.com'
> Cc: 'ORACLE-L_at_fatcity.com'
> Subject: RE: NT Script
>
> Kevin
>
> Attached is a TODAY.BAT file that, when called, creates three
> environmental variables (Month, day and Year) for your use.
>
> In another BAT file, simply
>
> call today.bat
> set export_file_name=export_%month%_%day%_%year%.dmp
>
> exp userid=u/pw_at_sid file=%export_file_name%
>
>
> hope this helps
>
> Tom Mercadante
> Oracle Certified Professional
>
> << File: today.bat >>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jun 18 2001 - 13:11:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US