Questions

I did exact thing as per this link https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connectionsBut I am always getting the below error.ORA-28864: SSL connection closed gracefullyI am using free version of 21C database...

I am trying to subtract 6 months from the current date (SYSDATE). I know about the ADD_MONTH function, but I haven't been able to find documentation about a "SUBTRACT_FUNCTION" which can do this for me. ...

Hi TomI am executing a query that fetches from a cursor first then does an insert based on the number of matching records as followsCREATE OR REPLACE PROCEDURE test ASDt date;DelID Integer;LocID Integer;CURSOR c1 IS select po_id, po_dt, to_nu...

We are using APEX 22.2.0.I have an interactive report on a page. I have added a logo to the page. I want the logo to display on the report when the user selects the "Download" option from the Actions menu. How can I get the logo to download with the rest of...

Hi First time asking a question here, I have tried to follow the guidelines, apologies for any errors on my part.Any help you can give will be gratefully received, even if it's just to point me in the right direction rather than an answerFirst a bit of contex...

is there any way to add DLL files contains .net functions (c# language) and use them in oracle apex application...

Hi Team,I have one query which quite complex and join multiple tables. Its Insert into table a(Select /*+ parallel(S,8) */ column A,column B from Table a,Table b {Business logic})Now the issue is, when this query is running, I could see there are 17 entries in...

Hello,I have a problem validating xml file.The link where is all XSD files and xml file to validate is here: https://www.vmi.lt/cms/documents/10162/6703244/SPECIFIKACIJA_MAI_55.zip/c86d3e1d-b081-47d6-a9a1-b021f6dcc85cI've registered schema and checked in Orac...

Hi Team,Wish you a happy new Year. Welcome to Maria Colgan.I have a requirement to change the datatype of a column of number type to Varchar2(35) and then rename the table. The table has huge data around 20 millions. Since already data is there in the table I ...

Hi Team,We have many tables (master tables) having primary and foreign key relationships. These tables (normalized) contain static data (master data).Inserting data manually in these tables is a tedious task because if we insert data out of order then we are b...

I have a table with two columns START_DATE and END_DATE and they have a data type of : Timestamp with timezone.and i have also a Globale Item that get the timezone of the user, and i should use it to convert the timezone of the column in the database to the ti...

Using loadjava to upload a Java source results in:<code>ORA-29547: Java system class not available: oracle/aurora/rdbms/CompilerORA-06512: at line 1</code>This usually indicates that you either have not installed the Java Virtual machine or you did not properl...

We have a table with a blob column that stores the blob of various files like PDF, TIF, WORD, etc and the blob field has Oracle text index INDEXTYPE IS CTXSYS.CONTEXT for us to be able to search for text within the blob’s. We are seeing that the search query u...

Hi Tom,I have a text column with clob datatype. (Below is how data looks in the column).I want to have only the customer input information in the column and remove all private notes.Text Example:Customer Input 04.12.2022 here is sentence 1 ||Private Notes This...

<i>Oracle Database SQL Language Reference</i> states, "Each NUMBER value requires from 1 to 22 bytes." I was curious how much space a NUMBER(10, 0) would take, so I did:<code>SQL> create table t (a number(10, 0)) 2 /Table created.SQL> select column_name, dat...

Hello Tom,If we have table partition, then why do we need Index partitioning? Is this something ultra faster execution of the query? And in what context we can choose local and global partitioning in OLTP database with examples. Thanks in advance....

Is there a utility that helps us migrate the data from mySQL database to Oracle 8.1.6 database?Also, is there a strategy one has to follow for migrating from one database to another? ...

We want to use the Data Loading functionality of APEX to upload a specific tab of an Excel sheet.We only found out it the Data Loading function only imports the first tab of the Excel sheet.We want to upload the second one of the Excel sheet.What are we missin...

I tried to use UTL_HTTP with generated pdf from query report which is made using rtf file( BI pupplisher), I created page to disply the report, and use the page url to add xml script to the pdf file, but i always receive error message <code>(ORA-29273: HTTP re...

Hi Tom,Hope you had a good timeoff and not sure whether this is a silly question to ask. I did try searching on the Oracle forum but did not get any conclusive details on the wait option to be set as true or false while stopping the Oracle queue.We have a issu...