RE: Why does script have more than one slash(/) inside?

2003-11-07 Thread Mercadante, Thomas F
Maryann, It could mean very bad things. For example. If you have the following: Insert into table as select * from another_table / / The insert will run twice. Try it. You may not like it. A slash means to execute what's in the sqlplus sql buffer. So whatever is in there will be executed.

Re: Why does script have more than one slash(/) inside?

2003-11-07 Thread Mladen Gogala
Your script contains URL? May be, if you show us the code snippet, we could tell you something that actually makes sense? Not that is normally to be expected from the DBA crowd, but you are welcome to try. Do you feel lucky? On 11/07/2003 01:39:26 PM, Maryann Atkinson wrote: Sorry if I bore you

RE: Why does script have more than one slash(/) inside?

2003-11-07 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: try. Do you feel lucky? No. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] In the

Re: Why does script have more than one slash(/) inside?

2003-11-07 Thread Jared . Still
Each '/' on a line by itself, at the beginning of the line, will re-execute the SQL statement in the sqlplus buffer. try this: select * from dual / / / / Jared Maryann Atkinson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/07/2003 10:39 AM Please respond to ORACLE-L To: