I conducted an experiment with the recyclebin parameter. First, I set recyclebin = OFF to observe the behavior of a regular DROP TABLE. As I understand the architecture: there is a tablespace and a segment, for example T1.Information about this segment is stored in the data dicti...

Hi Tom, I have created a TYPE as: Create or replace type NUM_ARRAY as table of varchar2(1000); Then I have a procedure which accepts an ARRAY of sql statements and executes one at a time. Now this take a lot of time to process a batch of sql statement. I was wondering if I can us...

I'm using Apex 23.1 and I want to add a new font family in Tiny MCE with url file reference ! here's what I've done : 1- in Initialization JavaScript Function section tinymce.init({ /* ... */ font_formats: "Andale Mono=andale mono,times; Arial=arial,helvetica,sans-serif; Arial

Hello, If we are using Oracle SE2 there is no Tuning Pack or Diagnostic Pack available. So I don't think it's possible to create a SQL profile with SQL Tuning Advisor. would it be possible with SQLTXPLAIN coe_xfr_sql_profile.sql script ? I know it's possible to create a SQL plan ...

Hi, I have a database with thousands of tables containing the same kind of information. I need to write a program to aggregate these informations and thought about using a sqlmacro. -- This is a very simplified concept create or replace function get_val (p_table_name varchar2)