Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"No rows selected" message

Status
Not open for further replies.
JenniferCheng

JenniferCheng

Programmer
Aug 10, 2005
34
CA
Hi,
When run

select select * from core_info_table where core_id = '0' ;

Get message : "No rows selected".

Actually there are more than 1000 records with core_id=0 in table core_info_table.

Thanks.

Jennifer



 
Sort by date Sort by votes
Hi Jennifer?

Is it core_id = '0' or core_id = 0. The datatype of the field is important.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spd800c
  • Locked
  • Question
GIF icons not showing at runtime in Developer 10g
Replies
0
Views
130
spd800c
spd800c
puma51
  • Locked
  • Question
SELECT RETURNING MULTIPLE ROWS
Replies
1
Views
93
lewisp
lewisp
meridian99
  • Locked
  • Question
Stepping thru rows
Replies
1
Views
63
BJCooperIT
BJCooperIT
busi1
  • Locked
  • Question
select top n rows
Replies
0
Views
53
busi1
busi1
rleiman
  • Locked
  • Question
Calling a report on a temporary global table show no rows on report
Replies
3
Views
72
rleiman
rleiman

Part and Inventory Search

Sponsor

Back
Top