Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Generating Dates between two date ranges

    Hi Tom , I need to write a query which will give me a list of dates between two date ranges (start date and end date) . For Example if my start date is 12/01/2003 and end Date is 12/31/2003. i need to generate my output as Date ---- 12/01/2003 12/02/2003 12/03/2003 12/04/2003 12/...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex

    How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex I am calling https://api.textlocal.in/docs/sendsms
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Error in pl/sql code

    When i try to run this code: DECLARE STUDENT_ID NUMBER; BEGIN -- Generate the next value for the sequence SELECT LMS_STUDENT_DETAILS_SEQ.nextval; -- Insert data into LMS_STUDENT_DETAILS table INSERT INTO LMS_STUDENT_DETAILS (STUDENT_ID, STUDENT_NAME, GENDER, DATE_OF_
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Mixed version dataguard

    According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed. Could you please just confirm that 11.2 -> 12.2 is really possible? If so, what about 11.2 -> 19.x ? Or 12.2 -> 19.x ? Of cours...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Is it a must to run pupbld.sql as system

    Tom, I create databases then I run the catalog.sql and catproc.sql. Sometimes, I donot run pupbld.sql. Users may get warning message but they could login and work. But, My friend says that if pupbld.sql is not run as system then users will get the error messages and they cannot l...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report