Top "Oracle" questions

How many database indexes is too many?

I'm working on a project with a rather large Oracle database (although my question applies equally well to other databases). …

database oracle database-design

In Oracle SQL Devleoper, when I copy the results, how can I copy the column headings too?

In Oracle SQL Devleoper, when I copy the results, how can I copy the column headings too? For example, I …

sql oracle oracle-sqldeveloper

oracle: can you assign an alias to the from clause?

can you assign an alias to the from clause? like: select a - b "Markup" from retail a, cost b; …

sql oracle table-alias

ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I …

oracle plsql toad database-cursor ora-00932

Insufficient Privileges when creating tables in Oracle SQL Developer

I have granted the user in my connection to create tables, triggers, procedures, and sequence using sql+ (grant create table …

sql oracle ddl

"ORA-03135: connection lost contact" when inserting large file

I'm trying to do an insert with a potentially large amount of binary data into a remote Oracle (11g) database …

c# oracle odp.net

Literal does not match format string for Oracle SQL to_date on a string column

Dear SQL Gurus from Stack Overflow: Environment: Oracle I'm trying to understand why I can't do a to_date selection …

sql oracle datetime to-date

Limit listagg function to first 4000 characters

I have a query that uses the listagg function to get all rows as a comma delimited string to ultimately …

sql oracle oracle11g string-concatenation varchar2

import dmp file into a new install of oracle xe

I'm trying to import a *.dmp file from the database of a client into a new install of Oracle XE 11.2.0. …

database oracle import dmp

Where is the Oracle Bug Database?

They must have hidden the bug database somewhere. I could not find it with Google. Is the bug database public?

oracle bug-tracking