Questions

Hi,Had problems with SQLLive, (500 response), therefore the examples are her.I have a strange behaviour with execute immediate, where it behaves differently from within a PL/SQL procedure than it does when running it standalone.Here is the example:I create a s...

Attempting to learn and make use of JSON data within a table. Stuck on the following and would really appreciate some help...Looking for help to create a list of ITEM_IDs where a match is found in the JSON object. Sample column data - (column: recall_control_j...

I am trying to integrate Microsoft Office365 Outlook's SMTP with Oracle Apex 22.1(Running on Amazon RDS for Oracle 19c). I have used the following configuration on Apex:SMTP server name: smtp.office365.comSMTP port: 587Username: <my-email-id@outlook.com>Passwo...

I"m looking for guidelines on how to architect a new APEX solution for migrating legacyOracle reports to APEX.We have 67 seperate municipal government entitiesin 67 seperate Oracle instances. Some are 12c someare 19c. They are spread across 4 servers.Table str...

Hello,In this query : <code>select id, to_char(txn_date, 'yyyymmdd'), count(*) from table1 where to_char(txn_date, 'yyyymmdd') > '20250101' group by id, to_char(txn_date, 'yyyymmdd') order by to_char(txn_date, 'yyyymmdd');</code>Will t...

from the oracle10g concepts guide"Oracle recommends that unique indexes be created explicitly, and not throughenabling a unique constraint on a table.Alternatively, you can define UNIQUE integrity constraints on the desired columns.Oracle enforces UNIQUE integ...

Hi Team, Hope you are having a great day. I would like to clarify some doubts regarding the oracle certification as well as SQL language. I have decided to take the oracle certification but have a few doubts regarding the exam. Here are the questions. Where sh...

I ran into this problem with 1% of our records converting views from SQL Server to Oracle where my testing found different results when doing a compare during UAT. We have a system that needs to express time rounded to tenths of hours because of industry norms...

Hi Team,Can you please have a look at below:I tried copying table data from One DB to Other over DB link using DBMS_PARALLEL_EXECUTE.And it works as expected.Challenge I am facing here is:I have a table TB_TXN created on both Oracle DB.Now i want to copy speci...

Hi I have a rman full backup and I want to restore single table due to drop that table how can I do this.I can not create a clone due to space and resources issue..Thanks...

With row‑based replication (binlog_format = ROW), the function generates duplicate sequence values; in mixed mode (binlog_format = MIXED), no duplicates occur. Using AWS RDS 8.0.22CREATE DEFINER=abc@% FUNCTION nextval(seq_name varchar(100)) RETURNS bigintBEGIN...

Hello ,Hello, I'm having a rather strange problem:A single Windows user is unable to connect to a database hosted on the WINDOWSPROD server. The error is: ORA-12637: Unable to receive packet; in the alert.log:ORA-00609: Could not attach to incoming connectionO...

Dear Tom, I have a question. I have a profile say myprofile in dba_users view. I'm selecting how many users having this myprofileselect username from dba_users where profile='MYPROFILE';User1User2User3Now I want to check whether all this 3 users have Connect r...

Tom,Could you please explain for which scenario I should consider non-prefix local index over prefix local index?Thank you very much for you time....

Hi Tom, We have 8i db one on the production server and another on the webserver (public access for online service). I have the same table created in both the database. I have a procedure to load the all the images form the file system about (1400) into t...

Tom,Is there a way I can find the first day and last day of a given quarter.In a given year, there are 4 quarters.If I select first quarter then I should be able to get the first day and last day of the first quarterexample: quarter = 1 and year is 2007. expec...

<code>Hi, Tom I wrote the following procedure, there are two PLACEHOLDERs which means two bind variablesand the two PLACEHOLERS have the same name, that is to say ,the name of PLACEHOLDERs are identical,they are both "MYTEST". In the procedure, I assign ...

Hi,I have gone through the TDE column and TDE tablespace encryption. Most cases TDE tablespace option is found to be better compared to TDE column option.Wanted to know what advantage TDE column encryption gives or rather the use cases for TDE column encryptio...

Hi, I have a sequence skip number problem.I have this sequence. The cache is 20 and noorder.<code>create sequence seq_serial_no minvalue 1 maxvalue 999 start with 2 increment by 1 cycle</code>The current situation that has arisen is:I have two servers A and B....

Hello, a few questions:1. All of the scripts I have written years ago use both address and hash_value to join v$session and v$sqlarea.What I don't quite understand is why it's not sufficient to just join on hash_value (or sql_id).Why was/is address also needed...