I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the answer in. I need to get this figured out ASAP, and understand it as well (most importantly). A few brief comments in the code would be greatly appreciated. Teachers aid claims it is a 30-50 minute project. Can/will upload support documents when given a place to.

Posted Date: 4/9/2013 6:36:03 PM | Location :

Ask an Expert

Related Discussions:- Oracle PL SQL, Assignment Help, Ask Question on Oracle PL SQL, Get Answer, Expert's Help, Oracle PL SQL Discussions

Write discussion on Oracle PL SQL
Your posts are moderated

Write your message here..

Related Questions

Referencing records, Referencing Records Unlike the elements in a coll... Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Implicit rollbacks, Implicit Rollbacks Before execute the INSERT, UPDA... Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save

Prepare a slq project, Project Description: I want to write some SQL st... Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Understanding varrays, Understanding Varrays The Items of type VARRAY ar... Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

Albeit simple method , Albeit simple method : These all the truth tabl... Albeit simple method : These all the truth tables give us our first as albeit simple method for proving a theorem: where check whether it can be written in propositional logic

Triffic light control system, write the program for traffic control system ... write the program for traffic control system with 10 second, 15 secod, and 20 second delay

Recursion versus iteration, Recursion versus Iteration Dissimilar the i... Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it

Exception handling, set serveroutput on declare a number(5); b n... set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

Data types in sql - decimal, Data Types in SQL - Decimal DECIMAL, NUME... Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ

Using rollback - , Using ROLLBACK The ROLLBACK statements end the pres... Using ROLLBACK The ROLLBACK statements end the present transaction and undo any change made during the transaction. The Rolling back is helpful for two reasons. Firstly, if yo