| Need Help on Creating FUNCTION [message #670520] |
Tue, 10 July 2018 09:17  |
 |
vharish006
Messages: 70
Registered: August 2015
Location: Chicago
|
Member |
|
|
Hi All,
I'm new to PL/SQL and trying to create a function that will be used for updating some columns.
Please let me know if this correct or should we write it in a different way.
/*
FUNCTION Get_updated_recs(p_class_id)
RETURN SUB_REC_TYPE
IS
p_sub_rec SUB_REC_TYPE;
BEGIN
IF p_class_id = 'Business'
THEN
p_sub_rec.Business_General := 'x';
END IF;
BEGIN
IF p_class_id='The_Arts'
THEN
p_sub_rec.Arts_general='x';
END IF;
BEGIN
IF p_class_id='ProQuest Catalog news'
THEN
p_sub_rec.All Products='x';
END IF;
BEGIN
IF p_class_id='General,K12&Public Library'
THEN
p_sub_rec.K12&Public Library General='x'
END IF;
RETURN p_sub_rec;
END get_updated_recs; */
Thanks for your help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
