Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

Does PL SQL have a way to take a snapshot of the data and the script that captured the data? Like a viewer type tool you can send to someone?

Does PL SQL have a way to take a snapshot of the data and the script that captured the data? Kind of like the reader for Adobe PDF? (Obviously not connected to the DB?) I was looking at Packages but not sure if that is it. Sounds like it is close but not seeing a result set of records. Is there such a thing in existence or does anyone know if there is an Oracle tool or feature that does this? I was just thinking how useful it would be if you had a question about your script that if you could not only show the script but produce the result set of records it returned might be super helpful in solving problems. I apologize in advance for my ignorance. I googled it and did not see much that related. So back to the Experts...
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

My thought was to be able to show you the records returned from the query script entered. That way you could see the result set returned from the query and maybe see why it was bringing back the same records from the DB no matter whether I used the ' quotes around the number ' ... or not.

On another note. I believe you but always wonder if I should leave the question open a bit longer to see if someone knows of some new tool or maybe something out there new to the industry. Any thoughts on length of time to leave a question open when your not sure....(cause heck I would not know) if the question is complete or not? Thank you by the way. You guys are amazing to me. That's not fluff either....!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good stuff to know Fo' Sho' Thank you all.