Top "Oracle" questions

UUID max character length

We are using UUID as primary key for out oracle DB, and trying to determine an appropriate max character length …

oracle primary-key uuid

Using LIKE in an Oracle IN clause

I know I can write a query that will return all rows that contain any number of values in a …

sql oracle sql-like

How can I get the number of records affected by a stored procedure?

For INSERT, UPDATE and DELETE SQL statements executed directly against the database, most database providers return the count of rows …

sql sql-server oracle tsql plsql

How to create a DB link between two oracle instances

How to create a DB link between two Oracle instances. Let's say A and B are two instances. I want …

oracle dblink

SQL Case Expression Syntax?

What is the complete and correct syntax for the SQL Case expression?

sql sql-server oracle syntax case

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch …

oracle plsql oracle11g sqlplus

Pivoting rows into columns dynamically in Oracle

I have the following Oracle 10g table called _kv: select * from _kv ID K V ---- ----- ----- 1 name Bob 1 …

sql oracle oracle10g pivot

GROUP BY without aggregate function

I am trying to understand GROUP BY (new to oracle dbms) without aggregate function. How does it operate? Here is …

sql oracle group-by aggregate-functions

ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g …

oracle oracle10g odp.net oracleexception

Subtracting Number of Days from a Date in PL/SQL

I would like to subtract a given x number of days from sysdate, can someone assist me on how to …

sql oracle plsql