Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    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
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    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...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more