Hi. I'm new one in oracle database and also I don't have some good knowledge in databases. I'm working in oracle forms and reports 10g so i'm creating some small form which relies on small database. What I need help from u all from this discussion is the basic stuff. For simplicity lets say I have two tables: Persons and Orders.
1) One to one
- I need sql/ pl sql code for creating this two tables and the references for one to one relationship and then how to insert data in parent and in the child table, update and delete sql.
2) One to many
- Same idea as one to one. insert or update sql and sql about creating the tables
3) Many to many
- Same as prev. two
I need help for this. So if u have some questions feel free to ask. I don't grasp easily databases, they aren't my best side, too much trouble with them. :/
Thanks