Top "Oracle" questions

Excel VBA connect to remote Oracle DB with InstantClient

I am trying to use Excel (mainly 2003, for more user compatibility) to connect to a remote Oracle DB. I would …

sql excel oracle vba instantclient

Oracle: how to drop a subpartition of a specific partition

I am using an oracle 11 table with interval partitioning and list subpartitioning like this (simplified): CREATE TABLE LOG ( ID NUMBER(15, 0) …

oracle oracle11g partitioning database-partitioning

Executing a Stored Procedure in Oracle

I have a stored procedure, on Toad for Oracle I am calling the procedure using SELECT FROM PKGName.ProcedureName(1,'10/10/2010…

sql oracle ora-00904

PHP PDO installation on windows (xampp)

I am trying to develop a web app that can connect to as many different databases as possible on PHP. …

php oracle pdo sybase

Oracle Sql Loader "ORA-01722: invalid number" when loading CSV file with Windows line endings

I am using Oracle Sql Loader Utility from Linux shell to load csv data into Oracle DB. But I have …

oracle sql-loader

How to restore dump file in Oracle 12c

I want to restore a database in oracle 12c. I have done something for it but while importing data I …

oracle datapump

Enforce a foreign-key constraint to columns of same table

How to enforce a constraint of foreign key on columns of same table in SQL while entering values in the …

sql oracle foreign-keys self-reference insert-into

Using Spool in Oracle 11g

I want to use spool functionality in Oracle 11g. I want the entire output to be spooled into a file …

oracle oracle11g spool

How to give the output of the first query(which has two values) as the input to the second?

i get 2 names as the output of the first query.... eg: paul,peter now this should be the input for …

sql oracle oracle10g nested-queries

SQL: how to limit a join on the first found row?

How to make a join between two tables but limiting to the first row that meets the join condition ? In …

sql oracle join greatest-n-per-group