| |
1003 Search Results Found |
| 1 |
Forum: Marketplace «»
Posted on: Thu, 20 April 2023 11:04 «»
By: Alexeyg
Devart Has Released a Major Update of dbForge Tools for MySQL
…has rolled out an update of dbForge tools for MySQL. The enhancements focus on extended code completion and support for sequence tables in MariaDB databases, updated compatibility, as well as newly added support for MySQL functional indexes, new …
|
| 2 |
Forum: Marketplace «»
Posted on: Tue, 16 August 2022 04:10 «»
By: Alexeyg
Major Update of dbForge Tools for MySQL Is Out
…released dbForge Tools for MySQL, v9.1. The most remarkable things the update brings are the availability of the tools on Linux and macOS and support for MariaDB 10.9.
Devart, one of the leading developers of database management software, ALM …
|
| 3 |
Forum: Marketplace «»
Posted on: Tue, 16 August 2022 04:10 «»
By: Alexeyg
Devart Launched Grand Update - dbForge Studio for MySQL became available on Linux and macOS
…rolls out a new version of dbForge Studio for MySQL that now supports Linux and macOS and provides easy and seamless connection to the latest MariaDB Server 10.9.
Devart, one of the leading developers of database management software, ALM solutions and …
|
| 4 |
Forum: Marketplace «»
Posted on: Mon, 30 March 2026 23:30 «»
By: Mecanik1337
Easy COBOL DB Migrator - VSAM/DB2/CICS/IMS to PostgreSQL/MySQL/SQL Server/Oracle/SQLite
…COBOL DB Migrator converts COBOL data definitions to SQL schemas and generates data access layer code.
Targets PostgreSQL, MySQL, SQL Server, Oracle and SQLite. DAL output in Java, C#, Python, C++, Rust and Go.
Handles flat files, all 5 VSAM types…
|
| 5 |
Forum: Training & Certification «»
Posted on: Wed, 24 August 2022 03:04 «»
By: Raam
What Tool is Used to Transfer Data from Oracle Database to MySQL?
Hi all,
I have a lot of important and I want to migrate them in MySQL to make my work easy. Also is there any way to configure Six Sigma with MySQL.
|
| 6 |
Forum: MySQL «»
Posted on: Fri, 13 December 2024 13:27 «»
By: Frank Naude
Re: ORDER BY clause is not in SELECT list
…solved. Thank you Michel!
mysql> SELECT DISTINCT thread_id, subject FROM (SELECT thread_id, subject FROM msg WHERE apr=1 ORDER BY post_stamp DESC LIMIT 30) LIMIT 10;
ERROR 1248 (42000): Every derived table must have its own alias
MySQL is full on …
|
| 7 |
Forum: MySQL «»
Posted on: Fri, 13 December 2024 10:30 «»
By: Frank Naude
ORDER BY clause is not in SELECT list
…someone here can help me to rewrite the query below. It was working perfectly in MySQL 5, but after upgrading to MySQL 8, is giving an error:
mysql> SELECT DISTINCT thread_id, subject FROM msg WHERE apr=1 ORDER BY post_stamp DESC LIMIT 10; …
|
| 8 |
Forum: Suggestions & Feedback «»
Posted on: Wed, 09 October 2024 09:02 «»
By: Mahesh Rajendran
Re: Site statistics
…IMO,
>> - People don't use Oracle as much as they did back in 2007 (and use MySQL or PostgreSQL and similar)
>> - Mostly all questions have already been answered and people easily find them on Google (or Bing or ...)
These are true. In my …
|
| 9 |
Forum: Marketplace «»
Posted on: Mon, 03 April 2023 00:05 «»
By: Alexeyg
Meet dbForge Edge - Brand New Multidatabase Solution by Devart
…has released a new multidatabase solution in the dbForge product line - dbForge Edge. The solution includes four database IDEs that cover a wide range of tasks across multiple database management systems.
Devart, one of the leading developers of …
|
| 10 |
Forum: Suggestions & Feedback «»
Posted on: Wed, 09 October 2024 06:41 «»
By: Littlefoot
Re: Site statistics
…do you (not only you, Michel) think: what is the reason?
- People don't use Oracle as much as they did back in 2007 (and use MySQL or PostgreSQL and similar)
- They moved to other communities (forums)
- Mostly all questions have already been …
|
| 11 |
Forum: Weblogic & Application Server «»
Posted on: Mon, 10 April 2023 05:07 «»
By: madurani
Re: Weblogic migration
…can I backup Weblogic? Because via tools BackupPC or Networker, the data from backup are not usable.
I tried to clone one VM on OVM, and I deleted the volume where WebLogic was installed , and then I restored it back via both mentioned tools. In both …
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 02 March 2021 23:48 «»
By: mikewazowski
Re: Generate SQL via SQL
…wow, this looks much more complicated at first sight than the first idea But many, many thanks for that.
At first I couldn't get it to work for me. In lines 23 to 31 you define compute. There you join the two tables tab_data and tab_rule, but in my …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 23 February 2021 08:42 «»
By: mikewazowski
Re: Generate SQL via SQL
Oh, you already answered while I was writing so much
I will test this in the next few days and get back to you.
Additional question: Do you know if this SQL would also work in MS SQL and MySQL (maybe with slightly different syntax)?
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 21 December 2020 10:38 «»
By: aimy
DBMS_HS_PASSTHROUGH - Column Value Truncated
…Hi..
My PL/SQL
CREATE OR REPLACE PROCEDURE SRPSTL.Z_MIE_TEST_3 as
/*
To populate data to Z_MIE_B_USR112_BC_ACCT from USR_112.BC_ACCT@UATCBS
exec SRPSTL.SP_GRANT_TAB('Z_MIE_B_USR112_BC_ACCT');
Notes:
1st creation - Friday, 18 December …
|
| 15 |
Forum: Networking and Gateways «»
Posted on: Fri, 16 October 2020 08:03 «»
By: EdStevens
Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed
…
dg4odbc doesn't know anything about target (not source) database, regardless of it's flavor. . dg4odbc simply calls an odbc driver, and all odbc drivers present the same interface to the calling program, dg4odbc in our case. Tell dg4odbc to call a …
|
| 16 |
Forum: Windows «»
Posted on: Sat, 05 September 2020 08:33 «»
By: EdStevens
Re: temporary table
…
Indeed it was.
I suspect that what you really need, instead of a GTT, is technique known as 'sub-query factoring'. Using your information, something like this:
with temp_data as
(SELECT h.part_no,
h.lot_batch_no,
h.location_no…
|
| 17 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Wed, 05 August 2020 10:51 «»
By: John Watson
Re: Connect On-Prem Oracle to WebApp for Time Punch?
…to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read
You could use the ODBC HS Gateway (which is free). The setup is a bit convoluted if you haven't done it before, but in principal it is a …
|
| 18 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Wed, 05 August 2020 06:01 «»
By: deepakshetty
Connect On-Prem Oracle to WebApp for Time Punch?
…anybody point me in the right direction on this? I am looking to connect a basic mobile/webapp to an on-prem oracle database. I have a basic website built that allows the user to login and then hit a button on the page and have it record the time punch …
|
| 19 |
Forum: Marketplace «»
Posted on: Mon, 13 July 2020 03:27 «»
By: alexsap
Cross-platform Database Migration and Modernizarion Toolkit
…MnMTK automates the entire migration of database objects from source database to Oracle platform. It converts SQL, stored procedures, views, functions, triggers, tables, constraints, sequences and transfers data at up to 100% automation rate.
MnMTK [/…
|
| 20 |
Forum: Marketplace «»
Posted on: Tue, 19 May 2020 03:58 «»
By: Alexeyg
Devart Presents Dramatically Improved dbForge Studio for MySQL v.9.0
…introduced the new version of its key tool, dbForge Studio for MySQL, v.9.0. Almost every feature of the IDE was examined and significantly improved.
Devart, a recognized vendor of professional database management software for developers and DBAs, …
|
| 21 |
Forum: Weblogic & Application Server «»
Posted on: Wed, 18 March 2020 15:30 «»
By: hariyapuraju
weblogic 12.2.1.4 and Mysql driver - Issue with JNDI configurartion
… which comes with weblogic) as below
jdbc:mysql://localhost:3306/databaseA
When trying to use the JNDI we are not only getting databaseA tables but also other databases tables like databaseB which are present.
That means the databaseA passed in the…
|
| 22 |
Forum: Backup & Recovery «»
Posted on: Thu, 05 March 2020 15:26 «»
By: yordan
Re: Help with backup
…Ok, sorry, my mistake, the problem is that even with your sugestions, I still need to make it, because there is no one that can do it, even if it is not for beginners (take into account that I am beginer with oracle, I already have a lot of experience …
|
| 23 |
Forum: Backup & Recovery «»
Posted on: Wed, 04 March 2020 08:59 «»
By: yordan
Help with backup
…everybody, I need some help, I am neewie in Oracle, I have used other database servers (Postgresql, Sql server, Mysql, etc) but now I need to restore database backup in Oracle, the problem is that I dont know how to do it, I already have installed the …
|
| 24 |
Forum: MySQL «»
Posted on: Thu, 14 November 2019 14:13 «»
By: BlackSwan
Re: Insert data from Oracle 11g to MYSQL
Since PERL can inter-operate against both DBs, I would write some PERL that did a SELECT FROM ORACLE into PERL variables & then INSERT INTO MYSQL using the same PERL variables.
|
| 25 |
Forum: MySQL «»
Posted on: Tue, 12 November 2019 23:51 «»
By: chintan.patel
Insert data from Oracle 11g to MYSQL
…friends,
I would like to insert data from oracle to mysql. I have one view in oracle 11g (on linux OS) and one table in mysql (on Windows OS). I wish to select data from oracle view and insert the same into mysql table. Is there any method to do the …
|
| 26 |
Forum: Data Integration «»
Posted on: Tue, 22 October 2019 03:11 «»
By: OracleFan168
Import data from other DB or excel into Oralce or export data from Oracle into other db or excel
…I'm a green hand of Oracle and have the following quesitons, thanks you for you kind help!
1. Are there any ways to import data from MySQL、MS SQL Server and Excel into Oracle ? if there are many ways, which one is the best ?
2. how to export data …
|
| 27 |
Forum: Marketplace «»
Posted on: Mon, 20 May 2019 00:54 «»
By: sandycullen
What Tool is used for Oracle Database to MySQL Migration
…to MySQL migration posses various challenges to Database Administrators from file format to table structure after migration, the DBA has to think about all these details before proceeding. A single error during Oracle to MySQL conversion may cause harm to…
|
| 28 |
Forum: Networking and Gateways «»
Posted on: Wed, 31 October 2018 12:11 «»
By: John Watson
Interoperating different releases of database and HS gateway
…I've configured the HS gateway before, but only on a small scale: Installing it into the same Oracle Home as the database, and configuring a connection to one remote non-Oracle database. However, a possibility has come up of needing to install gateways …
|
| 29 |
Forum: MySQL «»
Posted on: Wed, 01 August 2018 05:23 «»
By: ajamitjain129@gmail.com
Re: How to reduce time for below SQL.
I know about it MySQL EXPLAIN. Now my query is not giving lost connection in MYSQL workbench and providing result successfully.
|
| 30 |
Forum: MySQL «»
Posted on: Wed, 01 August 2018 05:09 «»
By: gazzag
Re: How to reduce time for below SQL.
Using MySQL EXPLAIN.
|
| 31 |
Forum: MySQL «»
Posted on: Wed, 01 August 2018 02:07 «»
By: John Watson
Re: How to reduce time for below SQL.
Moved to the MySQL forum.
|
| 32 |
Forum: MySQL «»
Posted on: Fri, 27 July 2018 05:32 «»
By: johntimber
MySQL Issue
…Hi,
I have installed mysql version 5.6.16 for another program that I use. I have installed the latest version of vueminder which uses mySQL. I do now know how to link mySQL to vueminder now. The instructions on the website cant help me because that is…
|
| 33 |
Forum: Linux «»
Posted on: Fri, 25 May 2018 02:08 «»
By: ssyr
How To check Connectivity from Linux using hostname/IP
…All,
could you please suggest me the command used to check connectivity from Linux OS. In my case MYSQL, MSSQL all databases are available I want to test its connectivity from Linux
How Can I check this please suggest me some help on this.
I …
|
| 34 |
Forum: Replication «»
Posted on: Tue, 22 May 2018 02:32 «»
By: Ellen Vasil
Re: Replication using Oracle GoldenGate.
Did you try DBSync for Oracle & MySQL product?
It can replicate multiple schemes.
|
| 35 |
Forum: MySQL «»
Posted on: Sat, 14 April 2018 12:50 «»
By: Michel Cadot
Re: OLE DB provider "OraOLEDB.Oracle" for linked server "GTPFR" returned message "ORA-00907: missing rig
…Substr(b.custno,1,15) AS custno,
Substr(b.custno,2,6) AS custno6,
b.amount AS amount,
b.trantype AS trantype,
Substr(h.team,1,10) AS team…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 29 March 2018 04:36 «»
By: Nanex
How to get this table from that Database
…guys,
I'm fairly new to PL/SQL(Oracle), but have basic knowledge in MySQL.
So, I got a SQL database with logs which looks anything like
Package ID || Location ID || Action || Timestamp
1 || A || Req…
|
| 37 |
Forum: Marketplace «»
Posted on: Tue, 16 January 2018 07:59 «»
By: BlackSwan
Re: Convert any Database to Oracle
…the SQLIE.COM website NONE of the listed examples mention Oracle.
The uses of SQLIE:
1-Convert PostgreSQL Database Tables to SQL SERVER Database tables and vise versa.
2-Convert PostgreSQL Database Tables to MYSQL Database tables and vise versa…
|
| 38 |
Forum: Marketplace «»
Posted on: Tue, 16 January 2018 07:37 «»
By: db_news
Convert any Database to Oracle
…guys , now we can convert any database table to schema oracle user database by using SQLIE app.
SQLIE can convert following db to oraacle DB:
1-MYSQL to Oracle
2-PostgreSQL to Oracle
3-Access to Oracle
4-SQL Server To Oracle
SQLIE is a middle ware…
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 29 December 2017 04:17 «»
By: nicolewells
mysql and oracle issue using dblink
…issue is between mysql and oracle communication:
Step 1 (Creating a view in mysql for corresponding table)
E.g:
CREATE VIEW piwik_log_link_view ( idvis, cusk )
AS SELECT CAST( CONV( HEX( idvisitor ), 16, 10 ) AS CHAR(1000) )
, …
|
| 40 |
Forum: MySQL «»
Posted on: Thu, 23 November 2017 02:59 «»
By: gazzag
Re: how to retrive all COUNTRY from a table
And Oracle owns MySQL.
|
Blog
Search
Help
Members
Register
Login
Home