Re: Did the query return any rows

From: absinth <absinth_at_gmail.com>
Date: 22 May 2005 17:12:40 -0700
Message-ID: <1116807160.680616.275510@o13g2000cwo.googlegroups.com>

Consider:

SQL> select row_id from CX_LOCK;

ROW_ID

---

1
2
3
4
5
6
7
8
9
10
11

ROW_ID

---

12

12 rows selected.

SQL> select row_id from CX_LOCK where ROW_ID='abc';

no rows selected Received on Sun May 22 2005 - 19:12:40 CDT