Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    HTML DB

    Tom - I read a little bit about the new features in 10g for HTML DB. I'm pretty excited about it if it effectively delivers on these new features (e.g., the whole meta-data driven framework, the Application Builder, Session Management, Templates, Security, etc
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Remove the invalid records

    Hi Tom and Team, I am looking to remove the invalid records before applying PK<code>create table OLD_ABC( PRODUCT, CLASS, SEASON_KEY, DATE, PRICE)KEY -- (PRODUCT, CLASS, SEASON_KEY, DATE)TABLE records -- Ex. ABC , 121 , S ,1-JAN-21, 15 PQR , 1
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Grant Access on DB_Link to other User

    I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Hierarchical Aggregation of Columns

    Hello all,Greetings of the new year!Goal - generate an output which can be directly used for pasting hierarchical data into a flat fileLink to liveSQL with sample data and scripts - https://livesql.oracle.com/apex/livesql/s/mw9olr17o7dir21jysn5jni1uExpected ou
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Error using DBMS_MVIEW.EXPLAIN_REWRITE

    Hello All,The problem I raised uses a scenario from one of the quizzes played recently on Devgym.I try to use DBMS_MVIEW.EXPLAIN_REWRITE for a materialized view in LiveSQLand for some reason, I encounter an error for both the table and the array version.- For
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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