The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 01, 1998
Filed:
Mar. 12, 1996
Peter A Wallack, Sunnyvale, CA (US);
Oracle Corporation, Redwood City, CA (US);
Abstract
The present invention is directed toward a method for storing, verifying and salvaging user-defined queries in a database environment. The method comprises retrieving a stored query and an associated stored application version identifier and comparing the stored application version identifier with a current application version identifier. If the application version identifiers do not match, the entire stored query is checked for validity. If an error is found in the stored query, the query is parsed into subparts and each subpart of the stored query is checked for validity. If a subpart is valid, it is built into a new, updated query. The stored version identifier is updated to reflect the current application version so that verification is not performed again.