Introduction In the first part of this two-article tutorial, we introduced using Oracle Database 12c CDB and PDBs on Oracle Cloud service with Toad for Oracle. In part two of the tutorial we shall dis...
Introduction Oracle Database 12c was added to Oracle Cloud Platform about a year ago in Q3-Q4 2016. Oracle Database 12c introduced the CDB and PDBs, which make it feasible to run multiple pluggable da...
Everyone takes shortcuts. It’s normal. But we shouldn’t be doing it. It comes with some disadvantages. Sometimes it doesn’t look pretty, sometimes the shortcuts cause performance problems, sometimes ...
A brand new Exadata X5-2L eighth rack (I knew the latest is X7 now, but it was for a POC, so no worries) has been deployed recently at a customer for Oracle EBS Exadata migration POC purpose. Its wasn...
Like many other Integrated Development Environments on the market, Toad for Oracle has historically operated in a Multiple Document Interface (MDI) mode: one single application window with multiple do...
In my previous post, I showed how easy to import data from CSV, JSON, Excel files using Pandas package. Another popular format to exchange data is XML. Unfortunately Pandas package does not have a fun...
Introduction In an earlier article we discussed using PostgreSQL database on localhost with Toad Data Point. In this continuation article we shall discuss using PostgreSQL database on AWS RDS and Dock...
These Editor Tricks are Treats!! For a Happy Halloween and a happy time anytime in Toad! Enjoy these four sugar free Toad Treats!! Toad Script Runner (TSR) – Have long running SQL Statements in To...
Remember those old Staples commercials that talked about an "Easy Button?" Aren't there so many things you wish there was an easy button for? What about Toad? Some people say there are too many button...
Although I think that R is the language for Data Scientists, I still prefer Python to work with data. In this blog post, I will show you how easy to import data from CSV, JSON and Excel files using Pa...
Managing multiple diverse database platforms and hybrid environments has become the new norm for DBAs. But the evolving database landscape comes with its challenges. In this video, Computer Weekly Edi...
Introduction PostgreSQL database is one of the leading open source databases, with unique features such as support for advanced datatypes including multidimensional arrays and user0defined types, comm...
