SQL Developer

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!

Unit Test - Can/Should I use PTTs for test data?

Mike KutzAug 5 2020 — edited Aug 5 2020

I'm working on a Test Suite where the comparison of Expected and Actual is better done if the test data is in a (temporary for the test) Table.

(I'm testing the Import/Export of XML data)

Can/Should I use a Private Temporary Table for Unit Testing?

I'd like to use a PTT so that I don't have create a Teardowns for a table of test data.

Should the PTT have a lifespan of a Transaction?

Or should it have a lifespan of a Session?

Database: ATP Free Tier (currently 19c)

SQLDeveloper: 20.2

Thanks,

Added on Aug 5 2020

#sql-developer

2 comments

71 views