Introduction to Oracle 18c Express edition (XE) Oracle 18c Express edition (XE) is a lightweight database that can be used to host small applications and is often used by students or developers to tes...
Remember the old days of original “dark mode?” I do. When I was in my second year at university, I was delighted to receive a personal computer XT as a gift. It was a wonderful gift because it allowed...
No database can process all queries expediently, but we can strive to make sure our databases process SQL as efficiently as possible. That means applying SQL performance tuning and optimization to our...
Quest® Toad® for Oracle and Toad Data Point offer powerful sets of features. However, it is essential to understand when it is most appropriate to use one tool over the other. When choosing between To...
I was having a hard time trying to connect to one of my test databases. It took a lot of trial and error until I realized it was because I was using an Oracle 19c client to connect to an Oracle 11g da...
Are you trying to figure out how to load data from Excel into your database? The problem: load data to Oracle Many business analysts rely heavily upon Microsoft Excel as one of their primary sources ...
What is data automation Data automation is the process whereby a series of repetitive steps used to upload, transform or otherwise handle data can be scripted and reused. The resulting automation scri...
In database parlance, batch jobs consist of multiple programs, PL/SQL procedures or SQL scripts run together in a sequence, optionally against multiple databases. An individual job is not much differe...
I remember when I was at the university and I took the class "Data Management." At that time, learning database schema design was challenging because we only had a blackboard, sheets of paper, pencils...
As developers of web applications for Oracle databases and for any developer who works with applications connected to a relational database, it is very important to know and understand what a database...
Can’t find time for SQL performance tuning? Reliant on overstretched DBAs who don’t have a spare minute? Don’t let your queries slow down the database. Learn how to optimize SQL query — in minutes. ...
Data Guard was configured a few days back at one of the customers site. An ORA-19527 error is continuously reported in the standby database alert.log (database name is changed) Errors in file /u01...
