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: 21806
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: Design decision - Table partitioning for archiving?
Next Topic: What is user's pre qualification to connect to Oracle Designer
Goto Forum:
  


Current Time: Thu Mar 28 11:52:06 CDT 2024