Top "Oracle" questions

How to measure performance of query in oracle

I'm new to Oracle db. I have 2 queries which return the same result set. I want to measure the performance …

sql oracle sqlperformance

ora-01086 : save point was not established or invalid

Ora-01086 : save point was not established or invalid. KRD_UPD_BORCTAHSILATYAP_SP this SP throws errors . When I test this …

sql oracle plsql oracle11g savepoints

Oracle NUMBER(p) storage size?

I've searched for it but i can't find a conclusive answer to my question... I need to know what is …

oracle numbers size storage

Connecting Oracle to SQL Server via database link

I am trying to connect from Oracle 10G(on UNIX) to a SQL Server database (On windows). I have looked …

sql-server database oracle heterogeneous-services

oracle data pump import ORA-39002 with ORA-39070, ORA-29283 and others on Windows 10

I am using data pump to perform an import on 4 .dmp files and keep on receiving the set of errors …

oracle oracle12c datapump

Finding cause of deadlock error from oracle trace file

I have been getting this "ora-00060 deadlock detected while waiting for resource" error often now in my application when multiple …

oracle deadlock trace

Declare a variable in Oracle SQL to use in a query

Hi I am trying to declare a variable to use in Oracle SQL select query as such: DECLARE myDate DATE; …

sql oracle variables select declare

CREATE VIEW Using multiple tables

Hi trying to create a view in oracle. However I'm getting errors in my code which I can't work out …

sql oracle sql-view

How to create a database link in MySQL to connect to Oracle?

I need to create a database link in MySQL to connect to an Oracle database to use a table present …

mysql oracle database-link

Can't open View->DBA Menu in SQL Developer (Oracle 12C Standard Edition Installed)

I have installed Oracle 12C Standard Edition. Everything works fine there. I have also connected the Oracle SQL Developer Client 4.0. …

oracle oracle-sqldeveloper oracle12c