Top "Oracle" questions

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

Could not create the driver from NHibernate.Driver.OracleDataClientDriver

Here's the code raising the exception: public static class NHibernateSessionManager { private static ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory(); public static …

c# oracle nhibernate connection driver
How can I see the SQL execution plan in Oracle?

I'm learning about database indexes right now, and I'm trying to understand the efficiency of using them. I'd like to …

oracle sqlplus sql-execution-plan
Creating an Oracle User if it doesn't already exist

I am trying to create a script that will create users if they do not already exist. CREATE USER "Kyle" …

oracle oracle11g createuser
Using variables in Oracle script

There is a complex query which generates a report. The query has several sub queries that generate 3-columns table for …

sql sql-server oracle plsql ansi-sql
Calling oracle function using database link

I have created a oracle function called getEmployee(id in varchar) in my remote database and I'm trying to call …

sql oracle database-link ora-24338
Best way to check if SYS_REFCURSOR is empty

I have a cursor with values from a select and i want to do something after depending if i had …

sql oracle plsql sys-refcursor
How do I get the return value from a function in Oracle using Toad

How do I find out in Toad what the return value of a function is? I'm running something like this …

oracle toad
Detecting if an Oracle Database is Installed

I was wondering if there was a way to tell if an instance of Oracle on a system has a …

oracle installation detection
SQL Server Equivalent of Oracle 'CONNECT BY PRIOR', and 'ORDER SIBLINGS BY'

I've got this Oracle code structure I'm trying to convert to SQL Server 2008 (Note: I have used generic names, enclosed …

sql-server oracle recursive-query siblings connect-by
How to get current GMT in Oracle

I'm trying to get the current GMT/UTC regardless of the time zones my current database is located. The possible …

sql oracle gmt