Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Converting CLOBS TO VARCHAR

    Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    analytical vs aggregate functions

    Are analytical functions replacement for aggregate functions? Some of the developers here are hurrying in replacing the group by aggregate functions with analytical functions just because they learnt something new :-).. Are the analytical functions faster always(compared to aggre...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Explain plan cardinality and cost

    Hi, I checked EXPLAIN PLAN of a Select Query(In SQL Devloper Tool by pressing F10 Short cut Key), there i noticed one column Cardinality with COST. As Cardinality Increases i noticed increase in COST, i read Optimizer chooses less cost plan to Execute the Queries so i am thinking...
    #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

    Referential Partitioning

    Hi Tom, I am working on an 11g database and writing a PL/SQL application that moves partitions from the active schema to an historical schema. In one instance, I have a RANGE partitioned table with two "child" REFERENCE partitioned tables. Since I'm not in 12c, I can't just do an...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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