How to calculate real wages?

How to calculate contractor wages base on this pl/sql statement ??? the following is the script?

  • CREATE OR REPLACE FUNCTION DECLARE BEGIN -- execution SELECT SUM(skills_price*No_hrs+NVL(comm,0)) -- the NVL means function lets you substitute a value when a null value is encountered, hence it will later convert NULL value to zero '0' FROM Skills, Daily_Work WHERE (StartDate IS NOT NULL AND FinishDate IS NOT NULL); -- exception END; / can u guide me how to create an effective pl/sql contractor wages script ?? pls advice me or provide some hints for my logic thinking , pls feel free to help terima kasih (thank you )

  • Answer:

    Sorry I only know Python, C++ and Java not sql... maybe i might learn it next year. Im only in my 2nd year of my computer science degree. Good luck though!

chin at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Sorry I only know Python, C++ and Java not sql... maybe i might learn it next year. Im only in my 2nd year of my computer science degree. Good luck though!

aimhigh1184

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.