Home » Developer & Programmer » Designer » Table Design for Billing purpose
Table Design for Billing purpose [message #252612] Thu, 19 July 2007 07:02 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
hi all

I want to develop a software for Billing purpose

A company want to record a all sales in computer and at the month end want to print our billing for all clients I have design this in foxpro and in Foxpro we did that when new month will start then new table generate like Crd_0707 (Credit month year).

now I want to develop in oracle how I should start this project I mean who can I design tables.

thanks

Re: Table Design for Billing purpose [message #252628 is a reply to message #252612] Thu, 19 July 2007 08:26 Go to previous message
Littlefoot
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd avoid creating a new table for every month. Perhaps you would want to read more about partitioned tables.

Whatever it is, Oracle allows you to have HUGE tables and write queries against them. With proper indexing and performance tuning, you'll be able to print reports for all clients in no time.
Previous Topic: ERD Tool
Next Topic: modelling
Goto Forum:
  


Current Time: Tue Aug 22 04:26:17 CDT 2017

Total time taken to generate the page: 0.01103 seconds