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

Avoiding collection exceptions, Avoiding Collection Exceptions   In ma... Avoiding Collection Exceptions   In many cases, if you reference a nonexistent collection element, then PL/SQL raises a predefined exception. Consider the illustration shown b

Advantages of subprograms, Advantages of Subprograms The Subprograms g... Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

How pl/sql resolves the calls? , How Calls Are Resolved? The figure sho... How Calls Are Resolved? The figure shows that how the PL/SQL compiler resolves the subprogram calls. When the compiler encounters the procedure or function call, it tries to di

Unnest operator in sql, UNNEST operator in SQL The inverse operator of... UNNEST operator in SQL The inverse operator of GROUP is UNGROUP. SQL has an operator, UNNEST, that can be used for similar purposes, but its method of invocation is somewhat p

Adding table constraints, Adding Table Constraints ALTER TABLE ENROL... Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

Components of an object type in pl/sql, Components of an Object Type: A... Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

Assignment statement in pl sql, Assignment Statement: The assignment s... Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Using a host variable, Using a Host Variable You can declare the curso... Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Delimiters, Delimiters A delimiter is a simple or compound symbol whi... Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Logical operators-pl/sql expressions , Logical Operators The logical op... Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.