All Questions
Tagged with oracle-database mysql
2,374 questions
1
vote
1
answer
48
views
How to create or insert data into a table that has no unique values using 2 different tables which also has no unique valus?
I have 3 tables.
Pin Code Master
Pin code temp
City temp
in pin code columns are
entry id - number
picode - number
state - number
district - number
pin code temp is same as master
city temp
entry ...
0
votes
1
answer
39
views
How to Handle Indexes for @MapsId in JPA: Should FK and PK Share the Same Index?
I am using the @MapsId annotation in JPA to map a foreign key (FK) to a primary key (PK). According to the @MapsId annotation, the FK and PK share the same value. However, when I checked the database ...
- 184
0
votes
1
answer
67
views
Problem with catching data from Oracle XE 21c over db link from database MySql 8.0.32
We have problem when we want catch data from Oracle XE 21c over db link from database MySql 8.0.32, when we use where condition on select the results are waiting for a very long time.
For example :
...
0
votes
1
answer
74
views
is the documentation for oracle-sql and mysql the same with respect to the definitions, syntaxes and rules? [closed]
I recently started exploring sql basics in oracle to help myself to work on a migration project where project is subject to migrate from Oracle platform to a different one; while trying to google for ...
- 159
0
votes
0
answers
40
views
How to multiply rows based on condition in sql [duplicate]
I have a table at a customer ID level where I need to group by customer ID and multiply different values in row & column.
Eg:
Id
Qnt
ab1234
20
xy123
30
gh123
10
ID
CAP
MKT
ab1234
1
2
xy123
...
- 35
0
votes
1
answer
145
views
Can anyone provide SQL query to fetch the id, name, release year and budget of the highest budget movies in each year? [duplicate]
Problem Statement:
A table called movie is created with the following DDL command.
create table movie(id int, name varchar(15), releaseyear int, budget int);
Write the SQL query to fetch the id, name, ...
0
votes
1
answer
68
views
Take Data from Main Table else Backup Table
Using a oracle DB.
Table1: Dept
Deptno
Dname
10
HR
20
IT
Table2: Dept_Backup
Deptno
Dname
10
HR
20
IT
Lets say I have a join with emp table and dept table:
(Query Below)
select e.*, d....
- 51
0
votes
3
answers
176
views
Query Performance difference select * or specific columns
If I have a table Application_user with 100 columns, what is the performance difference between two queries:
Query 1:
select * from Application_user;
Query 2:
select a.col1.a.col2,a.col3........ from ...
1
vote
2
answers
79
views
How do I get the desired GROUP BY results for my Oracle DB query?
I've just started working in an Oracle database after years of using MySQL and I'm a little confused about the grouping differences. As a starting point, let's say I have this project table:
id
name
...
-1
votes
1
answer
35
views
Modifying Oracle procedure for MySQL
I am really struggling to modify an Oracle procedure to MySQL, as using cursors in MySQL increases the run time from 2 minutes to 6 hours!!
Here is my Oracle Master Procedure which calls other ...
0
votes
0
answers
30
views
joining two tables while one column has multiple values [duplicate]
table 1 - employee
id empname
--------------
1 Andy
2 Brady
3 Khalid
table 2 - clients
id name empid
----------------
1 client1 1,2
2 client2 3,2
3 client3 3
I want to get that Andy ...
0
votes
1
answer
34
views
How to sum column from different database with different number of rows?
Table1
NO
VALUE1
ORDER
1
1000
1
Table2
NO
VALUE2
ORDER
1
10
1
1
20
2
hi guys, i'm newbie in sql prgramming, i want to sum value1 from table1 with value2 from table2. I hope the total is 1030.
I ...
0
votes
1
answer
57
views
Divide results of a query in two different columns [closed]
I have the following result of a query:
P2_AU_CE
P2_03
P2_AU_CE
P2_04
P2_CN_MOCE_001
P2_04
I would like to have the result shown this way instead:
P2_AU_CE
P2_03
P2_04
P2_CN_MOCE
EMPTY
P2_04
0
votes
1
answer
191
views
regexp_substr in Oracle and Mysql
I executed the same statement in MySQL and Oracle, but they returned different results. Regular expression "/?" means to return zero or more "/", but why would MySQL return me a &...
- 3
0
votes
0
answers
31
views
Migrate Oracle v19 SQL Script To MySql v5.7 While Loop Read Schema
I would like to convert the following Oracle v19 sql script, to a MySql v5.7 sql script, not as a stored procedure.
Is this possible ?
SET serveroutput ON;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
WHENEVER ...
- 1,119