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

    Changing tables in a report.

    I work in the DBA group and have been given a report that pulls data from 7 tables. Since the users want the data to be as of a certain date/time, I've created a separate table with all the fields contained in the report and then populate it with a stored procedure using the query in the...
  2. mikea64

    How do I delete rows from 1 table that don't exist in another table?

    Thanks EdWall, I'll pass this along to the poor guy who will be performing this and see how it goes.
  3. mikea64

    How do I delete rows from 1 table that don't exist in another table?

    I have 2 tables in Oracle8.1.7. Table A has 2 million rows, and Table B has 500,000 rows. Table B is a subset of Table A. Table A has referencial constraints to 3 other tables and CASCADE CONSTRAINTS is not enabled. How do I delete rows in Table A that don't exist in Table B, without using...

Part and Inventory Search

Back
Top