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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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... -
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...
