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....
A ________ is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence...
A ________ is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. a. stored procedure b. stored function c. index d. trigger
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
I getting the error when creating query for PL/SQL CREATE OR REPLACE FUNCTION Customer_Details RETURN VARCHAR2;...
I getting the error when creating query for PL/SQL CREATE OR REPLACE FUNCTION Customer_Details RETURN VARCHAR2; IS Cust_Name VARCHAR2 (20); BEGIN SELECT FirstName INTO Cust_Name FROM Customer WHERE CustomerID = '300001'; RETURN Cust_Name; END; / I'm getting the error: 3/1 PLS-00103: Encountered the symbol "IS" Errors: check compiler log
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.
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago