Top "Oracle" questions

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

Spaces when concatenating multiple columns and one column is null - Oracle

I need to concatenate several columns into one, with spaces between each value. The problem is when one value is …

oracle null concatenation space
cx_Oracle and Exception Handling - Good practices?

I'm trying to use cx_Oracle to connect to an Oracle instance and execute some DDL statements: db = None try: …

python oracle cx-oracle
How do I display the full content of LOB column in Oracle SQL*Plus?

When I try to display the contents of a LOB (large object) column in SQL*Plus, it is truncated. How …

oracle blob sqlplus clob lob
Will Oracle lock the whole table while performing a DML statement or just the row

When i try to insert/update something in a db table, will Oracle lock the whole table or only the …

database oracle oracle11g database-locking
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

I have a method in Dao Class that returns List<Object[]> back and I am using named Query …

java sql oracle named-query
Run 2 queries at the same time on Oracle SQL Developer?

I need to retrieve quite a bit of data from our oracle DB and to do so I need to …

oracle oracle10g oracle-sqldeveloper
How can I give to user, execute another users's functions?

I want to give privileges to a user to call a function another users function. I write this : GRANT EXECUTE …

oracle privileges grant
decimal(s,p) or number(s,p)?

recently, while working on a db2 -> oracle migration project, we came across this situation. the developers were inadvertently …

oracle db2 ansi type-conversion
Installing Oracle 32-bit Client on Windows Server Already Running 64-bit Oracle Database Server

I have 64-bit Oracle Database Server (11.2.0.3) installed on Windows 2008 R2, and naturally, it automatically installs the 64-bit client. I have …

database oracle client 32-bit
Relation between Oracle session and connection pool

Let me explain the set up first. We have an oracle server running on a 2GB RAM machine. The Db …

oracle oracle10g connection websphere