Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

 

9 HOW TO CREATE TABLE

We have an intention of creating two application software's using this book content, so that one can understand the barest minimum concepts, and want to gain the confidence booster. One application will be handling  voucher entries and result can be viewed through profit and loss account, balance sheet. Other application to understand some of the concepts in different approach. With this intention, required tables and  business rules, process logic,  validation, computation etc. will be learnt.

The following tables require for our application development. Table design will be discussed and associated business rules will be discussed on later part of the book.

I.            Control-Master    where    in    voucher- sequence number, Ledger-code sequence number, which has got relation with other tables are controlled and maintained.

Table Name : RAAK-CTRL-MASTER ( It