CREATE OR REPLACE PROCEDURE HR.TEST_GLB AS
create global temporary table TEST_TABLE
on commit delete rows
as select * from HR.employees where 1 = 0;
insert into TEST_TABLE
SELECT * FROM TEST_TABLE;
Second, how do I call this to display results on screen or in file from Oracle SQL Developer?
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…