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

    Grouping people on consumption

    Of course. I tried to translate the original Hungarian names and comments to English for easier reading. It is written in Oracle PL/SQL (it runs on 9i). The tables: PATIENT: the patient's ID's and the date of their death. CONSUMPTION: drug consumption (who, what, when). SEARCHED_DRUG: drug_id's...
  2. pjenei

    Grouping people on consumption

    Hi, I have to create groups of people based on their drug consumption and then I have to track the movements between the groups over time. So I have the following table (simplified for this task): CONSUMPTION ( SSN VARCHAR2(9), DRUG_ID VARCHAR2(9), SELL_DATE DATE) (SSN is the social...

Part and Inventory Search

Back
Top