Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Concat Spool File Possible? How to Store Delete result to Variable?
Thanks for the help!- SolidFish
- Post #8
- Forum: Oracle: All versions
-
Concat Spool File Possible? How to Store Delete result to Variable?
Dave Many thanks, ROWCOUNT was exactly what I needed. However, I am still a bit confussed between variables and bind variables. I had to setup my statement as the following to make it work: VARIABLE count NUMBER; BEGIN DELETE FROM myTable WHERE myValue > 0; :count := SQL%ROWCOUNT; END...- SolidFish
- Post #6
- Forum: Oracle: All versions
-
Concat Spool File Possible? How to Store Delete result to Variable?
Hi. Thanks for the help. Could you show exactly how to do the row count? Im kind of new to SQL so I dont know the exact syntax. Lets say I was doing: DELETE FROM myTable WHERE myValue > 0; How do I count the rows deleted after this? Thanks so much.- SolidFish
- Post #3
- Forum: Oracle: All versions
-
Concat Spool File Possible? How to Store Delete result to Variable?
I want to turn a spool file off / on and have it concatenate to the same file while I am running my SQL queries. Is this possible? Cant find this anywhere in my $100 Oracle guide... Also, how can I store the Number Result of a Delete query into a variable? Thanks so much.- SolidFish
- Thread
- Replies: 7
- Forum: Oracle: All versions
-
Importing a class
Ok, I am assuming the SavitchIn.java is your own class. You will first have to compile this to make it a class. Do "javac SavitchIn.java" Once that compiles successfully and creates the "Savitch.class" file, you are ready to import on your other main file. Simply do... -
-
VBscript commands for Excel
Would anyone know how to do ErrorHandler on VB within Excel? Since Goto statements are not allowed, I'm not sure what to do to handle error cases... -
Importing a class
Importing is done like "import myOtherClass;" at the of your file. for example, to use the java applet class (this is from the java library) you would have: import java.applet.Applet; public class HelloWorldApplet { ... ... } For classes that you made, just make sure those classes...
