PL/SQL 101 Question: Value to Variable 3

[Michael42]

Hello,

in PL/SQL how can I perform a count on a table (SELECT count(*) FROM table1;) and place the value in a PL/SQL variable?

Thanks,

Michael42

 

[feherke]

Hi

[b]declare[/b]
  [green][i]variable[/i][/green] [b]number[/b];
[b]begin[/b]
  [b]select[/b] count(*) [b]into[/b] [green][i]variable[/i][/green] [b]from[/b] [green][i]table[/i][/green];
[b]end[/b];

Feherke.

http://rootshell.be/~feherke/

 

[BJCooperIT]

declare
v_count  number;
begin
    SELECT count(*)
    INTO   v_count
    FROM   dual;
    dbms_output.put_line('Count='||v_count);
end;
/

Count=1

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com

 

[Beilstwh]

If you are talking about a sql*plus variable, then

column my_variable new_value my_variable noprint

select count(*) my_variable
from table1;

Bill
Oracle DBA/Developer
New York State, USA

 

[Michael42]

Guys,

These are all VERY useful ways of handling this.

Thanks for posting!

Michael42