Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Is the 'set newpage 0' command supported in SQLcl? Not resulting in formfeeds between pages with our installed SQLcl version.

    Database version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQLcl: Release 21.1 ProductionSQL*Plus: Release 12.2.0.1.0 ProductionInstalled on Red Hat Enterprise Linux Server release 7.9<b>Script:</b><code>set echo offset feedb
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Storing variables for later queries

    Dear TOMThis code is not working for me since my PL/SQL release is too old<code>-- Since PL/SQL 20.2.0.175DEFINE usr = 'YourName';SELECT * FROM Table1 WHERE CreatedBy = '&usr';SELECT * FROM Table2 WHERE CreatedBy = '&usr';</code>How can I run these two queries
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    TNS-12560: TNS:protocol adapter error while creating listener

    Dear Sir,I have one issue while creating listener / starting listenerI am able to create a listener from the net manager but not netca. Even if it is created through net manager but not able to start the listener as it gives the same message "TNS-12560: TNS:pr
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Problems with my trigger and my rest service

    Greetings, I have a problem with a rest service that I made from Apex in version 21.1 and at the time of making the post method to insert I started to have problems with my trigger, and it indicates the following error:<code><b>555 User Defined Resource Error<
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    SPLIT STRING

    In the below one string i have to split based on "@" and then have to split "_" fields and then append "^" fields to three fields of "_" values.<code>"08550010201_750000.00_Royalty@0_22500.00_TCS@0_75000.00_DMF@08550010210_104.00_Four Mineral Premium@08550010
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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