Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Effects of changing NLS_LANG setting in the registry for Oracle Client

We are in the process of moving from the .NET Microsoft oracle driver to the ODP.NET driver. One of …

oracle registry odp.net oracleclient ora-12705
Oracle SQLDeveloper Autocomplete in Lowercase (How about Uppercase)

I am currently using the latest Oracle sql developer. I just have one nuisance here. When I do auto-complete of …

oracle autocomplete uppercase oracle-sqldeveloper
Oracle import dump file throwing ORA-39088 error

I am trying to import data from a dump file created by Oracle 10g data pump utility. The command that …

oracle import impdp oracle-dump
MERGE - When not matched INSERT's exception

i have a PL/SQL procedure using MERGE : MERGE INTO table_dest d USING (SELECT * FROM my_Table) s ON (…

sql oracle merge ora-00001
Path for Weblogic Home& Java home for adding Oracle server in eclipse

I had installed oracle weblogic tool for in my eclipse luna by simple drag and drop to my workspace from …

eclipse oracle weblogic settings java-home
What is the equivalent PostgreSQL syntax to Oracle's CONNECT BY ... START WITH?

In Oracle, if I have a table defined as … CREATE TABLE taxonomy ( key NUMBER(11) NOT NULL CONSTRAINT taxPkey PRIMARY KEY, …

sql oracle postgresql recursive-query connect-by
Show all queries coming to an Oracle database

I need to see all queries coming to database. How to do that? I could not get proper results from …

oracle monitoring
Convert from Oracle's RAW(16) to .NET's GUID

I'm having difficulties manually debugging an .NET application where the Guid values differ from .NET to Oracle. Where C# reads: 17…

c# oracle nhibernate guid s#arp-architecture
Missing Keyword (ORA-00905) - Oracle SQL Case Statement

Good morning, I was wondering if one of you could help me - should be fairly quick I'd imagine; I'm …

sql oracle case ora-00905
C# call oracle stored function

create or replace function ar_knyga_egzistuoja( id number ) return number is kiekis number; begin select count(*) into kiekis from …

c# oracle stored-functions