Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Generate N TIMESTAMPs

    I need to CREATE some test data where I want to CREATE N number of timestamps between 2 times for every 15 minute interval including the start time and less than the end time. N would be defined as dbms_random between a low_number and a high_number. I want to run something like t...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    SYS.DBMS_NETWORK_ACL_ADMIN

    ORA-04063: package body "SYS.DBMS_NETWORK_ACL_ADMIN" has errors, how do I reinstall this package?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Bind variables in Live SQL

    Dear Tom, how can I create bind variable in Oracle Live SQL, <variable variable_name data_type;> example <variable dusko number;> just doesn't work, i get "Ussuported command" message... Thanks and best regards
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Using Dynamic Table Name in Select Statement To Prepare Extract File

    Hi. We use to prepare extract file from oracle using extract script. There are few tables whose name gets change every month. Need to handle these table names dynamically. SELECT TICKET_ID ,SOURCE_ID ,SERV_ID ,to_char(COLLECTED_DATE,'YYYY-MM-DD HH24:MI:SS')
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Grouping and updating column with equal parts

    Hi, I have a table that holds about 2 million records. No column in the table can be used to divide rows equally. Initially when the data is loaded into the table, the bucket_number column is null. After data loaded, I would like to calculate and equally divide the total no. of r...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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