SQL

SQL

Citation preview

ORACLE SQL , PLSQL , APEX How To's BY DR.S.RAGHUNATHAN MCOM, DLLAL, PGDPM, CCCP, DSADP, MPHIL, AICWA, PHD

1

ABOUT THE AUTHOR

Dr.S.RAGHUNATHAN is one of the best trainers in various software‟s and trained newbie's and professionals. He is an expert in clipper and developed various application software‟s for his thesis purpose and these applications software‟s aged 20 years and still alive on usage. He is professionally qualified as Cost Accountant. Now that, he starts writing about his experience on teaching to cater the needs of his second innings (after retirement) of his life.

2

ACKNOWLEDGMENTS This book is dedicated to my DAD

(A V Sowrirajan (92 years ) Retired Hindi cum Sanskrit Pandit Thanks to my family members, friends who have given whole hearted support to write my first book.

3

WHY THIS BOOK Any person, who is familiarized with excel data handling, or who has experienced on using online banking or who has an experience on usage of browser based applications and who need to develop his own application package, this is the first milestone for his learning and development of application. Of course, there is story behind this attempt. A grocery merchant has approached me and asked whether I can help him to develop accounting application package for his business. I enquired about his education status and he said that he completed his schooling but unable to join the college due to family problems and took over his father‟s business for their family livelihood. Further he said that he manages the daily business transaction through excel sheet to ascertain his business status. He also said that if he can 4

able to generate an accounting application package like railway reservation ticket application model, then he can able to train his wife to operate that package and he can concentrate on other new business which he plans as real estate. I am surprised that whether he has any accounting professional knowledge apart from handling excel sheets. I am good at parting the application development knowledge on various platforms and languages but this specific application requires some more knowledge on jargons like debit, credit, transactions, voucher etc. I myself not sure “what to debit and what to credit on any transactions” Though, I do not know anything about his requirement, I pretend myself that as if I knew and understood his need but still need to know his understandings about his working modalities and enquired about his workings on excel sheet. He very casually said that it is very simple logic and does not require much knowledge to know accounting profession. I was taken a back and surprised to see his expressions but kept quiet. He further narrated as “Expenditures or receipts are grouped under accounting head like cash account, bank account, sales 5

account, purchase account, party account, expenses account, salary account, rent account etc. etc. As and when I require, I create a reasonable accounting head. Generally account heads are classified under two categories as Capital Nature, Revenue Nature.” His definition made me to sweat just below my throat and flowed through my chest. With a shaky voice, I asked him to give examples of the transactions on capital nature and revenue nature. Any transactions which have been done for the purpose of day to day routine of the business and have no life after the financial year can be classified as revenue nature and all other transactions can be classified as capital nature. He did not embarrass me and continued that buying goods for sale, paying salary to his workers, receipts from sale of goods etc. are ground under revenue nature and if the transactions pertaining to acquiring land, building, machinery, bank accounts which has life more than a year and for the development / improvisation of business may be classified as capital nature. I am confused about his definition and insisted to narrate about the transactions. He said, “Generally,