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;
Code Example |
---|
Sql :: union vs intersect sql |
Sql :: select only one row sql |
Sql :: sql primary key syntax |
Sql :: t-sql check if data exists |
Sql :: import data from csv to sql server |
Sql :: postgresql change user role grant |
Sql :: sql server port |
Sql :: sql online |
Sql :: sql values to array of objects |
Sql :: pl sql search in all packages |
Sql :: functions with parameters SQL |
Sql :: oracle create tablespace autoextend |
Sql :: pgadmin see indexes |
Sql :: between vs in sql |
Sql :: update value sql |
Sql :: nth highest salary in sql |
Sql :: oracle inner join |
Sql :: phone number regex sql |
Sql :: sqlite get date only |
Sql :: SQL get last 5 minutes data |
Sql :: sql pivot |
Sql :: sql case statement |
Sql :: multiple order by sql |
Sql :: how to delete user sql server |
Sql :: Mysql table variables |
Sql :: Write SQL in ruby on rails |
Sql :: mssql remove duplicate rows |
Sql :: SQL FETCH FIRST Clause |
Sql :: insert or update sql query |
Sql :: back up stored procedures mysql |