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

26 votes194 views2 answers
Mysql workbench download
SQL
1 vote181 views1 answer
Mysql count words
SQL
0 vote200 views1 answer
Dataframe lambda elif
SQL
0 vote190 views2 answers
How to find sql server agent jobs related to a database
SQL
2 votes175 views2 answers
Compare date mysql
SQL
0 vote145 views1 answer
Delete all rows from table sqlite
SQL
0 vote183 views1 answer
Sql server datetime to string
SQL
0 vote192 views1 answer
Join in update query in mysql
SQL
1 vote183 views1 answer
How to run sql script
SQL
0 vote182 views1 answer
Back up stored procedures mysql
SQL