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
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
Related Q & A:
- How can I optimize this dynamic SQL query in oracle with PL/SQL?Best solution by docs.oracle.com
- How to control the excessive use of ram by SQL Server?Best solution by Database Administrators
- How to write SQL statement with dynamic where clause?Best solution by Stack Overflow
- How do I remove the base from my LCD TV?Best solution by ehow.com
- How to identify the acid, base, conjugate acid, and the conjugate base?Best solution by ehow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.