Top "Oracle" questions

What is a good alternative to Toad for Mac OSX?

I am looking for an alternative to Oracle's Toad for Mac OS X. I currently use this for work on …

sql macos oracle xmltype

How do I check which schemata have been granted EXECUTE permission on an Oracle object?

I need to find out which schemata have already been granted execute permission on a certain object in an Oracle 10…

oracle oracle10g database-permissions grant

PL/SQL Developer: Multiple statements?

I have a script that generates a text file containing several SQL UPDATE statements: UPDATE TableX SET Field1 = 'New value 1…

sql oracle plsqldeveloper

concatenate CLOB data in oracle

I need to concatenate various CLOB data into a single CLOB field. I have a database with various rows, each …

oracle clob

Stored Proc hitting ORA-06502: PL/SQL: numeric or value error

I'm having a problem calling a stored procedure from OSB 11g thru JCA Adapter. The error I'm getting is: ORA-06502: …

oracle stored-procedures weblogic11g osb jca

Renaming partitions in ORACLE

if we use the ALTER TABLE RENAME PARTITION statement to rename the existing partitions in an Oracle table, do we …

sql oracle indexing database-partitioning

Oracle 9 - Resetting Sequence to match the state of the table

I have a sequence used to seed my (Integer based) primary keys in an oracle table. It appears this sequence …

oracle sequence oracle9i

Installer is unable to instantiate the file ...\KEY_XE.reg. The file does not appear to exist

I keep getting this error when trying to install Oracle Express edition on Windows 64. I searched online and the only …

oracle oracle-xe

Strange Oracle error: Identifier too long ORA-00972

I have faced this problem when working with ORACLE 10g. I read the answers given to this question here (ora-00972 …

sql oracle erlang odbc

Setting up JNDI Datasource with oracle in Tomcat

I can't make it work to get connection from DataSource obtained from JNDI in tomcat 7.0, resulting in error like this: …

oracle tomcat jndi