SQLPlus Results Truncated

February 16, 2011 at 08:42:26
Specs: Windows XP

I'm new to SQLPlus and have been given a script to run:
select distinct PersonID, Personnum, Personfullname as Name, Accessprofilenm from vp_person where employmentstatus='Active' and useraccountnm is not null and useraccountstatus ='Active' order by accessprofilenm asc, name

I output it to a spool file.

This is working but stops after 1726 rows with the message "1726 rows selected"

The data produced is correct but many more people should appear on the list.

What do I do to get all the data?

See More: SQLPlus Results Truncated

February 22, 2011 at 05:37:15

Can anyone shed some light?

Report •

February 22, 2011 at 12:10:06
That SQL query should work. Are you sure that there should be more results?

Report •

February 23, 2011 at 00:41:23

I have done some digging and think it is the Active flags; so yes, it is correct under those selections.

Report •
Related Solutions

Ask Question