Working with Group Execute in Toad for SQL Server
Working with Group Execute in Toad for SQL Server
This video shows users how to view and work with Group Execute in Toad for SQL Server....
Oracle R Enterprise Server Configuration
Oracle R Enterprise Server Configuration
Oracle R Enterprise Server Overview Oracle R Enterprise includes several components on the server. Together these components enable an Oracle R Enterprise client to interact with Oracle R Enterprise S...
You’re still loading spreadsheets into your database? STOP doing that!
You’re still loading spreadsheets into your database? STOP doing that!
I recently read a blog post where the writer was talking about importing a spreadsheet into their database. As I was reading this, I asked myself “why”? Why not just connect to your database and you...
Introduction to Oracle Intelligent Bots
Introduction to Oracle Intelligent Bots
Oracle recently announced their Oracle Intelligent Bot application just before Oracle Open World, coming as part of the Oracle Cloud Enterprise Suite cloud service. Chatbots are part of our future in...
Oracle Coding Best Practices – PL/SQL Tips and Techniques Part 4
Oracle Coding Best Practices – PL/SQL Tips and Techniques Part 4
Hi, This article will discuss some timings from last month’s FORALL load times. I had a student from a class share his timings using newer syntax that he learned in my class. I will talk about some ...
Optimize performance with DB2 z/OS specific features in Toad for DB2
Optimize performance with DB2 z/OS specific features in Toad for DB2
Toad DB2 Expert, Jeff Podlasek, demonstrates z/OS features in Toad for DB2 that can assist you to optimize performance of your DB2 environments....
Optimize performance with DB2 z/OS and DB2 LUW features in Toad DB2
Optimize performance with DB2 z/OS and DB2 LUW features in Toad DB2
Toad DB2 Expert, Jeff Podlasek, demonstrates features in Toad for DB2 z/OS and DB2 LUW that can help you optimize performance of your DB2 environments....
Using Quest Code Tester with a Centralized Code Schema
Using Quest Code Tester with a Centralized Code Schema
This zip file contains a Word doc that explains how you can use a backend API call in the my_codetester package to use Code Tester with a centralized code schema (summary: you need to tell Code Tester...
Code Tester – Testing attributes of object types
Code Tester – Testing attributes of object types
Tips for testing attributes of object types Suppose my code is this: CREATE OR REPLACE PROCEDURE qctod#out_object ( firstname_in IN VARCHAR2 , lastname_in IN VARCHAR2 , name_object_out OUT qctod#na...
Code Tester – Version Control Software
Code Tester – Version Control Software
Introduction A common question regarding Code Tester is how it integrates with version control software. More generally, it is important to know how and what one should considering storing in a versio...
Make Code Tester available to a specific schema (private synonyms)
Make Code Tester available to a specific schema (private synonyms)
Use the scripts in the linked file to grant access to Code Tester from a specific schema, and to create private synonyms on Code Tester objects in that schema. These scripts avoid the need to create...
Code Tester – Testing and refreshing data from production
Code Tester – Testing and refreshing data from production
Code Tester is the most powerful PL/SQL test automation tool available. You describe the expected behavior of your programs and Code Tester generates your test code, which can then be run from the UI ...