Top "Oracle" questions

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

How to install oracle instantclient and pdo_oci on ubuntu machine?

I need to install PDO_OCI in ubuntu machine, there is no default package that I could install with apt-get. …

php oracle ubuntu pdo instantclient
Oracle: OALL8 is in an inconsistent state

As part of upgrading JRun, we are moving from a 1.4 JVM to a 1.6 JVM. Now I am getting a really …

java oracle jdbc coldfusion jrun
Is COMMIT required after every EXECUTE IMMEDIATE?

I have multiple EXECUTE IMMEDIATE commands within one oracle procedure. EXECUTE IMMEDIATE 'DELETE FROM tbl1'; EXECUTE IMMEDIATE 'INSERT INTO …

oracle stored-procedures oracle11g sp-executesql executequery
Call to undefined function oci_connect, php_oci8_12c.dll, windows 8.1, php5.6.6

I have a simple php script: <?php $db_user = 'myusername'; $db_pass = 'mypassword'; $db_sid = 'mysid'; $conn = oci_connect( $…

php oracle oracle11g oracle-call-interface
Overloading problem: Error(83,5): PLS-00307: too many declarations of 'REPORTEQ' match this call

So I am trying to use overloading but I am having some troubles. My package has 4 procedures with the same …

oracle plsql plsql-package
How to select the value of a variable in Oracle?

I'm new to Oracle. How can I set this variable and show its value? declare nextId number; begin select HIBERNATE_…

sql oracle select select-into
Run a Query from Linked Server (Oracle) in SQL Server2008 R2

I have the linked server set up in SQL Server 2008. But I could not run any query against the linked …

oracle sql-server-2008 linked-server
Oracle extract values from xmltype

This is the code I am currently using: SET serveroutput ON CREATE OR REPLACE PROCEDURE test_proc(i_xml varchar2) …

oracle plsql extract xmltype
Database vs tablespace, what's the difference?

In oracle what's the differences between a database and a table space?

oracle oracle11g
SQLPlus settings to generate tab-separated data file

Anyone have a good set of sqlplus configuration directives to help transform a given sql query into nicely tab separated …

oracle tabs sqlplus