How to Count rows from Select Query 3

[sahernandez]

I have this problem.
I need to know how many rows my query it's gona return
I came from SQL and we used @@ROWCOUNT but here it's different.

I know that I can use a Variable and COunt(*) into variable,
But I already did that and when the query doesn't return anything and not sure what I gonna get in my variable.

Can Somebody Help Me..
Thansks

 

[jee]

If your query selects no rows, the count function will return zero.

 

[PCStorm]

There is a %ROWCOUNT in Oracle to find the number of rows a cursor has fetched. The count can be used to test before the cursor fetches. If no rows are returned the count variable will be NULL.

 

[Turkbear]

No version, no OS, no code..Oh Well, Crystal Ball time:

Select count(*) from sometable where something = something;

Hint : if you are assigning the result to a variable ( select count(*) into :avariable), if 0 rows are returned it may be 0

 

[sahernandez]

Thanks, you right with the Count(*) return 0