This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
Hi all, Im relatively new to database and that too on Oracle. I have a problem in designing a table. Let this table be TableA. It has some fields. Let the combinational key in this table be a, b, c. The field 'c' is of Integer type. My problem is this: I dont want the developer to gerenate the key 'c'. The different combinations of a, b, c are : a1,b1,1 a1,b1,2 a1,b1,3 a2,b1,1 a2,b1,2 a1,b2,1 a1,b2,2 etc..... From this series you can see that whenever the a,b combination is the same, the c value will be different and consecutive (eg: first 3 rows). How ever i can have the same c value, when the a, b combination is different. That is if i insert another row with a = a1 and b = b1, then the c value should be 4.
I hope u got my question. How can i achieve this?? Someone told me i can use triggers Please help me out Kindest Regards Saj