Oracle7 "fieldtypes", "random selection" and more

From: Robert Peperkamp <R.Peperkamp_at_EDUC.RuLimburg.NL>
Date: Mon, 17 Jan 1994 14:30:12 GMT
Message-ID: <R.Peperkamp.6.2D3AA0F4_at_EDUC.RuLimburg.NL>

To whoever may know,

I have a couple of questions about Oracle v7 and I hope that some of you will take the time to answer them. Please do and THANX when you do!

• Does Oracle7 support fieldtypes for "free tekst of undefined length", like a (WP-)document?
• Same question for "pictures" (bitmaps, tiffs, gifs or whatever)?
• Is it possible to randomly select a number of records from a sub-set of records? Suppose I had a DB with 1000 employees (with fields like: gender, age, name) and I wanted to randomly select 10 males older than 25 (and there were 400 males older than 25).
• Is it possible to change the "structure" of a DB-table containing data, like inserting new fields or making a field longer?

Thanx!

---

ing. Robert Peperkamp
University of Limburg
Medical Faculty
Department of Educational development & Educational research The Netherlands
Europe
Internet: R.Peperkamp_at_EDUC.Rulimburg.NL

---

Received on Mon Jan 17 1994 - 15:30:12 CET