| Table Design for Billing purpose [message #252612] |
Thu, 19 July 2007 07:02  |
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  |
 |
Littlefoot
Messages: 21821
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
