How to use dynamic SQL in Oracle

The execution method is mainly usedExecuteImmediateExecute the combined SQL statement, for example:

Code -- Dynamic SQL
Create   Or   Replace   Procedure Hp_pro_ SQL
(
P_tablename In   Varchar2 , -- Table Name
P_result out Varchar2 -- Result
)
Is
V_tablename Varchar2 ( 30 );
V_ SQL Varchar2 ( 100 );
Begin
V_tablename: = ' Hp_no ' ;
V_ SQL: =   ' Select count (*) from '   | V_tablename; -- Combined SQL
Execute Immediate v_ SQL Into P_result; -- Execute dynamic SQL and assign the result to the variable
End ;