| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Query on running SQL scripts with NT
Believe it or not, the syntax problem you are stating, common on all
platforms that support LONG FILE NAMES. The issue is to either parse the
individual arguments, or treat the input as 1 item. Long file names allows
for the use of spaces in the names. As a result, the program reading the
file name needs to be aware that the entire input is 1 entry or a bunch of
little entries.
Our convention has been to replace all spaces in file names with underscore characters '_'. That way the file name is only 1 item and not a bunch of pieces.
-----Original Message-----
From: O'Neill, Sean [SMTP:Sean.ONeill_at_organon.ie] Sent: Wednesday, November 15, 2000 7:47 AM To: Multiple recipients of list ORACLE-L Subject: Query on running SQL scripts with NT
This is notan Oracle based problew but I'd appreciate input please on:
For running scripts in SQL*Plus on NT I've noticed that if filename
containing script
has spaces e.g. g:\Show me value.sql, to execute this script in SQL*Plus I
need to specify @"g:\show me value". What other forms of syntax, if
any, can I use to realise same functionality?
Sean :)
###### ###### ###### ###### # # # # # # # # Rookie #### # # ###### ###### Data # # # # # # # # Base # # ####### ###### # # Adminstrator -------------------------------- ------------Organon (Ireland) Ltd.
Visit: http://www.egroups.com/group/Oracle-OCP-DBA
The only man who never makes a mistake is the man who never does anything.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: Sean.ONeill_at_organon.ie 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 Wed Nov 15 2000 - 08:04:05 CST
 |
 |