Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    SQL developer hanging

    I am using version 23.1.1 and when I start up the application, it just hangs. I have no idea what to look at to even begin to diagnose the problem.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Export Oracle Label Security info from one DB to be imported into another DB

    Hi Sir, I'm trying to copy the Oracle Label Security information from one database and apply it to another one. I tried to use expdp/impdp and dbms_metadata.get_ddl, but I didn't have success using them. Is there a special package or tool to get this work done? Thanks in advance....
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Social Sign-In with Azure

    Dear Experts, Social Sign-in with Microsoft Azure/Office 365 in Oracle APEX applications is working well. I used this How-To: https://tm-apex.hashnode.dev/implementing-social-sign-in-with-microsoft-azureoffice-365-in-apex When I use the substitution variable in APEX (&APP_USER.) ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Design decision on database tables oracle DB

    Hello experts, I have a UNIQUE constraint on (col1, col2) for a table. But, due to new functionality, I need a conditional unique constraint based on col 3. So something like this: if col3 = 'Val1': UNIQUE constraint on (col1, col2) else: UNIQUE constraint on (col4, col5) I'm on ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Oracle returns default value for column on rows inserted before the column was added

    create table add_column_default ( id number ) / insert into add_column_default ( id ) values ( 0 ) / alter table add_column_default add col1 number default 5 / insert into add_column_default ( id, col1 ) values ( 11, null ) / select * from add_column_default order by id / I
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report