Top "Oracle" questions

How to create a table inside of a procedure in Oracle?

I want to create a table inside of a procedure. I tried to put the create query in a string …

sql oracle stored-procedures create-table

Problem with execute procedure in PL/SQL Developer

I this is my first attempt to create procedure and execute it. First I create simple table. DB scheme of …

sql oracle plsql procedure ora-00900

Relationship between catalog, schema, user, and database instance

To compare databases of different vendors (Oracle, SQL Server, DB2, MySQL, and PostgreSQL) how can I identify any object uniquely …

mysql sql-server oracle postgresql db2

TNSPING OK but sqlplus gives ORA-12154?

I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL Plus. …

oracle oracle11g sqlplus ora-12514

SQL GROUP BY - Using COUNT() function

I've been doing a task which involves creating a database for a hospital and I've been encountering a very frustrating …

sql oracle group-by ora-00979

How to fetch Oracle reference cursor into table variable?

I am trying to load data from reference cursor into a table variable (or array), the reference cursor works if …

oracle stored-procedures ref-cursor

Update materialized view when urderlying tables change

I have a materialized view defined this way: CREATE MATERIALIZED VIEW M_FOO REFRESH COMPLETE ON COMMIT AS SELECT FOO_…

oracle oracle10g materialized-views

Unable to load DLL “OraOps10.dll”

I am running into peculiar issue. I am developing a windows based application which connects to Oracle database. For initial …

c# oracle odp.net winforms-interop

How to improve performance in Oracle using SELECT DISTINCT

I'm currently working in the deployment of an OFBiz based ERP The database being used is Oracle 10g Enterprise One …

performance oracle ofbiz

Oracle: how to create an identity column?

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g. How can …

sql oracle identity