| |
4932 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: 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…
|
| 4 |
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…
|
| 5 |
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 …
|
| 6 |
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 …
|
| 7 |
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 …
|
| 8 |
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 …
|
| 9 |
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,…
|
| 10 |
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&…
|
| 11 |
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-…
|
| 12 |
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 …
|
| 13 |
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 …
|
| 14 |
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-…
|
| 15 |
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(…
|
| 16 |
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 …
|
| 17 |
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),
…
|
| 18 |
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.…
|
| 19 |
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),
…
|
| 20 |
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),
…
|
| 21 |
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';
&…
|
| 22 |
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 …
|
| 23 |
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...
…
|
| 24 |
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…
|
| 25 |
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 …
|
| 26 |
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…
|
| 27 |
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…
|
| 28 |
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 …
|
| 29 |
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 @ …
|
| 30 |
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)) -->…
|
| 31 |
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.
|
| 32 |
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 …
|
| 33 |
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:…
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 24 May 2024 04:10 «»
By: deepakdot
Re: Add Column with default existing column
The new data to the table for the new column , yes , a trigger can help .
Here I am worried for the existing rows for the new column. The tables data is really huge. How can I Add a column with a value from existing column.
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 14 May 2024 11:52 «»
By: Barbara Boehmer
Re: Get the MetaData for FGA Policy
…is an example that gives a little more complete information.
If creating this policy, first you would create the package specification and package body that you get from dba_source.
Then you would create the policy that you get from …
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 22 April 2024 08:19 «»
By: Amine
Re: Getting ancestors in hierarchies
…
not necessarily. Here is an example :
drop table t_hierarchy;
create table t_hierarchy
(
id number ,
id_sup number ,
id_type number
);
insert into t_hierarchy values (1, null, 1);
insert into t_hierarchy values (2, 1, 0);
insert …
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:52 «»
By: Barbara Boehmer
Re: Convert input from user into UPPERCASE
…is another method that works from SQL*Plus:
SCOTT@orcl_12.1.0.2.0> COLUMN muser NEW_VALUE v_user NOPRINT
SCOTT@orcl_12.1.0.2.0> ACCEPT muser CHAR PROMPT 'Give username :'
Give username :Test123
SCOTT@orcl_12.1.0.2.0> SELECT UPPER('&…
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:35 «»
By: Barbara Boehmer
Re: Convert input from user into UPPERCASE
…to the OraFAQ forums. Here is a simplified demonstration of one method;
SCOTT@orcl_12.1.0.2.0> var muser VARCHAR2(10)
SCOTT@orcl_12.1.0.2.0> ACCEPT muser CHAR PROMPT 'Give username :'
Give username :Test123
SCOTT@orcl_12.1.0.2.0> …
|
| 39 |
Forum: Server Utilities «»
Posted on: Fri, 12 April 2024 19:42 «»
By: Barbara Boehmer
Re: impd data only from one table to another table
…is a link with some sample syntaxes for export and import via network_link using expdp and impdp and required privileges:
https://oracle-base.com/articles/10g/oracle-data-pump-10g#NetworkExportsImports
Although it looks like you can import without a…
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 04 April 2024 04:56 «»
By: jansulc
Re: correct treatment of date across different timezones
Oh, great.
Thank you. You replied greatly and so quickly like some 15 years ago, when I asked here something!
This time I even didn't get scolded by Black Swan:)
But anyway - i will use your solution. Thanks again for it.
|
Blog
Search
Help
Members
Register
Login
Home