Top "Oracle" questions

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

Fully Understanding PDO ATTR_PERSISTENT

Question: What are the rules/logic behind persistent connection management when using PDO? Environment: Web Server Windows 7 x64 Dual-core with 16…

php oracle pdo oracle10g
Running Oracle IMP as SYSDBA

I need to import an ORACLE 9 DMP file into a newly installed Oracle 11g. I'm using the imp utility and …

oracle imp sysdba
How to create a not null column in a view

Given a table like: CREATE TABLE "MyTable" ( "MyColumn" NUMBER NOT NULL ); I want to create a view like: CREATE VIEW "…

oracle casting oracle10g sql-view
Enforcement of unique/primary key - drop index

I am trying to drop an index : DROP INDEX PK_CHARGES but I get this error cannot drop index used …

oracle primary-key unique-index
Oracle BI Publisher auto width of excel columns

When creating a BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way …

oracle rtf business-intelligence bi-publisher
JPA - EclipseLink - How to change default schema

I'm programming a web application using weblogic and oracle. the datasource is configured through JNDI, with a restricted database user …

java oracle jpa schema eclipselink
How to establish a OracleConnection without making use of the obsolete OracleConnection Class

What's the 'new' way of establishing a OraConnection? Microsoft defines several classes as obsolete. https://msdn.microsoft.com/en-us/library/…

c# database oracle msdn system.data.oracleclient
SELECT COUNT(*) vs. fetching twice with an explicit cursor

I have read a book whose title is "Oracle PL SQL Programming" (2nd ed.) by Steven Feuerstein & Bill Pribyl. …

oracle plsql database-cursor
how to get names of partition in oracle while i input a date

I have a table with many partitions range. I need to get the name of all partition when I give …

sql oracle plsql oracle11g partition
installing Oracle Instantclient on Mac OS/X without setting environment variables?

Oracle's instructions specify setting DYLD_LIBRARY_PATH. This makes my application dependent on random users' configuration and is very troublesome …

oracle macos installation instantclient