8. PL/SQL Dynamic Query Writing Basics | How-To | PL/SQL Developer Course | TechView Team | Hindi
In this video we discuss how to write dynamic query in PL/SQL.
This is 8th video of PL/SQL Developer course series.
----Video Notes Start from Here-----------
create or replace FUNCTION COUNT_TABLE
(TABLE_NAME IN VARCHAR2)
RETURN NUMBER
IS
LV_COUNT NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM'|| TABLE_NAME INTO LV_COUNT;
RETURN LV_COUNT;
END;
--------------------------------
TASK FOR PARTICIPANTS
--------------------------------
create or replace FUNCTION COUNT_TABLE
(TABLE_NAME IN VARCHAR2)
RETURN NUMBER
IS
LV_COUNT NUMBER;
LV_SQL VARCHAR2(250);
BEGIN
LV_SQL:='SELECT COUNT(*) FROM'|| TABLE_NAME;
EXECUTE IMMEDIATE LV_SQL INTO LV_COUNT;
RETURN LV_COUNT;
END;
-----Video Notes End Here-----------
Regards
TechView Team
Watch video 8. PL/SQL Dynamic Query Writing Basics | How-To | PL/SQL Developer Course | TechView Team | Hindi online without registration, duration hours minute second in high quality. This video was added by user TechView Team 01 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 148 once and liked it 7 people.