Questions

Hi,I would like to create initally deferred constraint for FK as below. The problem is, that the constraint cars_service_car_id_fk is validated after DELETE statement, not at the end of transaction(COMMIT). I don't understand this behavior...<code>DROP TABLE c...

I would like my schema to delete rows automatically after a certain number of days.Therefore, I was planning to use this statement for example:<code>ALTER TABLE MY_TABLE USING TTL 5 days</code>However, I'm unable to find specifics in the TTL documentation abou...

Hola! en Apex 23.1Estoy fallando al intentar ejecutar un método GET luego de crear desde Componentes Compartidos >> Orígenes de Datos una conexión a un servicio web http (no seguro) público.El método GET lo pruebo desde la opción de edición. Y lo he probado ta...

I will preface this with not having had tested SQL*Plus scripts on Windows utilizing script arguments in a number of years so I can't categorically state when this stopped working on said platform. That being said, the issue described does not occur on any *n...

I am facing issue of "Pooled connection request timed out" when I upgraded database to 19c and moved the application to cloud(TAS) from VM.There is no fixed scenario when this happens. No code changes has been done except replacing DataAccess.dll to ManagedDat...

Hi ,I am unable to connect to oracle database using SQL DEVELOPER. It gives me" i/o error network adapter could not establish connection". Please let me know what are the possible reasons for it and provide me the solution for the same.- I am using sql develop...

Hi, I have column having data like below. 101010102030402030405060 etcFrom each row above I have to break as below to check whether that number exist in a table or not, if yes skip and if no then insert. E.g. for first row 101010First I have extract two digit ...

How to create a user for eBusiness DB account equivalent to APPS user but only with select and execute on FND, INV and APPLSYS objects?...

Hello Chris/Connor,I am trying to use the option MY_WALLET_DIRECTORY in TNSNAMES file in order to avoid having to specify WALLET_LOCATION in SQLNET.ORA file. However, it fails with ORA-01017: invalid username/password; logon denied error. Tracing the SQLNET (f...

I have the following query:select OPERATION_CODE, to_char(OPERATION_DATE, 'dd/mm/yyyy hh24:mi:ss') as OPERATION_DATE, EMP_CODEfrom HR_ORIGINAL_ATTENDANCEwhere EMP_CODE = 4415and to_char(OPERATION_DATE, 'yyyymmdd') = 20230517order by OPERATION_DATE;And I have t...

Hi Tom,I am trying to extract multiple hostname out from a long strings (In fact, I will use this method for DBLink - host column later). However, my query is only able to extract the first hostname. I did try to put {1,0} after the match pattern '((HOST|HOST...

Does oracle apex 23.1 data load wizard support excel files like the data loader in the SQL Workshop?...

Tom,My basic requirement is like this : I need to take a dump of a schema. But I don't want to export certain tables which are really huge and I don't want them in the dump. Since there is no way to exclude tables in the export command, I created a new sche...

Hi All-I need to create a report that shows number of occurrences of a student being suspended (by 2 different suspension codes) for a range of dates (usually first day of month and last day of month) by school. Here is the starting query, that I use to come u...

HiI have a table with project entry and exit dates for employee.<code>EMPNO PROJECT_NUMBER PROJECT_IN_DATE PROJECT_OUT_DATE001 P1000 15-JAN-23 06-JUN-23001 P1000 30-JUN-23 17-JUL-23</code>Now I have an upcoming project 'P1001' that has the same starting and en...

What do we mean by instance caging in context of oracle database? How it works? Kindly elaborate with examples?...

We have been using an older version of Apex for about 10 years now and now want to set up email capability for sending reports as attachments. I have scoured the internet for the requirements to use but am getting confused with all the different answers. We ne...

JSON Relational Duality views rely on a normalised, uniquely constrained schema to store the data in the 'current view' aka 'the last known state' aka 'snapshot'. In my experience, the vast majority of schemas designed by developers do not conform to this patt...

Dear Sirs,I'm using database version 19c and trying to set a filter on schema level before inserting into UNIFIED_AUDIT_TRAIL view.I tried these example policies but without success:<code>CREATE AUDIT POLICY test1 ACTIONS UPDATE ON <schemaname>.*WHEN 'INSTR(U...

Has the use of user defined snippets been eliminated from the most recent release? Thanks...