Questions

Hello,1. Could you please confirm if we can use REST API as DATASOURCE for RDF report, to generate the output ? Otherwise, what alternative can be done to store REST API data and then use it for RDF report ? Will Before-Report trigger come into play ?2. Prev...

We have an overloaded stored procedure with the following declarations in our 3rd party application:<code>PROCEDURE GetPriceInfo (Location IN VARCHAR2, ProductCode IN VARCHAR2, SalePrice OUT NUMBER);PROCEDURE GetPriceInfo (Location IN VARCHAR2, ProductCode I...

Hi Tom,In an development Server we want to do a Rman Backup weekly which hasthe following tablespaces:SYSTEMSYSAUXUNDOTBS1TEMPUSERSIAGENT_DATAARCHIVE_MESSAGESI want to exclude the ARCHIVE_MESSAGES Tablespace in the weekly backup which has historical Data to sa...

Is there a report that will list the API's being called in a particular environment and their details?If not a report, is there somewhere in the UI? (Screenshots or path would be most appreciated).I don't know much about REST API's other than they are web serv...

Hi,I am using oracle 19c this feature does not work. I am trying to use auto increment feature in a existing table. Naturally i tried altering table for auto increment it doesn't work. The only way appears to be only in create table. We have to do this in prod...

I have just concluded a high level plan to migrate 10g oracle into 19c but will consolidate 2 databases into one standalone. (Non-CDB). In 10g the two database exists on separate host so one is an ARCHIVAL target for PROD...Periodical data export from PROD to ...

I'm currently running a daily backup asRUN { RECOVER COPY OF DATABASE WITH TAG 'IMAGE_COPY' UNTIL TIME 'SYSDATE-7'; BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'IMAGE_COPY' DATABASE; BACKUP DEVICE TYPE DISK TAG 'IMAGE_COPY' ARCHIVELOG ALL NOT BA...

hi tomcan u explain me in detail about "start with connect by" sql statement (tree structure).i know there is documentatin but it is very confusing. ...

hello tom,I hope you don't get angry now, if I "redirect" you to </code> http://asktom.oracle.com/pls/ask/f?p=4950:61:166184132340407832::::P61_ID:442119935770 <code>there is MY MOST important question. TODAY I've got your book - but unfortunately I haven't fo...

Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me ...

Hello,yesterday we recognized that one of our Applications runs very slow. After we did a little bit of researching, we found out that one of our Update-Statements takes significant longer than the day before. After looking into v$sql we saw that the beginning...

Hi Tom, This morning I saw an example on otn describing the sql with clause in 9i. I also saw an example, unfortunately that page seems to have been removed so cannot give you a reference. Here is the question though. How does a select statement with a inlin...

Team,was reading this post - https://blogs.oracle.com/datawarehousing/post/using-the-excel-add-in-to-query-autonomous-databaseand downloaded zip file (oracleplugin.zip) and ran the install.cmd file - but still don't see the My Add-ins in the insert tab from Ex...

Hi Ask Tom Team,Recently I came across MATCH_RECOGNIZE clause. I checked the Oracle documentation but it's not easy to digest.Looking at OLL webinars, youtube videos and some of Ketih's article on oracle blog helped me understanding a little of it.In oracle tr...

Hi Team,i restored database to another server using RMAN backups and Archived logs, database restored fine, my question is i wanted to also restore data of unarchived online redolog files also ? how can i include unarchived online redolog files in recovery pro...

How can we determine the correct number of licenses needed? We are attempting to estimate the licenses need for all our applications. Vertiv uses on premises eBS, and Cloud applications. ...

Hi, when trying to create a local text index on an interval-partitioned table in Oracle DB v19c, we are getting an error.SQL:<code>CREATE INDEX TEXT_INDEX ON BOTS_CONVERSATION_UTTERANCE(UTTERANCE) INDEXTYPE IS CTXSYS.CONTEXT LOCALError report -ORA-29940: User-...

Hi.I'm using Oracle Analytic Views (from 19c) as defined here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.htmlI can create measures with simple aggregations (eg: SUM, COUNT, MIN), but I can't create a measure th...

working with oracle sql and oracle service bus. I have a problem with closing the connection. An example of a simple procedure I use is the following :<code>create or replace procedure getempdata( v_id in number, q out sys_refcursor)asbegin open q for selec...

How can i extract data from flat file to oracle table with plsql ? ...