Which of the following correctly creates a function that performs an update on the BB_TEST1 table?
A. CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
SET col1 = p_num;
RETURN p_num;
END;
B. CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1;
SET col1 = p_num;
RETURN p_num;
END;
C. CREATE OR REPLACE FUNCTION fct_test1_sf (p_num)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
RETURN p_num;
END;
D. CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER(6))
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
SET col1 = p_num;
RETURN p_num
END
Answer: A
You might also like to view...
Global competition intensifies the need for effective MIS and business intelligence that are accessible throughout the company. How can IT provide valuable tools in fulfilling this need as well as conducting global marketing research?
What will be an ideal response?
Industrial policy attempts to fulfill all of the following objectives EXCEPT
a. improving the infrastructure for an industry. b. easing transitions for workers in declining industries. c. supporting troubled industries if the difficulty is temporary. d. fostering industries that offer long-run comparative disadvantage.
All items that appear in the books but not on the bank statement must be adjusted on the books using journal entries
Indicate whether the statement is true or false
Practically all statistical analysis programs treat a "blank" as "missing data."
Indicate whether the statement is true or false