equivale PL/SQL for simple expression 1

[masiwan]

In an SQL Transact SQL, one can write the following line:

select @cnt = Count(*) from employee

so that variable @cnt can be used to store the total number of records from the Employee table, and use it else where in your procedure;

I have tried;

cnt = Count(*) from Employee

in PL/SQL and I'm getting an error along this line, and PL/SQL does not seem to understand the COUNT(*) function whatcan I do ?

 

[SantaMufasa]

Masiwan,

Here is a sample proof-of-concept for what you want:

set serveroutput on format wrap
declare
    cnt number;
begin
    select count(*) into cnt from s_emp;
    dbms_output.put_line('S_EMP contains '||cnt||' rows.');
end;
/

S_EMP contains 25 rows.

PL/SQL procedure successfully completed.

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]