Is there anything in Oracle that will help me solve this problem? I have a query that I have to run for every day in the current month. The query is here, and say, for the month of July, I'd have to run it 31 times since July has 31 days in it, but I can't put numbers in the where clause...
I have a query that I have to run for every day in the current month. The query is here, and say, for the month of July, I'd have to run it 31 times since July has 31 days in it, but I can't put numbers in the where clause, because come September or February, I'll get an error saying couldn't...
Is there a way to get a query to output to a .dbf file. Not just so that it is named .dbf, but that it actually has the formatting correct? <br>
If not, does anyone know how to convert a .csv file to a valid .dbf file?<br>
Thanks in Advance.<br>
Is there a way to get a query to output to a .dbf file. Not just so that it is named .dbf, but that it actually has the formatting correct? <br>
If not, does anyone know how to convert a .csv file to a valid .dbf file?<br>
Thanks in Advance.<br>
Does anyone have any ideas on how I would go about setting up a sql program or any other type of program that could take a tab delimited ASCII file and be able to add the information to a table based on mapping constraints. For example, the ASCII file would look like this:<br>
Code1 Code2 Breed...
Does anyone have any ideas on how I would go about setting up a sql program or any other type of program that could take a tab delimited ASCII file and be able to add the information to a table based on mapping constraints. For example, the ASCII file would look like this:<br>
Code1 Code2 Breed...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.