152,654 questions
-1
votes
1
answer
21
views
Add a word in special place in string
I have a table contain list of queries and I want to add db link to end of source tables list. For example I have
> Select * from s1.table t1,s2.table2 ,s3.table3;
And I want to convert it to
> ...
0
votes
1
answer
38
views
Is this a vulnerability for Oracle 19c database privilege escalation？
The following test cases and their results were obtained from experiments conducted in Oracle19c。
Experiment 1：
SYS:
CREATE USER AAA IDENTIFIED BY 123456789;
CREATE USER BBB IDENTIFIED BY 123456789;
...
- 11
0
votes
3
answers
38
views
Combine multiple rows into one row based on the repeating order of data attribute
I want to write an Oracle query to convert below table
Attribute Value
product_id P1
product_name AAA
product_id P2
product_name BBB
product_id P3
...
0
votes
1
answer
29
views
How to use recursive function for product transition?
In Oracle SQL, I have a product transition table named kit_transition_mapping that is a slowly changing dimension and an orders table. For an order_no based on the order_date, I need to utilize the ...
- 855
0
votes
2
answers
57
views
How to replace unicode displaying in XML from SQL results
I have the following SQL query that (appears to have some kind of whitespace at the end)is returning data in my XML output and I am trying to remove this upfront in the SQL from being shown in the XML ...
- 364
0
votes
0
answers
15
views
WFLYCTL0180: Services with missing/unavailable dependencies when deploying on jboss
I'm trying to configure a datasource in my application, I'm using jboss abd ojdbc7, and this is the current relevant configuration:
jboss-web.xml
<resource-ref>
<res-ref-name>jdbc/...
- 555
0
votes
0
answers
22
views
Oracle SQL 11gR2 linux spool to xls -> German Umlaute not working
I’m working on an Oracle 11g database (Oracle Database 11.2.0.4.0) with linux sqlplus and I need to export query results to a file that can be opened in Excel. The data includes German umlauts (Ä, Ö, ...
- 1,008
0
votes
1
answer
28
views
Reset sequence value with a simple SQL statement in Oracle 19c [duplicate]
There is a table TB_LOG which did not have a sequence so far. Sequence SEQ_LOG_ID was added for the id column ID_LOG of that tabele.
Now the proper value must be set so there are no conflicts when new ...
- 373
-1
votes
2
answers
62
views
Using condition inside subquery
I need to extract only min(id) values. But I don't know how to use condition from upper query into inner query. The error is: invalid identifier. This is part of larger view, with many more tables and ...
- 7,155
0
votes
2
answers
39
views
How to input Oracle query statements in Unix shell variables
I am trying to input an Oracle query statement into a variable in a Unix shell.
I want to remove the header of the SQL result value, so I want to include "set heading off" in the QUERY ...
0
votes
1
answer
44
views
SQL aggregate whether table contains a category or type of record
Can anyone think of a better way to structure a SQL query for this problem?
I want to group by account_id and determine whether a type of row exists in the table and just aggregate that to a simple ...
- 1,427
0
votes
1
answer
25
views
Connect SQL Developer to local Oracle DB 19c instance?
It's been a while since I've installed and connected to a fresh installation of Oracle DB 19c, so here goes. I also tried to find a solution on my own, but didn't find anything.
I installed Oracle DB ...
- 3,285
0
votes
3
answers
46
views
DELETE Multiple Duplicate Rows Without Column ID
I have a table that contains 15 duplicate rows (for a total of 30 including originals + duplicates). I have been tasked with writing a script to grab the duplicate records and delete them. My ...
- 395
0
votes
2
answers
31
views
oracle function input with more than one possible type
I am building a function to compare 2 input variables:
CREATE FUNCTION compare_num (first IN NUMBER, second in NUMBER)
RETURN VARCHAR2 AS
BEGIN
-- write compare request into audit log ...
0
votes
0
answers
10
views
Oracle apex importing excel with date column
I have an excel file which correctly imports all data into an apex table except my date type column, that one I have set up with the TO_DATE(col008, 'dd.mm.yyyy') which has before worked in previous ...
- 11