All Questions
2,764
questions
0
votes
1
answer
32
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
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 = ...
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
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
48
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 ...
0
votes
1
answer
72
views
Pivot statement randomly produces NULL valued columns (Oracle 12c)
I have a query that uses a CTE for pivoting. I run the query without pivoting and the results are always the same.
HOWEVER when I pivot this data from rows to columns (about 15 columns MAX), I keep ...
0
votes
1
answer
74
views
No data source definition was found for data source name: 'StorePrimary'. Oracle Retail Xstore POS Dev Setup
So i have been trying to install Oracle Retail Xstore POS dev Setup on my desktop and couldn't find any solution to this error.
Here is what i get on screen when running it
the stack trace states that
...
1
vote
2
answers
40
views
Oracle catch exception code given at runtime
I want to create an Oracle PLSQL procedure that receives a statement that will be executed and a number representing a possible exception code that can arise and should be handled. I tried something ...
1
vote
1
answer
192
views
Clone schema within same database
I'm using Oracle 12.1. The database I'm talking about is used for build purpose and we need to create db schema which is compatible with the version of code in use.
For example, we have say schema1 ...
1
vote
1
answer
151
views
Oracle PL_SQL set execution timeout
I am using Oracle 12c Enterprise (12.1.0.2.0) and have a package which creates queries using dynamic SQL, according to some rules. The dynamic SQL query is then executed by opening a cursor on it, ...
0
votes
1
answer
175
views
Error while exchanging partition in Oracle ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
I am trying to swap partition PART_201901 from the MAIN_TABLE to the TABLE_HISTORY.
I have created the TABLE_HISTORY using the same script as MAIN_TABLE, literally used the same script, indexes, ...
0
votes
0
answers
80
views
Oracle impdb command throws ORA-12154 error, but sqlplus and sql developer are working properly
I installed oracle 12c freshly in windows computer and created a new database service. It initially was not recognized by the Oracle SQL Developer, but after I reconfigure the default listener Oracle ...
1
vote
0
answers
67
views
Oracle xQuery merge two xml matching nodes
I have Oracle12 and two XML and want to merge them into one preferably using xQuery.
If 2nd XML have new nodes then they must be added.
In addition, if possible, if the node matches then change its ...