Questions tagged [oracle11g]

Oracle is an Object-relational Database Management System (ORDBMS) created by Oracle Corporation. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c, where "i", "g" and "c" stand for "internet", "grid" and "cloud" respectively. Generally there are two releases within each major version. Questions tagged [oracle11g] are assumed to be specific to this version or features introduced in this version.

0
votes
0answers
14 views

The proper way to monitor DML and DDL changes to specified tables, schemas or entire oracle database

I am finding a resolution to monitor DML and DDL changes made to specified Oracle schemas or tables dynamically, which meaning that schemas and tables monitored can be changed in application run time. ...
0
votes
0answers
10 views

adding running total using rollup and assign '1' having maximum total group-wise, likewise, assign '2' for 2nd maximum total group-wise

adding running total using "rollup" and assign '1' having maximum total group-wise, likewise, assign '2' for 2nd maximum total group-wise Lets suppose, depositor will have multiple types of ...
-2
votes
0answers
14 views

oracle database shared between multiple threads (java)

My database is shared between multiple threads reading and writing data simultaneously which sometime cause exception like sqlException:Connect closed some time this happened during a thread writing a ...
2
votes
1answer
46 views

SQL INNER JOIN Keyword . I am curently practising sql inner join (first time)

I am practising sql inner join from the https://www.w3schools.com/sql/sql_join_inner.asp INNER JOIN Syntax SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2....
0
votes
2answers
55 views

invalid identifier with sub query

i want to access st.Gr_number column in Subquery but it gives me error ORA-00904: "ST"."GR_NUMBER": invalid identifier Select st.Gr_number, st.STUDENT_ID, st.course, st.Student_Name,cr....
0
votes
1answer
21 views

In a junction table, if I need a singular unique identifier and a separate unique composite identifier, which should be the primary key?

My junction table requires a unique singular identifier as well as another separate unique composite identifier made of foreign keys to two tables with a many-to-many relationship. Other questions ...
0
votes
3answers
26 views

Remove word from string in oracle query

I have values in table like (a,b,c,d,e) and I want to remove any value as mentioned below. suppose I want to remove b then comma(,) should move i.e (a,c,d,e). Please help.
1
vote
1answer
43 views

Group by on Month in Oracle

I want group by the result data of oracle database. And also I got the result but the result is groupped as month start to next month start. I need group by from month start to month end. "GROUP BY ...
0
votes
0answers
15 views

Consume Web Service from oracle

I have ORACLE 11g Express Edition Release 11.2.0.2.0 and I am trying to consume a SOAP Web Service from oracle with the following code CREATE OR REPLACE FUNCTION WS (DATAI NUMBER) RETURN VARCHAR2 ...
0
votes
2answers
48 views

How to create a map having multiple values mapped to same key out of List<Map<String,Object>?

I have a data extracted in a List of Map which has multiple values associated to same key. Now I need to extract key value pairs from dbvalues(which is a list of map) and put it into Map> But how ...
1
vote
0answers
35 views

How to connect host database and remote database for replication? ORA-04052; ORA-00604; ORA-12154; ORA-06512

I am currently trying to make a multi-master replication in Oracle Database 11g between the database AR421 on my host computer (Win10x64) and the database STUD421 on my guest (Win7x86 virtual machine),...
0
votes
1answer
26 views

Oracle SQL Auto-updating Table From a Different Database

I have two tables from different database, db1.names and db2.names_rep. db1.names is constantly getting new data and I need it to reflect in db2.names_rep. I've created a dblink connecting for db1 in ...
0
votes
1answer
23 views

Can't create index, LOCK on materialized view

I created a materialized view in Oracle. I used logs to enable/use fast refresh. Main table contains ~12 billion entries, joining table ~8 million. Materialized view contains 366 million entries. ...
1
vote
2answers
48 views

How to manage concurrent access in an sql procedure

I have create an sql procedure in my oracle database that I will call later on on my c# code, the main goal of this procedure is to loop over entries and make some treatment in a condition that every ...
-1
votes
2answers
37 views

ORA-01722: invalid number in Case statement

Hi I am new to oracle database.In the query below,ZERO_BAL_CODE is varchar2 datatype. I tried to write a case statement, but its throwing an error stating that "ORA-01722: invalid number". Help me to ...
0
votes
0answers
32 views

Why Oracle is duplicating a single insert

