Oracle dynamic select into

SET SERVEROUTPUT ON;
DECLARE
    sql_qry     VARCHAR2 (150);
    emp_tot     NUMBER(3);
BEGIN
    
    sql_qry:= 'SELECT count (*) FROM employees';
    EXECUTE IMMEDIATE sql_qry INTO emp_tot;
    DBMS_OUTPUT.PUT_LINE ('Total employees are: '||emp_tot);

END;

Source: rebellionrider.com

Similar codes

0 vote147 views1 answer
Sql server select record with max id
SQL
0 vote151 views1 answer
Left join vs inner join performance
SQL
5 votes151 views2 answers
Ranking functions in sql
SQL
0 vote157 views1 answer
Como hacer una consulta en sql
SQL
0 vote172 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote291 views2 answers
Create fulltext index mysql
SQL
-1 vote136 views1 answer
Plsql while
SQL
0 vote176 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote136 views1 answer
Partitioning in oracle-base
SQL
0 vote151 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL