a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonymous block should use the function to find the total number of parts for the order with orderNo=1020. Verify if the result is correct.

b. Write a stored function. Similarly, the function has an input parameter orderNo and calculates the total number of the parts in the order.

Posted Date: 5/6/2013 2:42:12 AM | Location : United States

Ask an Expert

Related Discussions:- Write an anonymous block that contains a pl/sql function, Assignment Help, Ask Question on Write an anonymous block that contains a pl/sql function, Get Answer, Expert's Help, Write an anonymous block that contains a pl/sql function Discussions

Write discussion on Write an anonymous block that contains a pl/sql function
Your posts are moderated

Write your message here..

Related Questions

Example of group by and collect operator, Example of GROUP BY and COLLECT O... Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Read-only operator (+) - sql, Read-Only Operator (+) - SQL The term r... Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

If statement - syntax, IF Statement The IF statement executes a series ... IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Appgen to sap data export, We are seeking a freelance consultant that is fa... We are seeking a freelance consultant that is familiar with Appgen applications. We require exporting all our data into a format appropriate for importing into SAP Business One. Pl

Example of not exists operator - sql, Example of NOT EXISTS Operator - SQL ... Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Select query, Query: SELECT * FROM EMPLOYEE1; Select 5 columns and ... Query: SELECT * FROM EMPLOYEE1; Select 5 columns and all rows from one table Query: SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

Cause of indeterminacy in sql, Cause of Indeterminacy in SQL One root ... Cause of Indeterminacy in SQL One root cause of indeterminacy in SQL lies in its implementation of comparison for equality. For certain system-defined types it is possible for

Pl sql code to declare cursors with parameter, Write a pl/sql block that de... Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Definition of from - sql, Definition of FROM - SQL Recall that the ope... Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Mysql developer/programmer, Project Description: I want somebody who can... Project Description: I want somebody who can help me with an idea that I have been working on for a few months now. The person will require extensive knowledge of warcraft 3 PvP