Top "Oracle" questions

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

Splitting comma separated string in a PL/SQL stored proc

I've CSV string 100.01,200.02,300.03 which I need to pass to a PL/SQL stored procedure in Oracle. Inside the proc,I …

oracle plsql tokenize
Oracle 10g: Extract data (select) from XML (CLOB Type)

I'm new in Oracle and I've - maybe trivial - a problem in a select. (I'm using Oracle 10g Express …

xml oracle oracle10g ora-00932
"Cannot create an instance of OLE DB provider" error as Windows Authentication user

I am trying to run openrowset from MS SQL Server on an Oracle server. When i execute the following command: …

sql-server oracle oledb windows-authentication linked-server
TNS Protocol adapter error while starting Oracle SQL*Plus

Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection …

oracle oracle11g sqlplus
Finding rows that don't contain numeric data in Oracle

I am trying to locate some problematic records in a very large Oracle table. The column should contain all numeric …

sql oracle varchar numeric varchar2
Unique constraint violation during insert: why? (Oracle)

I'm trying to create a new row in a table. There are two constraints on the table -- one is …

oracle unique-constraint
How to insert a column in a specific position in oracle without dropping and recreating the table?

I have a specific scenario where i have to insert two new columns in an existing table in Oracle. I …

oracle oracle11g
Oracle 11g Express Edition for Windows 64bit?

I registered on http://Oracle.com in order to download 11g R2 Express edition database. But http://Oracle.com offered …

windows oracle 64-bit oracle-xe
Extract data from XML Clob using SQL from Oracle Database

I want to extract the value of Decision using sql from table TRAPTABCLOB having column testclob with XML stored as …

sql xml oracle parsing clob
What is cardinality in Databases?

I have been searching all over the internet but I couldn't seem to find an answer that I can understand. …

database oracle database-design cardinality