Create table X attribute(s) datatypes; X is a variable.

[ghai_gaurav205]

want to know if the create table command in oracle 8i can take variable as the table name.

basically i want to create tables for each student giving an online test and evaluate his answers. i don't know the number of students giving the test. what should be done.

[chazzy]

you should rethink your design for one thing. different students should not have separate tables since they have the same structure. oracle has a lot of tools that can help manage permissions at even a row level. you can also create views, only give the students permission to see what they should see.

[ghai_gaurav205]

basically the tables that i am creating are temp ones and as soon as the results are evaluated, the tables would be destroyed. but if this is still not a good design, then can you plz tell me the tools that oracle has that can help manage permissions at even a row level.

[chazzy]

explain further.

[ghai_gaurav205]

i am developing a site where students can give test online. the test is of objective type.
there r a number of tests, each of which has a unique test_id. now, any number of students can give the test. i have to evaluate their answers and diplay to them the marks scored.

what database tables should be made.