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?