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