Dear friends,I try to export csv from a patitoned table ( 300GB ) it takes 3 hours (only one table), using following code<code>set term offset feed offset colsep '|'set echo offset feedback offset linesize 1000set pagesize 0set trimspool onSET TERMOUT OFFspoo... | 54 seconds ago | 3 days ago |
Hi,I have a use case in which I want the end user to upload files from UI and it will directly store into the application's static files section. Are there any APIs available?Thanks,Tushar... | 3 minutes ago | 3 days ago |
Hi Connor/Chris,I am struggling to reason about the case attached in the liveSQL session.P1 spec ('get_field_value' just returns the value of 'field' from the record given)<code>CREATE OR REPLACE PACKAGE p1 AS field_default CONSTANT varchar2(4)... | 20 minutes ago | 3 days ago |
I'm trying to use march_recognize() to find purchases made for each customer for 10+ consecutive days.A day being the next calendar date. For example, if customer 1 made 2 purchases on 10-MAY-2024 at 1300 hours and 1400 hours this would not be 2 consecutive da... | 2 days ago | 3 days ago |
How can I convince my developers there is a better way to do this?SELECT MAX (weight) weight FROM client.pet_weight WHERE pet_id = :pet_id AND setup_date = (SELECT MAX (setup_date) ... | 2 days ago | 21 years ago |
<code>CREATE TABLE dept (dept_id NUMBER, dept_name VARCHAR2(50 CHAR), emp_count NUMBER);CREATE TABLE emp (emp_id NUMBER, emp_name VARCHAR2(50 CHAR), dept_id NUMBER);CREATE VIEW vw_dept_empcountASSELECT d.dept_id, d.dept_name, d.emp_count AS d_emp... | 2 days ago | 12 days ago |
I have a table like below.<code>create table t2 ( id varchar2(1),val number) ;insert into t2 values ('a',1);insert into t2 values ('a',2);insert into t2 values ('a',3);insert into t2 values ('a',4);insert into t2 values ('b',1);insert into t2 values ('b',2);in... | 3 days ago | 4.9 years ago |
I have been wondering for a long time why a select like "SELECT COUNT(*) INTO l_count FROM foo WHERE c_now >= ts + 1" in the following example issues a PLW-07204 warning but for example "SELECT COUNT(*) INTO l_count FROM foo WHERE ts < c_now - 1" does not.<cod... | 3 days ago | 12 days ago |
I have done a little searching, and not found anything that speaks to this, thought I would ask the experts:Recently I had to build an SQL script to be run in SQLPlus, and this script invoked another with the @ usage, and passed in a derived value as an argume... | 4 days ago | 7.1 years ago |
We have many files available in our Linux mount point and wanted to load them into the table. The solution I'm seeking is to load all the files(with no-header, a different set of columns in each file, comma separated and new line char is available).<b>Sample f... | 5 days ago | 12 days ago |
Hi - we are doing some data conversion of our database associated with a vendor product. This means migrating from one version of the vendor schema to another. so remapping the data. During a performance run, one of the SQLs was taking longer to run. So I ran ... | 5 days ago | 7.1 years ago |
We requested oracle apex work space area 100MB?It exceeds the over 90% size? How to calculate Current file Utilization and current database size?Requested Size: 100(in MB)Current File Utilization: 6.49(in MB) What is this?Current Database Size: 91.... | 5 days ago | 7.9 years ago |
We are going to MOVE the TBS of AUD$ table in PROD. Purpose:AUD$ table is totally fragmented and the CLEANUP / PURGE runs very slow - even with max 1.000.000 batch size but as per test in our test environment we had some issues regarding using API (DBMS_AUDIT_... | 5 days ago | 7 weeks ago |
According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed.Could you please just confirm that 11.2 -> 12.2 is really possible?If so, what about 11.2 -> 19.x ?Or 12.2 -... | 5 days ago | 4 weeks ago |
It took me 25 years to get used to Oracle using 1-based indexing in pretty much all API's.How the rather new json_array_t data structure used a 0-based indexing and drives me crazy.Is there any reason behind this "strange anomaly" or did someone just want to d... | 11 days ago | 12 days ago |
Got information from your archives, BUT solution is not provided or there's no solution???Archive : "Why the trigger disappears... May 28, 2003 Reviewer: Kamal Kishore from New Jersey, USA "Hi Tom,After you re-create the view definition using CREATE OR REPL... | 12 days ago | 20.3 years ago |
Hi Tom,We run a multi-user OLTP system on Exadata Quarter Rack (Linux version). Though the system response time is consistent and is performing well. We observed Run queues with CPU utilization at 70% on both the nodes. What could be the reason?My understandin... | 12 days ago | 12.3 years ago |
Hi Tom , I need to write a query which will give me a list of dates between two date ranges (start date and end date) . For Example if my start date is 12/01/2003 and end Date is 12/31/2003. i need to generate my output as Date----12/01/200312/02/200312/03/200... | 12 days ago | 20.4 years ago |
I am looking for read consistency across multiple cursors in a packaged procedure. In the past I have opened the cursors that I wanted to be consistent at the start of the procedure, used them, and closed them at the end. I am starting to think that the time... | 12 days ago | 21.3 years ago |
Here is my challenge. I am developing an application that receives webhook notifications when events occur. I have successfully used the restful services functionality in Apex (SQL Workshop>Restful Services) to retrieve data at the first (root?) level succes... | 12 days ago | 2 months ago |