I have created a windows service which is parsing some files, for each file processed I am logging it into Oracle database but whenever I insert a single record it duplicates it in the DB, below is ...
-4
votes
0answers
25 views

Is there any way to fetch 5 lakhs rows quickly by joining few big tables? [closed]

My SQL fetching first 500 rows in 158.05 Seconds. Actually that SQL will return 5 lakhs rows (this is one month record). But after 500 rows its taking too much of time. I have listed below the ...
-2
votes
0answers
16 views

ORACLE SQL Date - time range intersections

I have two tables: Table1 NAME | START_TIME | END_TIME 1 | 20190102 05:00:00 | 20190102 08:00:00 1 | 20190102 08:00:00 | 20190102 17:00:00 1 | 20190102 17:00:...
0
votes
2answers
34 views

Query Tuning in stored procedure

I need to tune this below query mentioned to avoid Union with the archive table every time because the below query might be unnecessarily scanning the Archive table even if in most of the cases the ...
0
votes
1answer
35 views

Is there any method to truncate date, so that it remains using index by date

I have a huge table that has index by date. By using the index I am getting data, no problem. But I have to trunc(date) to month, so that it includes whole month, by doing this I am losing access by ...
0
votes
0answers
41 views

Excel - Invalid Date cast (year before 1900)

I need to export data into Excel, but unfortunally from Oracle table where inserts happen via Web apps. There are many typo mistakes created by end users (probably bad app designs), and most common ...
0
votes
3answers
48 views

Oracle SQL%ROWCOUNT statement always return 1

I have a simple table USERS in Oracle with 2 columns ID and USERNAME. ID is the primary key and auto incremented using a trigger. I am inserting or updating records using a procedure like this ...
1
vote
1answer
25 views

Sequence of When-Button-Pressed Button Oracle Forms

I have "UPLOAD" Button on Oracle Forms in which when user press the button then: If "Text Item" Field NOT NULL Then -- Run Upload Procedure From "CSV" File to Oracle Forms -- Save Data From Oracle ...
1
vote
2answers
36 views

Find difference between group of fields if the value of group 1 is higher than value of group 2

I have a table "Components" with the following fields Person ID Date_from CompType Value 000001 01/01/2003 A1 100 000001 01/01/2003 B1 200 ...
0
votes
0answers
26 views

Cant connect to Oracle DB

Okay, I am trying to practice some commands in Oracle but I just connect before it, SQL has a mistake ORA-12557: TNS:protocol adapter not loadable and I literally don't know how to solve this. Its ...
1
vote
2answers
35 views

Error logging with MERGE query in Oracle 11

I am using Oracle 11 and I have millions of records in my table. I am using a MERGE statement to update records from source table to target table. At any moment while updating these millions of ...
2
votes
1answer
51 views

PL/SQL Count pages from pdf blob

I have a situation in which I have a blob file whose type is .PDF and I need to count the pages in the PDF. Is there a way to do it without any external (3rd party) libraries? I know that there is PL/...
0
votes
0answers
21 views

Splitting lines (orders) EBS Oracle

I've been trying without success to obtain all the different lines that were created from the original line and the DATE I mean, an order line can be manually splitted into two or more lines. So, i ...
0
votes
0answers
38 views

Unable to identify why duplicate value is displayed in my query [closed]

