Oracle: how to put value in a variable from a SQL statement

Question

I want to use the total number of records in a table in a variable of data type number, but I am not able to do this if I use the following statement :

row_num number;
row_num := select count(*) from emp;

I am trying to use this in a procedure .. what's the correct way to do it?

eaolson · Accepted Answer · 2012-12-08 04:38:29Z

3

Assuming this is inside a PL/SQL procedure, the correct syntax is:

SELECT COUNT(*) INTO row_num FROM emp;

answered Dec 8, 2012 at 4:38

eaolson

15.2k7 gold badges46 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Murali N · Accepted Answer · 2012-12-08 04:38:18Z

1

Declare a variable and follow the query to copy count to a variable

DECLARE row_num NUMBER(10) := 0;

select count(*) into row_num from emp;

answered Dec 8, 2012 at 4:38

Murali N

3,5186 gold badges30 silver badges38 bronze badges

1 Comment

David Aldridge Over a year ago

No need to initialise the variable, I think. Count always returns an integer greater then or equal to zero, and a projection that consists only of aggregate functions always returns a single row in the absence of a group by clause

Collectives™ on Stack Overflow

Oracle: how to put value in a variable from a SQL statement

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related