Questions tagged [oracle-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
140 views

Index Analysis and Tuning tool for PostgreSQL, MySQL, and Oracle?

I have used SentryOne Plan Explorer to perform index tuning and index analysis with great success on SQL Server and Azure SQL Database. What are some of the better equivalent tools to consider for ...
1
vote
0answers
12 views

Saving images and documents in a database

I'm developing a web application and i am using angular in frontend and springboot in backend with oracle database , so my problem is that i saved images and documents in my oracle database and it ...
0
votes
0answers
11 views

Oracle APEX vs MSSQL

I would like to request another software solution similar to Oracle Apex but using MSSQL database. Could you help me? Unfortunately, the customer won't buy Oracle license.. Thank you!
0
votes
0answers
48 views

vue.js for oracle database oriented web app

I am working on creating web app mounted on oracle DB. web app would be a search tool - users would input some text in search field and based on input database tables would be looked for matching ...
0
votes
0answers
3 views

Do we have any package/library to read excel files in Oracle 12 and above?

I need a suggestion on how to read excel files in oracle. Is there any library/package that simplifies the work.
0
votes
0answers
5 views

Oracle to PostgreSQL migration

To avoid licence cost we are analyzing the migration of hundreds of Oracle DB to PostreSQL. Currently Oracle DB uses all Oracle functions and in some cases RAC configuration. Is it possible to ...
0
votes
0answers
10 views

how many concurrent session does oracle database support

I want to have an application linked to oracle database the users will request data through the app and the app will access the database and retrieve the info. my question is how many concurrent ...
1
vote
0answers
6 views

Python library to parse SQL create statements

I have a requirement of reading Oracle create statement in a file and gather all Metadata (Table name, column name, its datatypes etc). I have tried following but no luck so far: 1) Used twextpy (pip ...
1
vote
0answers
17 views

Replacing Oracle Discoverer

Oracle Discoverer as been discontinued by Oracle. Oracle suggests to switch to BIPublisher but it seems to be to expensive and a bit to much for what we need. What we really need is a opensource or ...
1
vote
0answers
7 views

How can I periodically transfer data from my local Oracle-XE database to a remote Oracle 11g?

Here's my use case: In order to speed things up in my real time application, I came up with the idea of using Oracle-XE as a local cache database for faster access & then somehow transfer (...
0
votes
1answer
20 views

Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise? [closed]

Lets take this: Company using Microsoft Server Database since 2008. Its company what heavily depends on working with data from databases. (Construction company ) Current database is outdated and not ...
0
votes
3answers
333 views

Is there alternative to SQL Developer that supports PL/SQL too?

I found Oracle's SQL Developer hard to setup, so I would like to use something easier, but with support of the same language or maximally close, preferably free (GNU) and preferably available for ...
3
votes
2answers
154 views

How to document (describe in HTML) Oracle schema?

I'm trying to find a tool (or simple program, script, jar file) to describe my oracle database (schema). What I need from output report: HTML format ER diagram in output Table and Columns ...
1
vote
0answers
17 views

Program not from Oracle that can read Oracle export dumps?

I am maintaining an Oracle database. Recently, my boss asked me what would happend if we for some reason suddenly could no longer use Oracle products. So I am now looking for some kind of software ...
0
votes
1answer
54 views

Tool for migrating oracle table to CSV file

I want to migrate data from oracle table to a csv file. Is there any tool for this migration?
0
votes
0answers
17 views

Converting create table statements from Oracle SQL to PostgreSQL

I am looking for a program that can converting create table statements from Oracle SQL to PostgreSQL (e.g., choose the closest type for each column). Any OS, any license, any price is fine. CLI or ...