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

    Using a Query Parameter with the "like" SQL operator

    That worked real well. Thanks for your help.
  2. jdaubens

    Using a Query Parameter with the "like" SQL operator

    It worked! Thanks. Do you have any pointers on how to set up the Criteria to select all of the dates from a field with a date data type that belong to a certain month or certain year? Thanks again
  3. jdaubens

    Using a Query Parameter with the "like" SQL operator

    I have the need to select the records in a query based on the last 4 digets in a text field that are equal to a specified value. I created a Query with a parameter as follows: Parameter Data Type [Enter Report Year] Text Then in my Criteria row for the field in the query I...
  4. jdaubens

    Reverse Indexes

    I have several large tables in an Oracle 8 database with primary keys that are sequence numbers. Has anyone ever created a primary key constraint forcing the index to be a reverse key index to eliminate "sliding indexes" (ie. old keys always deleted from one end of the b-tree and...
  5. jdaubens

    Use of Materialised Views in Oracle 8i

    Can indexes be created for materialized views?  If not, how can accessing a non indexed materialized view be quicker than accessing an indexed table even if the table has many more rows in it?

Part and Inventory Search

Back
Top