I am unable to identify why the duplicate value is still displayed in my query. Please help? WITH temp AS (SELECT DISTINCT a.collection_timestamp, round((a.value / 60),0)APPLY_LAG, round((d.value / ...
0
votes
2answers
30 views

how to find xml query in bi_publisher

I create a data_model in Bi_Publisher and set it to my RTF_template report. the question is : how to find the query in database when I running my report? mean: I want to find the query that Database ...
-2
votes
1answer
16 views

How many session/connections the oracle 11G R2 Express Edition support?

I need to know if the 11G R2 XE has a limitation of session/connections. Like in an office. Can I have 15 people using the same system, at the same time? He can handle or I'll lose performance or some ...
-3
votes
1answer
32 views

How would you explain this SQL code in regards to select 1 from dual where exists

I need to explain this to someone in laymen's terms. How would you summarize this if you were talking to a 5 year old, lets say. I would explain it as: "find and display data that is from this ...
1
vote
2answers
31 views

Unable to use oracle regex to split on a composite Delimiter with pipe

I am trying to split a string which has two composite and nested delimiters: Level 1: ~| Level 2: ^| The problem is that the regex pattern works on a single delimiter like: ~ or | or it also works ...
0
votes
1answer
39 views

Oracle restore dmp to existing database

I wish to restore Oracle database from .dmp file. When I try to import this file it doesn't replace current data. The suggestion on forum is to drop user/schema and then import .dmp. But I don't ...
0
votes
1answer
45 views

Error ORA-29259: end-of-input reached calling utl_http.begin_request

I'm trying to connect to the Royal Mail SOAP API but can't get past the the begin request stage. Certificates have been added to the wallet, it works fine for DPD and other Web APIs. DECLARE ...
1
vote
1answer
45 views

human readable URLs in Oracle APEX

how to make human readable URLs in oracle apex currently my url seems like https://example.com/apex/f?p=107:1:13482402024834::::: what i want my database application url looks like. https://example....
0
votes
2answers
44 views

Oracle 11g PLSQL collections in SELECT statement

I have a collection of type table in PLSQL begin block and I had to use it multiple time in my code. I there any way to use the list (table type) in SELECT statement? My goal is to write less code. ...
0
votes
2answers
24 views

How to add counter on Button Oracle Forms

I create a new form in which user select "CSV" File then upload "CSV" data into oracle forms. I want when user press the "UPLOAD" Button then show count on Button Like "UPLOAD [1]". After upload data ...
0
votes
0answers
31 views

Pivoting the output

I'm having a trouble developing a query in which i have to join the output or two different queries and pivot or transpose the table. Is it possible to make the query dynamic as the data in the table ...
1
vote
1answer
24 views

Refreshing Oracle database tables after initial copy is made

I have a production and development database (on different systems of course). Many months ago, I copied the production database to the development system. I used exp/imp at the time. Since then ...
0
votes
1answer
14 views

Exec oracle.ucm.fa_client_ .jar in python

i want run in python and save response in var ,this is : result=java -classpath "oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client.SearchTool -url=https://egjl.fs.us6.oraclecloud.com/_dav/cs/idcplg ...
2
votes
4answers
79 views
+100

When establishing access to data on a remote database, are views or synonyms preferred?

Consider a scenario where you have two databases: On database A you need to access data on database B. You could create a view on database A that selects from the table on database B. CREATE OR ...
0
votes
0answers
25 views

get in-depth hash-join info via sql (not trace files) e.g. # of passes, hash_area_size

I would be interested how much information about hash-joins can be retrieved without looking into trace files via event 10104. This is mainly about 11g, but I'd also be interested in case it works in ...
0
votes
1answer
33 views

No records found in AND Condition Oracle Sql Query

I have query in which I select records with data validation on table with AND Condition but only 1 Condition have no records so that it returns 0 rows. How to avoid this condition. Query: SELECT a....
0
votes
0answers
7 views

Connecting log4php to Oracle database

I am trying to use the log4php module to log errors to database. I have successfully got the module to log to file so I know it's working. However configuring it to send to the database is harder for ...
0
votes
1answer
25 views

Oracle SQL Developer - Using Variables in Insert/Select

Using Oracle SQL Developer. I have the following sample working: DECLARE v_next_TransId INTEGER; -- declare BEGIN select (max(Transaction_ID)+1) into v_next_TransId from xxpos....
1
vote
2answers
15 views

What is the SQL Server equivalent of EXECUTE IMMEDIATE INTO in Oracle

What is the SQL Server equivalent of EXECUTE IMMEDIATE INTO in Oracle? E.g. DECLARE QRY varchar(100); val int; BEGIN QRY:='select count(*) from production.product'; **EXECUTE IMMEDIATE** QRY **...
0
votes
2answers
26 views

How to implement SQL Query into Procedure Oracle Forms

I created query to check validation data on table then insert into table. I want apply this query into Procedure Program unit Oracle Forms. I am a beginner and don't know how to implement this query ...
0
votes
1answer
18 views

Portable JPA 2.0 select current date/time/timestamp

Is it possible to make portable JPA 2.0 query that select current date/time/timestamp using JPA reserved keywords CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP? I know this works in Oracle 11g: &...
0
votes
2answers
25 views

ORA-01857: not a valid time zone

I am trying to convert from UTC time zone to GMT time zone. I ran this below query and getting ORA error. select NEW_TIME(SYSDATE, 'UTC', 'GMT') from dual; And error is Error starting at line : ...

http://mssss.yulina-kosm.ru