Which object is not a PL/SQL object? a. function b. trigger c. view d. procedure
Which object is not a PL/SQL object?
a. function
b. trigger
c. view
d. procedure
Homework Answers
Add Answer to:
Which object is not a PL/SQL object?
a. function
b. trigger
c. view
d. procedure
Oracle PL/SQL Using Dynamic SQL to create a procedure named add_row_sp for inserting a row into...
Oracle PL/SQL Using Dynamic SQL to create a procedure named add_row_sp for inserting a row into a table with three columns: add_rows (p_table_name VARCHAR2, p_column1 NUMBER, p_column2 VARCHAR2, p_column3 NUMBER). Testing the procedure by using the following block to add a record to the BB_TAX table: BEGIN add_row_sp ('BB_TAX', 4, 'SD', 0.02); END;
The procedure is a sample and needs to be modified. The software used is oracle 11g. Provide screen shot of the program running. EX.NO. 6 SQL TRIGGER AIM To develop the package for employee managemen...
The procedure is a sample and needs to be modified.
The software used is oracle 11g.
Provide screen shot of the program running.
EX.NO. 6 SQL TRIGGER AIM To develop the package for employee management system using SQL triggers. DATABASE SCHEMA EMP (EMPID, NAME, SALARY, COMMISSION, DEPT NO) PROCEDURE STEP 1: Start STEP 2: Initialize the trigger with specific table id STEP 3: Develop and execute SQL trigger to carry out the following action. Create a trigger on EMP table...
Create a PL/SQL procedure that takes department ID as an input and prints the details of...
Create a PL/SQL procedure that takes department ID as an input and prints the details of all the students including the Student ID (represented as StuID), name, and the description of the major that they are currently enrolled in. You may use the following procedure template: CREATE OR REPLACE PROCEDURE Student_Major (I_deptID IN Student.DeptID%type) AS CURSOR c1 is ... ... BEGIN ... END Student_Major;
PL/SQL Auction Program 1. Create a user xyz, who is the owner of the auction. Create...
PL/SQL Auction Program 1. Create a user xyz, who is the owner of the auction. Create the schema, and package. 2. Create users x1 and x2 who are the participants in the auction. They will need acces to the package. 3. Bid on the same item and record your observations. Verify all scenarios. Upload the files with the missing code and a detailed sample run. AUCTION OWNER.TXT SQL> conn / as sysdba Connected. SQL> drop user xyz cascade; User dropped....
Write appropriate PL/SQL statements to create a procedure to check that no section has more students...
Write appropriate PL/SQL statements to create a procedure to check that no section has more students than the capacity of the classroom in which the section is scheduled. Display the course_id, sec_id, semester, year, building, and room_number for the sections that have more students than the capacity of the classroom in which the section is scheduled. The following are the tables needed: classroom (building, room_number, capacity) section (course_id, sec_id, semester, year, building, room_number, time_slot_id) takes (student_id, course_id, sec_id, semester, year,...
oracle 11g 2nd edition pl/sql Assignment 5-10: Returning a Record Create a procedure named DDPROJ_SP that...
oracle 11g 2nd edition pl/sql Assignment 5-10: Returning a Record Create a procedure named DDPROJ_SP that retrieves project information for a specific project based on a project ID. The procedure should have two parameters: one to accept a project ID value and another to return all data for the specified project. Use a record variable to have the procedure return all database column values for the selected project. Test the procedure with an anonymous block.
SQL Each of the following statements about triggers is true except for one. Which one is...
SQL
Each of the following statements about triggers is true except for one. Which one is it? a A trigger can't be directly called or invoked O b A trigger can't raise errors C. A trigger doesn't accept input or return output parameters. O d. The code of a trigger can execute in place of the statement to which it's assigned.
You need to select one row at a time from a cursor table - and preform...
You need to select one row at a time from a cursor table - and preform an appropiate action after which sql construct do you use? a. cursor loop b. t-sql function c. t-sql procedure d. trigger e. while loop
The procedure is a sample and needs to be modified. The software used is oracle 11g. Provide screen shot of the program running. EX:NO:7 PLISOL PROCEDURE & FUNCTION AIM To develop the package for...
The procedure is a sample and needs to be modified.
The software used is oracle 11g.
Provide screen shot of the program running.
EX:NO:7 PLISOL PROCEDURE & FUNCTION AIM To develop the package for finding the number of students under each percentage for individual courses using PLISQL procedure and function. DATABASE SCHEMA STUDENT (ST_ID, NAME, COURSECODE, COURSENAME, TOTAL MARKS, PERCENTAGE) PROCEDURE STEP 1: Start STEP 2: Create a table with table name student. STEP 3: Insert at least 4 records...
PL/SQL gap-fill question: For the following stored procedure, please fill in the missing information in the...
PL/SQL gap-fill question:
For the following stored procedure, please fill in the missing
information in the underlined areas:
create or replace procedure get_items_shipped_capt as
cursor list_items(cid in captain.capt_id%type) is
select item.item_no,_____________________ ,weight from
item,shipment_line,shipment
where item.item_no = ____________________________ and
shipment_line.shipment_id = shipment.shipment_id and
shipment.capt_id = ___________;
cursor all_captains is
select capt_id
from captain;
TB constant char(1) := CHR(9);
begin
for cp in _____________ loop
dbms_output.put_line(Captain ID: '||cp.capt_id);
dbms_output.new_line;
dbms_output.put_line('Item
Number'||TB||'Description'||TB||'Weight');
dbms_output.put_line('=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
=+=+');
for det in list_items(______________) loop
dbms_output.put_line(det.item_no||TB||det.description||TB||
det.weight);
end...
The procedure is a sample and needs to be modified.
The software used is oracle 11g.
Provide screen shot of the program running.
EX.NO. 6 SQL TRIGGER AIM To develop the package for employee management system using SQL triggers. DATABASE SCHEMA EMP (EMPID, NAME, SALARY, COMMISSION, DEPT NO) PROCEDURE STEP 1: Start STEP 2: Initialize the trigger with specific table id STEP 3: Develop and execute SQL trigger to carry out the following action. Create a trigger on EMP table...
SQL
Each of the following statements about triggers is true except for one. Which one is it? a A trigger can't be directly called or invoked O b A trigger can't raise errors C. A trigger doesn't accept input or return output parameters. O d. The code of a trigger can execute in place of the statement to which it's assigned.
The procedure is a sample and needs to be modified.
The software used is oracle 11g.
Provide screen shot of the program running.
EX:NO:7 PLISOL PROCEDURE & FUNCTION AIM To develop the package for finding the number of students under each percentage for individual courses using PLISQL procedure and function. DATABASE SCHEMA STUDENT (ST_ID, NAME, COURSECODE, COURSENAME, TOTAL MARKS, PERCENTAGE) PROCEDURE STEP 1: Start STEP 2: Create a table with table name student. STEP 3: Insert at least 4 records...
PL/SQL gap-fill question:
For the following stored procedure, please fill in the missing
information in the underlined areas:
create or replace procedure get_items_shipped_capt as
cursor list_items(cid in captain.capt_id%type) is
select item.item_no,_____________________ ,weight from
item,shipment_line,shipment
where item.item_no = ____________________________ and
shipment_line.shipment_id = shipment.shipment_id and
shipment.capt_id = ___________;
cursor all_captains is
select capt_id
from captain;
TB constant char(1) := CHR(9);
begin
for cp in _____________ loop
dbms_output.put_line(Captain ID: '||cp.capt_id);
dbms_output.new_line;
dbms_output.put_line('Item
Number'||TB||'Description'||TB||'Weight');
dbms_output.put_line('=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
=+=+');
for det in list_items(______________) loop
dbms_output.put_line(det.item_no||TB||det.description||TB||
det.weight);
end...
Most questions answered within 3 hours.
-
find the critical value associated with a right sided hypothesis of
the mean using a sample...
asked 1 hour ago -
Which of the following statements is true with respect to a
simple linear regression model?
a....
asked 2 hours ago -
The energy required to remove an electron from a surface of a
solid element is called...
asked 3 hours ago -
How would you train your employees to avoid risks of using
mobile devices?
asked 3 hours ago -
Assume Kw = 1.01 ✕ 10−14
For pure water, we can calculate [H3O+ ] = [OH...
asked 4 hours ago -
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 5 hours ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 6 hours ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 7 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 7 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 8 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 10 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 10 hours ago