Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete all data related to a record, but not the record itself.

1019833Jun 25 2013 — edited Jun 26 2013

I'm new to SQL and I really need help with this assignment, I'm not sure how or where to start.

Assignment details:

  • Delete all data related to a record, but not the record itself.
  • must accept input parm
  • There is is RI in the tables so I must delete children first

Comments

PuneetRekhade
Default Weblogic EM console does provide with in-built testing functionality.
Else, you can give a shot to "SOAPUI (http://www.soapui.org/)" tool.

Puneet.
Eric Elzinga
we also use soapui tests for all the integration tests we create
also have a look at soapuipro, lot's of nice functionality

you can easily connect to the database to verify data, or call other webservices to verify if some save action really got saved, and by retrieving all the data you have several different activities to assert your data (groovy, assertions, etc)
we also use some testing support database packages so we can easily trigger some situations we want to test

for loadtesting we use loadui which will eventually use the soapui projects to generate the load, in loadui you can then create production-like situaties (different amount of calls for different services etc)
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 24 2013
Added on Jun 25 2013
#11g, #data, #database, #oracle, #pl, #pl-sql, #plsql, #query, #sql, #sql-developer, #table
9 comments
541 views