Home » SQL & PL/SQL » SQL & PL/SQL » HELP needed!
HELP needed! [message #440168] Thu, 21 January 2010 07:58 Go to next message
TOPHER1
Messages: 7
Registered: January 2010
Junior Member
Hi im using PL/SQL and have very little knowledge in what I am doing...

I need to do the following.. I need a script for..

Using PL/SQL, create a stored function to retrieve the number of estimated hours applicable at the date of estimate for any given task_id.

and also

Using PL/SQL, create a stored procedure that produces an estimate using standard rates for any given stage of any project.

Thanks in advance
Re: HELP needed! [message #440169 is a reply to message #440168] Thu, 21 January 2010 08:00 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
HI Welcome to forum.
Please read this.Forum Guide lines.
Please provide a test case.


sriram Smile
Re: HELP needed! [message #440170 is a reply to message #440168] Thu, 21 January 2010 08:01 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Show us what you have tried and where you have the problem.

An answer of "I don't even know where to start" does not show any effort, so please at least try something.
Re: HELP needed! [message #440171 is a reply to message #440168] Thu, 21 January 2010 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And from where could we start with what you posted?

You can start from:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Re: HELP needed! [message #440254 is a reply to message #440168] Thu, 21 January 2010 16:39 Go to previous messageGo to next message
TOPHER1
Messages: 7
Registered: January 2010
Junior Member
I really have no idea where to start this is the problem, my first lesson was today ...
Re: HELP needed! [message #440255 is a reply to message #440254] Thu, 21 January 2010 16:41 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
It would be helpful if you provided DDL for tables involved.
It would be helpful if you provided DML for test data.
It would be helpful if you provided expected/desired results & a detailed explanation how & why the test data gets transformed or organized.
Re: HELP needed! [message #440280 is a reply to message #440254] Fri, 22 January 2010 00:05 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TOPHER1 wrote on Thu, 21 January 2010 23:39
I really have no idea where to start this is the problem, my first lesson was today ...

So first read the book.
We also have no idea where to start as you didn't post anything.
If you/we have to query tables you/we have to at least know what are the tables and columns and relationship between them.

Regards
Michel

Previous Topic: Sorting strings in Order
Next Topic: How to laod excel data into Oracle Db
Goto Forum:
  


Current Time: Mon Dec 05 21:22:34 CST 2016

Total time taken to generate the page: 0.10346 seconds