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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shockerman

    Run a query # of times in a given month?

    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...
  2. Shockerman

    Make query run # of times in the month??

    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...
  3. Shockerman

    How to get a query to output to a .dbf file???

    How would I get the output of the query into a csv vile? It comes out just in plain text, with no type of formatting?
  4. Shockerman

    How to get a query to output to a .dbf file???

    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>
  5. Shockerman

    Output to a .dbf file??

    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>
  6. Shockerman

    Which SQL command will display a list of tables in my Oracle database

    select *<br> from user_tables;<br> <br> or if you just want to see that table names,<br> <br> select table_name<br> from user_tables;
  7. Shockerman

    How to adapt or map data to sql?

    Nitram, <br> Thank you for your response, I need to read up a bit on triggers. Does you or anyone know if there is a way to do something like this?<br> <br> insert into NEWTABLE (Code) values (198) AND select breed, dogid, description from OLDTABLE where (Code1=B1) AND (Code2=C2);<br> <br> I'm...
  8. Shockerman

    How to adapt or map data to sql?

    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...
  9. Shockerman

    Mapping info question

    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...

Part and Inventory Search

Back
Top