3,983 questions
0
votes
2
answers
45
views
Oracle sql. how to check file existence on remote server
I'm trying to check if a file exists on a remote server, in a Forms 12c program unit.
I tried to use
utl_file.file_exists('\\server\d$\folder\filename.txt')
and also
utl_file.fgetattr('DBFOLDER','...
- 23
0
votes
0
answers
25
views
Tab Back from required fields in Oracle Forms 12c
I´m migrating an application developped in Oracle Forms 6i to Oracle Forms 12c and i have found the following problem. In forms6i you could tab backward from required field but in forms12c you can't.
...
0
votes
2
answers
62
views
conditional where with subquery
I am using conditional where as shown below to make query more dynamic when there are no condition are meet but I am getting below error while when I omit the (SELECT CP.COLUMN1 FROM TABLE2 CP WHERE ...
- 2,622
-1
votes
1
answer
74
views
Replicate data to another DB server in Oracle [closed]
We have an Oracle DB running for a production environment. To not effect online processes we keep the data limited in this. Like one year. There is a job running everyday to delete older entries.
We ...
- 29
0
votes
2
answers
88
views
Issue with INSERT ALL SQL statement Oracle
I got an issue with INSERT ALL statement for the below table and this table has a Before Insert trigger which automatically populates the date when the ID_NO column is populated.
CREATE TABLE TestA
(
...
0
votes
0
answers
51
views
ODI studio command line interface to import ODI xml scenario file and execute. How to do it?
I have ODI Studio installed and the ODI agent configured. We have a test environment where an ODI XML scenario has been exported. Now, we need to import and execute the same exported XML scenario in ...
- 11
2
votes
1
answer
209
views
How to prevent temporary table operations from generating archive logs in Oracle Database?
In my application, we dynamically create tables to store session-specific information. These tables are created at the beginning of an active session and dropped once the session is closed. Recently, ...
- 397
0
votes
1
answer
155
views
Grant rights to create tables in a particular Oracle schema
What is the correct procedure for allowing team members to develop applications and create tables in only a specific schema?
I am running Oracle 12C. If I create a schema - say MYAPP1 - how should I ...
- 698
-3
votes
2
answers
54
views
Adjust the date as working date | Oracle |
I was reviewing several articles on Stack Overflow and came across a query that worked as expected. However, I need to make some modifications to tailor it to my specific requirements.
I need to ...
0
votes
1
answer
39
views
Get 12 month running total for subgroups in Oracle
I'm trying to get a running 12 month total for data, but changing when values in my fields change. I've made a simpler sql fiddle, for a 3 month running total, for one value in the table. I'm stuck ...
- 7,996
2
votes
1
answer
52
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. ...
- 63
0
votes
0
answers
42
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....
1
vote
0
answers
34
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 ...
- 145
0
votes
1
answer
77
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 ...
- 953
-1
votes
1
answer
77
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 ...
- 9,600
0
votes
1
answer
123
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 ...
- 23
1
vote
2
answers
80
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,595
1
vote
1
answer
379
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 ...
- 63
0
votes
1
answer
424
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, ...
- 945
0
votes
2
answers
4k
views
Oracle 12c impdp ORA-12154: TNS:could not resolve the connect identifier specified
I'm new with Oracle and I'm just trying to import a dump file. I'm able to create my container database, however when I go to run impdp gy/gy@mygy file=C:\app\impdir\EL1.DMP I am getting ORA-12154.
...
- 57
0
votes
1
answer
67
views
Oracle SQL - search for entries inside the same month but with different start/end dates [duplicate]
I want to query for all entries in the table 'unique_delivery_locations' where 'transaction_identifier' is the same, and we are within the same month. The only difference should be in '...
- 77
0
votes
0
answers
161
views
Materialized view with REFRESH ON COMMIT is not working in ORACLE 19
I am trying to create materialized views and materialized view log but the materialized views are not getting refreshed even after the use of REFRESH ON COMMIT in ORACLE 19. The same code for the ...
- 1
0
votes
1
answer
248
views
sqlplus 19c varchar2 formatting different fromk 12c
We are updating our database from 12c to 19c and ovviously the Oracle client.
We do have some jobs which are reporting from sqlplus. We noticed that the varchar2 fields are formatted differently in ...
- 340
0
votes
0
answers
525
views
Unable to find listener.ora in oracle 12c
There is a default oracle 12c installation done in RHEL 7.5.
This is a single instance database.
When i issue lsnrctl status command i am able to see below output.
LSNRCTL for Linux: Version 12.2.0.1....
- 81
0
votes
0
answers
66
views
Import data from old Jira version with HSQL DB to higher Jira version Oracle 12c
I am a beginner and in my company currently using Jira version 7.11.0 configured with oracle 12.1.0.1 database, Windows and it have some new data with it.
My task to import the old data from ...
