Questions tagged [oracle-database]
The oracle-database tag has no usage guidance.
17
questions
0
votes
1
answer
76
views
Which modern IDE to choose when working with Oracle database on Windows?
Good afternoon!
I am working with Oracle Database (mostly writing queries, stored procedures and creating tables). The problem is that I can not find a modern IDE to work with Oracle such as Visual ...
- 1
3
votes
0
answers
52
views
Visualisation of database object dependencies
I'm searching for a tool to visualize dependencies between all kinds of Oracle database objects (tables, views, triggers, scheduler jobs, packages/functions/procedures & direct and indirect grants)...
- 131
0
votes
1
answer
25
views
All in one solution for Oracle PL/SQL student
I am looking for something where I can develop oracle pl/sql with the following characteristics.
-That can raise a DB (DDL) in a simple way.
That supports PL/SQL, especially anonymous functions (I ...
- 1
0
votes
1
answer
91
views
looking for alternative rdbms for oracle which is build by russian
can anyone suggest any alternative to DB2, Sybase, and Oracle? I knew that Teradata is a good alternative to these. But most oracle guys ridicule to this they still think Oracle is superior and more ...
- 7
1
vote
1
answer
521
views
Which database is good for automotive GPS tracker?
we are developing a recording system for automotive gps trackers production of our company.
we log their data nearly 1 year and each gps node sends data to record each 5 seconds. each data contain ...
- 11
2
votes
0
answers
25
views
Oracle SQL query optimizer (for speed/efficiency)
I'm a data analyst (novice) who writes Oracle 18c SQL queries on a regular basis. I'm aware that my SQL queries are sometimes not structured in the most efficient way possible.
I have a variety of ...
- 121
2
votes
0
answers
316
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 ...
- 121
1
vote
0
answers
18
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 ...
- 11
1
vote
0
answers
21
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 ...
- 11
1
vote
0
answers
23
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 ...
- 11
1
vote
0
answers
19
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 (...
- 111
0
votes
1
answer
27
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 ...
- 141
0
votes
3
answers
405
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 ...
- 269
1
vote
0
answers
18
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 ...
- 111
0
votes
1
answer
60
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?
- 123
3
votes
2
answers
314
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 ...
- 131
0
votes
0
answers
20
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 ...
- 37.3k