How do I write a stored procedure that is returning only a subset of a
resultset.
I know I have to make a package and declare the result type as ref cursor
when I want to return a resultset.

I wish to implement replication for a e-commerce website to avoid
single server crash.
Which one is the most suitable - Passive/Active?
Many thanks

Is there any way that I can have the results in Grid in SQL * Plus
WorkSheet as in SQL Server Query Analyser?
Madhivanan

We've had ORA-00060 "deadlock detected" messages several times for
a few days in one of our apps here, and the other day an angry and
annoying developer came to insult and bury us with much gesticulating,
then quit our cubicle saying we were w**kers and incompetent etc etc.

Hello *.*,
is there a possibility to tune mass deleted on a table, that is linked
to by many other tables using foreign keys. These tables have about
100-200 times more records than it, not null links.

i am trying to extract data out from an oracle server and am having a
tough time with the most basic sql statement. when i run
SELECT tcof.EML_ADDRESS from
test.EML_TCOF tcof,

We are running Solaris 2.8 and Oracle RDBMS 9.2.0.4.
I need to audit the amount of SQL*Net sessions open at a regular
interval and also how many of those are a particular user (INTERNET).
I was going to set up a table and have the PL/SQL procedure update it

REF CURSOR question.
I have a package in X database with name PKG1 ... I have a Procedure
which returns a REF CURSOR. Now I have to use
this parameter as a input parameter in other procedure which is not a

I know this topic has been there in Google Groups many times but I
could not find a solution my problem could relate to.
We have a scheduled job(perl file) running that selects some data from
a db and updates the same in another db. The job actually consists of

We have an HP SuperDome server that we are trying to find a new home
for.
This system has been under HP maintenance support contract and is in
great cosmetic and mechanical condition.

Does anyone know how to instruct SQL*Loader to ignore the last record
in a flat file when the size of the flat file is not constant?

I am running Oracle 10G on WinXP Pro 2.8G CPU  1G Memory New machine,
clean install.  I have used Oracle in all capacities for 15 years, but
have not seen this before.
I am getting an Oracle Connection time-out after 15-30 minutes with no

can any guru tell me how can i create folder (c:\test\test1) in my disk
using oracle pl/sql?
please give me some adive.
thanks,

hello..
with oracle 7.3.4.4 and with remote_login_passwordfile=NONE,
can a user be granted the SYSDBA system privilege?
Or does granting the SYSDBA system privilege imply that a password file must

I am getting following errors while using MERGE.
ORA-02291: integrity constraint (PTEST.SYS_C0010720) violated - parent key
not found
I am i using following MERGE sql.