Home » SQL & PL/SQL » SQL & PL/SQL » Re: Verifying if the data(one row) fulfilling a select criteria exists in the table or not
Re: Verifying if the data(one row) fulfilling a select criteria exists in the table or not [message #20588] Wed, 05 June 2002 22:16
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
as the data is fetched the rownnum is generated. so this qry will abort only after first fetch of data in buffer, and stops as the rownum is > 1.

Report message to a moderator

Previous Topic: poecedure in sql plus
Next Topic: 6502 PL/SQL: numeroc or value error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 10 07:07:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.