pl-sql program

Dear Sir, I found out the formula is H = [kCx] [N-kCn-x] / [NCn] . if that is incorrect, let me know the corrections. You want me to develop on oracle right? some function that will output when the query is "select hypergep(4, 1, 1, 1) from something;", chat with me and let me know. i have enough experience just check my reviews :)

Hi, I'm certified Oracle DBA and Oracle developer. You can contact with me at any moment to discuss your project.

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble

Hi I have 15+ years of experience in oracle database applications development. I have bachelor degre in cs, 22 certified oracle trainings, web app dev certificate from university in Chicago. I will be glad to help you on this project.

I will provide you pl/sql code for this. It will take 1 day to complete this task. please let me know if you want to proceed further.

A proposal has not yet been provided

I have 8 years of experience with product development using various technologies including Java, Oracle. I am currently working with product based company and responsible for product design and high quality code delivery. I am looking for part time opportunities to work.

Hello! This is your function: create or replace function HYPERGEO( N NUMBER, K NUMBER, nn NUMBER, kk NUMBER ) return NUMBER IS Res NUMBER; FUNCTION factorial (b NUMBER) RETURN NUMBER IS fc NUMBER; BEGIN fc := 1; FOR i IN 2..b LOOP fc := fc * i; END LOOP; RETURN fc; END; BEGIN IF K < kk THEN RETURN -1; END IF; Res := 1; IF K > kk THEN Res := Res * factorial (K) / factorial(K - kk) / factorial(kk); END IF; IF N - K < nn - kk THEN RETURN -2; END IF; IF N - K < nn - kk THEN Res := Res * factorial (N - K) / factorial(nn - kk) / factorial(kk); END IF; IF N < nn THEN RETURN -2; END IF; IF N > nn THEN Res := Res / (factorial (N) / factorial(N - nn) / factorial(nn)); END IF; RETURN(Res); END HYPERGEO; -- This is script for testing: BEGIN DBMS_OUTPUT.put_line('4, 1, 1, 1 = ' || HYPERGEO(4, 1, 1, 1)); DBMS_OUTPUT.put_line('4, 2, 1, 1 = ' || HYPERGEO(4, 2, 1, 1)); DBMS_OUTPUT.put_line('4, 2, 2, 1 = ' || HYPERGEO(4, 2, 2, 1)); DBMS_OUTPUT.put_line('4, 2, 2, 2 = ' || HYPERGEO(4, 2, 2, 2)); DBMS_OUTPUT.put_line('50, 20, 6, 5 = ' || HYPERGEO(50, 20, 6, 5)); DBMS_OUTPUT.put_line('90, 20, 6, 6 = ' || HYPERGEO(90, 20, 6, 6)); END; It is a draft, if we agree, I will make error handling and cheking for boundary conditions. Thank you.

Ainda não foi fornecida uma proposta

A proposal has not yet been provided

A proposal has not yet been provided

A proposal has not yet been provided

I have more 7 years expirience of Oracle PL/SQL. My primary skills: PL/SQL, SQL, T-SQL, C++(MFC,STL),NER,Java, BI Reporting, Form Builder, XML/BI Publisher, OAF, Visual Studio

A proposal has not yet been provided

A proposal has not yet been provided

I can make the job, i have a great experience with formulas. I can resolve your problem fast. You just need to contact me. I can Write a main program that tests HYPERGEO .

Hello, Good Morning..!! I have 1.5 years of experience in the PL/SQL function and stored procedure developing and testing. I am sure that I wont disappoint you and will work to utilize my knowledge at the best. Note:-I have gone through the document you have provided and I need some time to develop the function as it is very crucial regarding to the probability and needs to be tested very well in terms of the logic which you have provided. Thanks, Bhavin Shah

A proposal has not yet been provided

I have great experience with PL-SQL (Oracle), work with it 3 years in a giant company that has revenues of around 2.5 billion a year. Where the database has thousands of procedures / packages / fuctions and tables. I guarantee I can do everything you need.

I have a very good experience with SQL and PL/SQL and the solution to your question shall be easily provided in a short time!