Skip to Main Content

Questions

QuestionUpdatedAsked

We have an old query that was running fine (though it could use improvements in general) but after having a VPD policy put in place, it started to run long and not complete. The difference between an 1 - 1.5 hours to not completing after running for well over ...
4 hours ago4 days ago

I need to CREATE some test data where I want to CREATE N number of timestamps between 2 times for every 15 minute interval including the start time and less than the end time.N would be defined as dbms_random between a low_number and a high_number.I want to r...
6 hours ago4 days ago

ORA-04063: package body "SYS.DBMS_NETWORK_ACL_ADMIN" has errors, how do I reinstall this package?...
4 days ago7 days ago

Dear Tom,how can I create bind variable in Oracle Live SQL,<code><variable variable_name data_type;>example <variable dusko number;> </code>just doesn't work, i get "Ussuported command" message...Thanks and best regards...
4 days ago4 days ago

Hi.We use to prepare extract file from oracle using extract script. There are few tables whose name gets change every month.Need to handle these table names dynamically.<code>SELECT TICKET_ID ,SOURCE_ID ,SERV_ID ,to_char(COLLECTED_DATE,'YY...
4 days ago5.4 years ago

Hi,I have a table that holds about 2 million records. No column in the table can be used to divide rows equally. Initially when the data is loaded into the table, the bucket_number column is null. After data loaded, I would like to calculate and equally divide...
4 days ago6 days ago

I have a materialised view in my own schema which based on a table in another schema. However I want to modify the matrealise view to add a where clause which will never becomes true e.g. Where 1=2Can i alter an existing materialised view to add this where cl...
5 days ago5 days ago

I have a Docker Container with Oracle Database Entrepise Edition (followed the basic instructions on container-regitry.oracle.com)And i'm trying to create a NodeJs application to connect to the Oracle Database inside the container (tried the "how to basics" on...
5 days ago9 days ago

We currently use triggers on a subset of tables in our transactional database (on-premises) to capture row / column level changes and insert them into a separate table. With the availability of DBMS_CLOUD package for our product version we are exploring the op...
5 days ago6 days ago

Hello, Thanks to this forum a lot of my answers were answered. I noticed that most of the queries in an application that am working on is using the MATERIALIZE hint in the subqueries. Our queries heavily use CTEs and relies on multiple joins. Our query perform...
5 days ago5 days ago

Hello Connor/Chris,Hope you are doing well.Recently, I came to know about the PART_NAME parameter for multiple APIs of DBMS_REDEFINITION package from the documentation. However, I could not find much about what kind of changes are permitted (and prevented) at ...
5 days ago9 days ago

Hi, I would like to know how to read data from rest API. For example, I have a splunk rest endpoint:curl -k -u admin:oracle_4U https://localhost:8089/services/search/v2/jobs/1674187705.76/events --get -d output_mode=jsonSample: (content below is irrelevant, i...
5 days ago9 days ago

I am busy writing code to parse JSON data received in a CLOB via REST request. I successfully parsed all the JSON received except one piece of JSON that gives the error below, and I cannot figure out why as the content is basically the same as the other JSON I...
6 days ago10 days ago

For code and test output, please see LiveSQL Link https://livesql.oracle.com/apex/livesql/s/onh4jsczpzaa2bp9t0r9yfkxhWhen called with: exec test_proc(1000, 1, 5)the output shows 500 vs. 77. Why InDirect Count = 77 calls ? Statement processed. ---------- C...
7 days ago10 days ago

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...
7 days ago11 days ago

We have an application running on Oracle version 12C which has a data guard to sync it with the Disastrous recovery DB running on the same Oracle version 12C. I would like to know if I can use another one more data guard to migrate the data from this DB runnin...
7 days ago10 days ago

Hey Guys,We are attempting to export selective partitions of a table and would like to filter records for each partition. Would you please explain how we can achieve using one parameter file? Below is an example of the parameter file that we are using.For exam...
7 days ago13 days ago

Hi TomIt is my first time, hope You won't be disappointed by my question :)Recently I tried to optimize quite complex query and the problem was witch simple between condition on varchar2 column. When variable was from the beginning of column values range the q...
7 days ago13.8 years ago

Could you explain me about Key-preserved table conceptin join views.i know that a table is ket preserved if every key of the table can also be a key of result of the join.but i not understand meaning of this.Thanks ...
7 days ago22.5 years ago

In the <b>Hierarchical Queries: Databases for Developers</b> first recursion example we run the query for the initial case in the recursive loop:<code> select employee_id, first_name, last_name, manager_id from employees where manager_id is null</code> ...
11 days ago11 days ago