1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is to return the tax amount. Review the contents of the BB_TAX table, which contains the tax rate for each state that needs to be taxed.

Posted Date: 10/30/2015 8:49:34 PM | Location : Canada

Ask an Expert

Related Discussions:- procedure, Assignment Help, Ask Question on procedure, Get Answer, Expert's Help, procedure Discussions

Write discussion on procedure
Your posts are moderated

Write your message here..

Related Questions

Effects of null, Effects of NULL The numeric variable X, perhaps of ty... Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

Updating by insertion, Updating by insertion Syntax : INSERT IN... Updating by insertion Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

Managing cursors, Managing Cursors The PL/SQL uses 2 types of cursors: ... Managing Cursors The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including th

Need for dynamic sql - pl sql , Need for Dynamic SQL: You need dynamic... Need for Dynamic SQL: You need dynamic SQL in the situations as follows: 1) You would like to execute a SQL data definition statement (like CREATE), a data control statemen

%notfound - implicit cursor attributes, %NOTFOUND The %NOTFOUND is the... %NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

Procedural constraint enforcement (triggers) , Procedural Constraint Enforc... Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

Write a pl-sql program using the implicit cursor, Question: a) Given th... Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Oracle, Literature review Literature review

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

Parameter & keyword description-execute immediate statement, Parameter and ... Parameter and Keyword Description: dynamic_string: This is a string variable, literal, or expression which represents a SQL statement or the PL/SQL block. define_vari