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

1 vote204 views1 answer
How to set up a trigger in sql
SQL
0 vote208 views1 answer
Big table in mysql
SQL
0 vote275 views1 answer
Postgressql uuid
SQL
0 vote167 views1 answer
Online sql compiler
SQL
2 votes274 views1 answer
Create mysql user on all hosts
SQL
1 vote171 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote242 views1 answer
SQL get max per id
SQL
0 vote187 views1 answer
Sql compound operators
SQL
0 vote198 views1 answer
Mysql to get column name in database
SQL
1 vote189 views2 answers
Mysql allow remote connections
SQL