| |
4998 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 23 March 2023 14:11 «»
By: mathguy
Re: xml converting task
…mistakes or inefficient things are hiding here.
In the first subquery in the WITH clause I created four different documents, to test that the style sheet works as expected on special cases (for example, on an empty container, or on one where some of …
|
| 2 |
Forum: Performance Tuning «»
Posted on: Fri, 04 December 2009 19:18 «»
By: BlackSwan
SQL statement tuning
…use formatting tags:[code] Enter your code here.[/code]It makes a huge difference to the forum readers. Unreadable code makes a question harder to understand and will delay answers. A lot of people don't spend that much time on the forum and unclear posts…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 13 February 2025 04:06 «»
By: cookiemonster
Re: sql performance (merged)
…Here's a simplified version of what you're doing:
UPDATE STAGING STG
SET (STG.STATUS,
STG.DATE_EXTRACT,
<other cols>) = (SELECT 3,
&…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 03 April 2024 08:58 «»
By: Barbara Boehmer
Re: Implement Profile, PW Policy & Roles
…sion;
Please run that and post the result here.
I imagine that a school may have the newest version 23c that has newer features than most of us here have on our computers.
For example, in 23c, you can now grant privileges on an entire user/schema…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 22 February 2024 04:06 «»
By: emadnabil
RETUNR FUNCTION USING "TYPE"
…the function into a form
but it fails
here is the type creation
create or replace type limitS as object
( lIMIT1 NUMBER,
LIMIT2 NUMBER,
LIMIT3 NUMBER…
|
| 6 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 September 2023 14:22 «»
By: mathguy
Re: Jaro-Winkler similarity for 9i
…what it's worth, here is my implementation of the Jaro-Winkler similarity function.
UTL_MATCH has a "Jaro-Winkler" function and a "Jaro-Winkler similarity" function. The latter takes the return value from the former, it multiplies …
|
| 7 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 13:16 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…ng. Why did I need to do that?
Here is my thinking.
I dropped the table, and thus the index was dropped.
I also dropped the preference: KJC_TEST_INDEX_2_NETWORK_PREF
and then recreated.
I then recreated the index using …
|
| 8 |
Forum: Server Administration «»
Posted on: Thu, 13 April 2023 06:25 «»
By: Andrey_R
No SCN in controlfile after BACKUP TO TRACE
…and did not find any SCN information.
Here is the command I used to do the backup with RMAN
RMAN> alter database backup controlfile to trace as 'F:\ORACLE_BACKUP\\controlfile.txt';
using target database control file instead of recovery …
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 14 April 2022 08:37 «»
By: dragam
Is there a better way to do this in Oracle - Generate series with other entries
…ALL
SELECT name, x + 1 FROM cte
WHERE x <
(SELECT MAX(hpt) FROM total_hours_played
WHERE name = (SELECT name FROM total_hours_played WHERE name = cte.name))
)
SELECT * FROM cte
ORDER BY name, x;
See the link here (Oracle) and …
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 15 January 2002 01:44 «»
By: pratap kumar tripathy
Re: How I get the Tables' source(sample)
…in third-party tool like 'TOAD'
here is an example how to get table defination(remember it does not say about constraint,index etc.)
set pages 0
set heading off
col ord noprint
col table_name noprint
col col_name format a120
SELECT TABLE_NAME,…
|
| 11 |
Forum: Community Hangout «»
Posted on: Sun, 06 October 2024 12:07 «»
By: Barbara Boehmer
TEXT MESSAGES AND BROWSER SESSIONS AND VERIFICATION NUMBERS
…on the link again, but instead of being where I left off, I have to start over and it sends a new verification code in another text message, so I am in an endless loop.
The above is general info. Here are the details. Last night I realized …
|
| 12 |
Forum: Community Hangout «»
Posted on: Tue, 21 May 2024 13:30 «»
By: Littlefoot
Re: MICROWAVE WOES
…wouldn't know what to do ... as you said, there's no phone number you could call and talk to a person. Various providers offer chat bots. I checked a few of them here, in Croatia - they call it a "digital technician" or "virtual assistant&…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 28 February 2024 14:50 «»
By: Duane
Re: BLOB Column with Zip File Convert to CLOB
…Ok, need some help here.
I'm sure I'm doing something stupid but I can't see to figure it out. I'm sure someone here can spot what I'm doing wrong.
Problem:
I have a ZIP File that includes 5 file names (multiple-files-1.csv, multiple-files-…
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 17 December 2023 20:26 «»
By: Barbara Boehmer
Re: Problem in pivot query
…in your query that is not being posted here. You need to post a copy and paste of an actual complete run as I have done below, including the view creation, including line numbers, and including the complete error message. I have included an …
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 07 November 2023 00:21 «»
By: mathguy
Re: Recursive subquery factoring
…illustration - here is a single query against the base table, computing at the same time the PATH_ID_POST as you have it in the view and PATH_ID_POST_D as you requested in your question. If you only need the latter and PATH_ID_POST was just an …
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 05 October 2023 10:31 «»
By: indupriyav_2023
Need a pl/sql block to be entered in existing package
…belonging to 3 different from_date.
Here only if all group belonging to same from_date is 0, it should be removed
Eg:
Mytable
No Group Fromdate todate amount
50126 MAT 01-Oct-23 21-Oct-23 20300
50126 MAT 22-Oct-23 18-…
|
| 17 |
Forum: Text & interMedia «»
Posted on: Wed, 16 August 2023 17:12 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…original problem when I was doing UNCs.
Here is the script.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE KJC_TEST_INDEX_2
(assigned_id VARCHAR2(11),
text_content_url VARCHAR2(…
|
| 18 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 10:57 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…think I am getting closer. Here is what I have so far, but it is failing. I am getting a certificate error. How do I resolve that? See error message at bottom.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE …
|
| 19 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 08:47 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is the script that I ran. I had to change a few things in order to get it to run.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE KJC_TEST_INDEX_2
(assigned_id VARCHAR2(11),
…
|
| 20 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 20:50 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…did not index the document.
Here is the script that I ran:
DELETE FROM KJC_TEST_INDEX_1 WHERE assigned_id = 'MCP-135'
/
INSERT into KJC_TEST_INDEX_1 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.…
|
| 21 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 18:28 «»
By: kjcook
Re: How to determine last tiime Content was indexed
… 5" and it seemed to have worked. Here is the script that I ran:
commit;
--DROP TABLE KJC_TEST_INDEX_1;
CREATE TABLE KJC_TEST_INDEX_1
(assigned_id VARCHAR2(11),
…
|
| 22 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 16:35 «»
By: kjcook
Re: How to determine last tiime Content was indexed
… am still getting the same error message.
Here is the script:
commit;
DROP TABLE KJC_TEST_INDEX;
CREATE TABLE KJC_TEST_INDEX
(assigned_id VARCHAR2(11),
…
|
| 23 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 13:37 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is a little better picture of what I am running.
BEGIN
commit;
BEGIN
EXECUTE IMMEDIATE 'DROP INDEX MI.kjc_test_index_url1 FORCE';
&…
|
| 24 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 04 May 2023 08:13 «»
By: thmdevt
Error ORA-01480: trailing null missing from STR bind value
… the setDataBuffer method.
I cannot find where is the wrong code because I first allocate the rows of the 2D arrays and for each row I allocate the size of the string + 1 (for the null char) and the function std::strcpy normally adds the null char to …
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 27 April 2023 13:49 «»
By: DevMuch
How can I speed this query up?
…Everyone,
First post here and I'm very new to Oracle. I have isolated a query and I am running it in TOAD and viewing the Explain Plan. I THINK this query can be sped up but I don't know how to get it there.
Here is my query...
…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 March 2023 11:20 «»
By: mathguy
Re: Rescheduling installments by distributing amounts
…is a query that I believe does everything you need. Note that your math for ID = 4 is just wrong; the skipped installments have a total amount of 4 * 190,000 = 760,000, spread over the remaining 14 payments, meaning the remaining 14 payments must increase…
|
| 27 |
Forum: General «»
Posted on: Mon, 06 March 2023 18:25 «»
By: mathguy
Puzzle no. 3 - uniform contribution to required quantity
…gold medal for simplicity. In pure math, where the time required to execute some process is irrelevant, this would be the best answer.
In applied math / engineering, once we have a solution (like zozogirl's), we can then ask, how efficient is it - and …
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2023 09:03 «»
By: Joy83
Loop and save the index in an incremental number array
…Var(counter)
When I put it this way I get error.
What is the best way to do it and save 31 values based on the position of the loop
Basically if the counter =1
Var(1)= my value here
If the counter =2
Var(2)= my value here
And so on…
|
| 29 |
Forum: Server Administration «»
Posted on: Sat, 23 July 2022 15:35 «»
By: Andrey_R
Re: Parse statistic values don't seem to add up
…ssions's cache and you re-use the plan from there very easily
What the hack is No Parse then
Is that some kind of PL/SQL static SQL execution that is somehow even more efficient than the "regular" Softer soft parse via SQL engine…
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 June 2022 11:43 «»
By: Michel Cadot
Re: BASIC SYNTAX
…USING clause.
But this is not your case here.
PL/SQL is not built to interact with the client, it is for retrieving data and computation.
The best you can do here is to declare a CURSOR variable and retrieve the result set of the query in this one …
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 June 2022 09:15 «»
By: Dhoback
Re: BASIC SYNTAX
…data. I am trying to follow the example from here: https://sqlskull.com/2020/06/16/sql-server-dynamic-pivot/ but am still coming across syntax errors. Below is my code so far, but when I try to run it in SQL Plus, I get an error right away at the first @ …
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 01 June 2022 04:35 «»
By: Littlefoot
Re: Group by department name, employee
…Hm, only if you said where exactly you added FIRST_NAME so that it caused syntax error ...
For me, it looks OK:
SQL> SELECT d.department_name,
2 LISTAGG (e.last_name || ' ' || e.first_name, CHR (10)) -->…
|
| 33 |
Forum: Reports & Discoverer «»
Posted on: Sun, 22 May 2022 03:00 «»
By: Littlefoot
Re: REP-3335 Error
It's been discussed here here; see if it helps.
|
| 34 |
Forum: Data Guard «»
Posted on: Sun, 01 May 2022 02:28 «»
By: Akmmhto
Re: Random Slow archive Copy to Physical Standby
…ple.
RFS simply copy redo data.
Actually here we are not using DG Broker.
Issue is RFS is doing sometimes faster REDO copy to DR and sometimes very slow.
There is no issue with Thread#1 REDO data copy, Its speed is fine.
But issue is appearing …
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 21 April 2022 14:19 «»
By: buggleboy007
How to append a header on the top of the CSV file
… appended it is appending at the bottom. Is there a way to have it on the 1st line itself. The reason for this having it on 1st line I will then be able to do further validations.
Here is the file (before appending the text):
66032180,1,8/7/2021 11:…
|
| 36 |
Forum: Server Administration «»
Posted on: Fri, 14 February 2025 07:26 «»
By: Frank Naude
Re: Slow DataPump with broken DB Links
Here's a blog post describing the same issue:
https://dbtricks.com/?p=475
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 12 February 2025 14:15 «»
By: Michel Cadot
Re: SQL Help Parsing Column
…
So here's a better one:
SQL> select * from sample_comments;
ID_NUMBER COMMENTS
---------- ------------------------------------------------------------------------------------------
3333333 [222222, 11/21/2024 9:07:17 PM, …
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 12 February 2025 13:59 «»
By: Michel Cadot
Re: SQL Help Parsing Column
…the first (), second ()... in the pattern. Here there is only one such expression, REGEXP_SUBSTR returns this value using the 1 in its last parameter.
This makes me realize that there may be cases that won't work. For instance, if in the last set …
|
| 39 |
Forum: Suggestions & Feedback «»
Posted on: Tue, 04 February 2025 03:08 «»
By: Michel Cadot
Re: Site statistics
Here are the 3 pictures I added (01/01/2025):
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 30 January 2025 13:15 «»
By: Barbara Boehmer
Re: Sorting Versions into rows
…is a PL/SQL option for your consideration.
-- create a table from your rank_versions:
SCOTT@orcl_12.1.0.2.0> CREATE TABLE test_data AS
2 WITH versions AS (SELECT 'A' AS version
3 , …
|
Blog
Search
Help
Members
Register
Login
Home