Oracle is a relational DBMS (Database Management System) created by Oracle Corporation.
0
votes
0answers
21 views
Compare Oracle Table with Sql Server Table and Update/Insert
Below is the current code wish used to update/insert records from Oracle view to Sql server table using Dapper. there is not field to check last record updated date in the oracle view so I have added ...
-2
votes
1answer
37 views
Oracle to MS SQL Server 2008 Code Conversion Problems [closed]
CREATE OR REPLACE FUNCTION CHI_X2 (a1 in number, b1 in number, a2 in number, b2 in number)
RETURN NUMBER IS
DECLARE @tr1 INT;
DECLARE @tr2 INT;
DECLARE @tc1 INT;
...
0
votes
2answers
66 views
Efficient way to remove duplicate records
Is there more efficient way remove duplicate records?
strsql := 'delete from ' || TableName || ' a
where rowid <
(
select max(rowid) from ' || TableName || ' b
where a.val=b.val
)';
3
votes
1answer
47 views
How can I make my XML schema robust?
I am attempting to develop an XML schema (XSD) to represent a set of unit tests for some code. (Specifically, I am testing Oracle PL/SQL stored procedures.)
I would like to have something that ...
2
votes
1answer
104 views
Self Join Exercise. Have I over-complicated it?
This my 3rd question on the same exercise, but by no means a duplicate. The two previous questions were posted on StackOverflow here and here.
Now I'm posting my Oracle solution (below) that works. ...
1
vote
1answer
266 views
Need to improve performance while merge CSV data into database drastically. What to do?
Kindly consider below scenario,
Base Functionality
Reading CSV file and insert in database after replacing values with web macro.
Reading values from csv @ first header information NO,NAME next to ...
0
votes
1answer
113 views
Simplify Oracle SQL Unions
I have the following SQL query I am trying to use (save/make easy future modifications to) that is essentially the same query over and over and over, UNIONed each time, with only minor changes to the ...
1
vote
2answers
196 views
How to optimize this SQL delete
I want to optimize the performance of this SQL query. If I populate this hashtable with one million keys the query will take around minute. How I can optimize this Java method for faster execution?
...
0
votes
1answer
103 views
Oracle Simple Stored Procedure issue [closed]
I have been having trouble compiling this SP:
CREATE OR REPLACE PROCEDURE CONTACT_CLEANUP()
IS
BEGIN
DELETE FROM CONTACT WHERE SEQID IN (SELECT SEQID FROM PURGE_CONTACT);
DELETE FROM DETAIL WHERE ...
3
votes
1answer
199 views
Parsing Oracle errors with a ksh function
Some time ago I wrote a small routine to run some quick n' dirty queries (and with that I mean it is not used for large queries) against an Oracle DB, but also wanted to do it a bit easier to parse ...
2
votes
1answer
115 views
Slow Oracle to MSSQL migration
I wrote a method that gathers data from an Oracle server, formats and encrypts the data then inserts it into a MS SQL server. The method moves about 60000 records and takes a bit long and is a little ...
3
votes
2answers
418 views
Oracle PL/SQL decryption function breaking index?
I have a package called pkg_crypto.
My select looks like this:
SELECT "SEQ", pkg_crypto.decrypt("NAME", 'secret') name, pkg_crypto.decrypt("TEL", 'secret') tel
FROM MYTABLE
ORDER BY "SEQ" DESC
...
1
vote
2answers
1k views
SQL query for adding column value to compare with other column
I have two tables
table_inventory
List item
inventory_rack_key(primarykey)
node_key
rack_id
inventory_item_key
in_coming_qty,locked_qty
quantity
table_item
...
