Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QA Views using Toad 1

Status
Not open for further replies.

makk07

Programmer
Aug 22, 2007
24
US
Hi All,

I want to perform Manual QA on "Oracle Views" written by another developer.

Please let me know what are the steps for doing manual QA, where to start from and I am using TOAD for Oracle. I never did this before.

Please help me out.

Thank You
mak
 
TOAD is a fine tool and will let you examine views, see their underlying SQL etc.

when you say
makk07 said:
I want to perform Manual QA
what precisely do you want to do?



Grinding away at things Oracular
 
I want to check wheather the view is returning the correct records or not.

Also I have never used TOAD before.
 
ok,

that's usually called unit testing. Empty the tables of all records, then add test records to verify boundary conditions, invalid conditions etc.

check that these appear in the relevant views as and when expected. Note that this is sometimes not a trivial exercise, so you should script your record deletion and insertion.

obviously take a back up of your data before starting testing, so if it all goes wrong, you can reverse the changes easily.

Regards

T

Grinding away at things Oracular
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top