Hi all, I am new to Oracle TOAD. I just got a job as a database developer in which it deals with TOAD and Oracle. I want a small help in finding a nice tutorial for beginners. I have a little bit knowledge in backend like Oracle only school knowledge. I want complete tutorial, video [...]

• 0 Comments

Hi all, I need some help with defining a recursive relationship in a ER diagram. It is a part of my assignment and the below is quoted in the case study. Quote: Admin staffs are in-charge admitting inpatient to the hospital. Several nurses work in each ward and one of them is in charge of [...]

• 0 Comments

Hello guys, I have two tables with the following structure: TABLE A: Email Address, CampaignID, Source, Unsubscribe Email1,2 Email1,1 Email1,3 Email2,5 TABLE B: Email Address, SeedList, ListName Email1,SeedListA.SeedListA Email1,SeedListB,SeedListB Email2,SeedListC,SeedListC The purpose is to merge the two tables together. But there is a really strange rationale behind this merge. If there are records of an [...]

• 0 Comments

I am thinking of designing a database for financial use, that allows to save the expenditures and pending expenditures and give reports about the cash flow and the balance at the banks. the problem is it will be for a non-profit organization and I am voluntarily in this project. I am wounding, should I use [...]

• 0 Comments