It's possible to achieve something like this?
Procedure1(param1,param2) IS
...
begin

Hello, Oracle 10.2.0.3 on Linux here.
I have two tables, P (parent table) and D (data table):
hr@> create table p ( pid integer primary key, ptype varchar2(1) not
null, pname varchar2(80) not null ) ;

All,
at Oracle 9.2.0.8
we are aiming to  delete huge  rows( old data )  from a table T1
Since we can not afford outage hence CTAS and other options are ruled

I have been given access to a certain database at Oracle level, but no
UNIX access.
Is it possible to determine whether a connection (Oracle session) is
Bequeath connection or connection through listener by looking at V$

Oracle version 10.2.0.4
OS Linux 64 bit
I am investigating performance issue's on Siebel.
I traced a session with the 10053 event to see the optimizer

I picked up lag from this group a few weeks ago and ... nice stuff.
Now I'm trying to create a query that contains a future date.  That
means all the values in a row are LAG values except for the future
date.  I can lag a field.  How can I lag all the fields?  Do you have

Hi all, this is my first foray into optimization and I'm at a
relatively beginner level.
The situation that I have is an exceedingly simple one.
I have a table with a list of phone numbers, table A.

Ok, whomever wrote this dumbass application should be put on trial.
Anyhow, we have a column in our table which is defined as VARCHAR2,
but contains both numbers AND character data.
Problem is that we need to do some < & > in a query on the numeric

http://www.baselinemag.com/c/a/Business-Intelligence/40-Fast-Facts-about-Oracle-
776052/
Quite interesting ;-)
Matthias

(How I wish there was a comp.lang.sql for generic sql questions!).
I have a table structured thus:
Emp_org, emp_dept, emp_sub_dept, emp_language, emp_location.
(This is not my table but an attempt at a simplified example).

Does anybody have any idea?
http://www.oracle.com/technology/software/products/database/index.html

I vaguely remember this has been asked and answered before, but can not
find the answer anymore:
Suppose I have a table in which a column has a value for some rows, and
none (null) for others. Is there a way to let a select statement (which

table 1
ref     code
1       code_1
1       code_2

While tracking down an ora-1652 error today I noticed two very similar
statements that were running just prior to the error. They contained a
dbms_stats hint and looked something like the one below. What is the
dbms_stats hint and can I safely assume it was the stats job that

Is it possible to concatenate records in a field via Group By clause
of an SQL statement?
Untested script is :
create table t1(country varchar2(32), state varchar2(32), city varchar2