Hi Tom ! As there is put a restriction on GTTs: Distributed transactions are not supported for temporary tables does that mean that inline views in a query, i.e. using WITH clause, but those with MATERIALIZED hint will not work properly? If there is neither MATERIALIZED nor INLI...

Hi, I have to calculate accumulated value for a column, but I have to filter some rows (and it depends on that accumulated value). For example: CREATE TABLE dummy_table ( var_id NUMBER(5) PRIMARY KEY, prc number(5), qty number(5), v_type varc

Tom One of our main dissapointment is that , we cannot use analytical functions in sql from within a procedure, as they are not compatible with the pl/sql engine. Further, when I try to update my knowledge with the analytical functions, I get the doubt as to the total number of a...

Hi Tom, I have a task to migrate data from 4 hierarchical tables into few hundred flattened tables. I have developed some options but am looking for possible improvements or more effective ways. So I have 4 tables let's say: create table t1(id number, name varchar2(20)); create t...

Test case is connect to sqlplus in silent mode in korn shell and run a bunch of sql queries in one single sqlplus session..and where the out would be seen.. tried the following in test.ksh #!/usr/bin/ksh CURR_DIR=`pwd` echo "current directory is:" $CURR_DIR . $CURR_DIR/db.env ech...