Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    How to spool CLOB data completely into a single line to a .csv file using Sqlplus?

    Dear Tom, One of my tables uses the clob datatype and has a total length of roughly 70000 characters. The data is truncating at 32767 characters when I'm spooling it to a.psv file, because of the set linesize 32767. I've used the following code. SET HEADING OFF SET VERIFY OFF SET...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Tablespace keeps autoextending to 30Gb

    Hi guys, I have the following issue: -When i add a new datafile on my SAP APP at PSAPSR3 tablespace with 1Gb for example and with maxsize of 30GB after 2 minutes Oracle resize the datafile to 30GB, if i resize again to 1GB 2 minutes after oracle resize again to 30GB. This behavio...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Issue with JSON Transform

    Hi Team, Any idea, why generic path expression based renaming of JSON fields does not work? A sample- 1. Below function transform top layer, but leaves nested layer. <CODE> Select JSON_TRANSFORM('{"field_a": 2, "field_b": 3 , "nested" : {"nested1":{"field_a":2, "field_b":3 }}}', ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    LOB - Replacing a part of / Not overwriting

    Hi Tom, Presently, it is not possible to replace a part of a LOB (the DBMS_LOB package does not have a replace function). The write procedure overwrites. Is it possible, if not why, to write at a certain position (not append) and offset the remaining portion while not overwriting...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Adding a column with a default value to a table

    Tom, I have a doubt about adding columns with default values to a table. Recently, I have stumble upon an Arup Nanda article on it where he states the following "When a user selects the column for an existing record, Oracle gets the fact about the default value from the data dict...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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