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 vote190 views1 answer
Oracle date summer time
SQL
0 vote197 views1 answer
SQL: calculate hours from two dates
SQL
0 vote202 views1 answer
Sqlalchemy empty table
SQL
0 vote187 views1 answer
How to check replication lag in mySQL
SQL
0 vote212 views1 answer
R write csv without index
SQL
0 vote194 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote181 views1 answer
Sql orcale i forgot what my name & password was
SQL
10 votes230 views6 answers
Mysql set root password
SQL
45 votes221 views5 answers
Grant all privileges mysql
SQL
0 vote222 views1 answer
How to pass list as parameter in SQL query
SQL