Skip to Main Content
Ask The Oracle Mentors
Ask a Question
Recently Answered 2.0
With clause in distributed transactions
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...
SUM OVER PARTITION (WITH CONDITION)
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
Analytical Functions- a brief introduction
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...
Effective way of migrating billions of records
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...
silent connection to sqlplus in Korn shell
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...
Upcoming Office Hours
All Office Hours
Upcoming Office Hours Cards
Free training, how-tos and Q&A with Oracle experts, every month!