DECLARE
p_template_code xdo_templates_b.template_code%TYPE
:= 'PRNT_XXX_YYY';
BEGIN
DELETE FROM xdo_templates_b
WHERE template_code = p_template_code;
DELETE FROM xdo_templates_tl
WHERE template_code = p_template_code;
DELETE FROM xdo_lobs
WHERE lob_code = p_template_code;
COMMIT;
DBMS_OUTPUT.put_line ('Total Rows Deleted ' || SQL%ROWCOUNT);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error ' || SQLERRM);
END;
p_template_code xdo_templates_b.template_code%TYPE
:= 'PRNT_XXX_YYY';
BEGIN
DELETE FROM xdo_templates_b
WHERE template_code = p_template_code;
DELETE FROM xdo_templates_tl
WHERE template_code = p_template_code;
DELETE FROM xdo_lobs
WHERE lob_code = p_template_code;
COMMIT;
DBMS_OUTPUT.put_line ('Total Rows Deleted ' || SQL%ROWCOUNT);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error ' || SQLERRM);
END;
Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Front end developer learn from Javascript Training in Chennai . or learn thru JavaScript Online Training India. Nowadays JavaScript has tons of job opportunities on various vertical industry.
ReplyDeleteHi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Front end developer learn from JQuery Training