Questions tagged [oracle12c]
Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c. Generally there are two releases within each major version. Questions tagged **oracle12c** are assumed to be specific to this version or features introduced in this version.
oracle12c
3,998
questions
2
votes
1
answer
20
views
Oracle hierarchical query joining 2 tables
I have 2 tables: projects and tasks (that's a simplification, but will do for now). PROJECTS has a hierarchy of projects where there can be a detached (standalone) project or a projects hierarchy. ...
0
votes
1
answer
31
views
Converting timestamp to date format in Oracle 12c
I have a below date value stored in a column in a table. I wanted to get the result in dd/mm/yyyy format only.
15-JUL-18 22.04.11.587000000
I am using this format but seems not rendering the correct ...
0
votes
0
answers
13
views
How to create a trusted certificate to run https in oracle 12c db
Need to run a https api in oracle 12c. oracle only supports utl.http request but what we have is an https api what are the solutions for this
tried creating wallet but cannot make it trusted. Please ...
0
votes
0
answers
19
views
Retrieving Images from Oracle 12C into BIP Report
I want to create report in BIP to show me customer images form SIGTEXT column in Oracle 12c, Like Displaying in Oracle front app but when I want to insert image in BIP I face to some error.
SELECT sg....
0
votes
0
answers
19
views
Unable to create the dumpfile during the migration using data pump [duplicate]
I was about to perform database migration from 12c to 19c using Data Pump when i encountered this issue at first step itself.
SQL> expdp directory = export dumpfile = export role.dmp logfile = ...
0
votes
0
answers
23
views
ODI 12c Work Repository: Reusable Mapping Lineage
My team is trying to create a Data Lineage SQL query using the metadata tables from the ODI-12c work repository. The idea is to input a specific column into our query and return all the stages/...
1
vote
0
answers
31
views
Visibility of external tables in CROSS APPLY
It would seem that the value from a row in an external dataset should be visible internally. Working example:
WITH table_1 AS (
SELECT 1 col_id FROM dual UNION ALL
SELECT 2 col_id FROM dual UNION ...
0
votes
2
answers
43
views
Oracle SQL find max number before repeating values start
I am trying to use a query to find the maximum value in a column before repeating values start. I have three columns - year, jobnumber, hourly_rate
After a certain year, which can vary, the rates ...
0
votes
0
answers
19
views
Apache NiFi to Oracle: Null Password
I've trying to set a connection from NiFi to Oracle for an ETL process. Listeners are set in Oracle to accept connections from NiFi's host address. The issue happens when I try to run a query using ...
0
votes
1
answer
58
views
Generate Nested JSON oracle19c using JSON functions
Hi I have below sample query.In real case scenario there are many more columns in each view.
The A view has unique ids and is present in other views. I tried to join all the views and generate JSON ...
0
votes
0
answers
16
views
how to import views into oracle database [duplicate]
I have an Oracle dump, which includes tables and views. While importing into the database, it's accepting only tables, not views.
Imp system/system file=test.dmp full=y log=test.txt
am I missing any ...
1
vote
2
answers
47
views
how to query a different view depending on oracle version
i have 2 queries.The 1st one runs on 11g:
select owner,directory_name,directory_path from dba_directories;
The 2nd one runs on 12c an 19c oracle versions only:
select owner,directory_name,...
0
votes
0
answers
17
views
How to capture Oracle WCC reject email text into a DB table
Currently, in our Oracle WCC Workflow, when a content is rejected, a rejection form comes up [see below] where a rejection reason is entered. That gets sent in an email to the submitter of the content ...
-1
votes
1
answer
61
views
Oracle 12c: How can the LENGTH() of a VARCHAR2 value be more than its size?
Today I SELECTed the LENGTH() of a value in a VARCHAR2(1) column and got "5" even though it sure looks like 1 character to me when I SELECT the column directly in PLSQL Developer (it has the ...
0
votes
0
answers
26
views
How to use CONNECT BY in Oracle with columns that contain strings with forward slashes
I have a table in Oracle 12c Standard Edition Release 12.2.0.1.0 with the following sample data
SECTION
PARENT
CHILD
A
FIRST_ENTRY
STRING1/AA1
A
FIRST_ENTRY
STRING2
A
FIRST_ENTRY
STRING3
A
...