is this DBA's only mailing list?

2003-05-30 Thread Ajay K. Garg
. Garg

Re: is this DBA's only mailing list? THANKS

2003-05-30 Thread Ajay K. Garg
, 2003 7:09 PM Subject: RE: is this DBA's only mailing list? Yes, we even let developers use this list. Heck, if you want to throw out a perl question cuz I bet you'll get an answer. ;o) Dave -Original Message-From: Ajay K. Garg [mailto:[EMAIL PROTECTED]]Sent

Oracle 11i new features

2003-05-28 Thread Ajay K. Garg
Hi Can anybody tell me a website where I can know about new features in Oracle 11/11i? Thanks in Advance Ajay K. Garg

Re: Experiences with Automatic Undo Management

2003-01-27 Thread Shaleen garg
We are using AUM on all databases(9014). Works great and we manipulate retention time as needed.Had one encounter with flashback query when got a call in lunch hour that someone updated wrong data in production. Flashback worked like a charm and data was restored within 15 minutes.

Re: unable to create stored outline for sql inside a procedure --

2002-12-25 Thread garg
Raj, Revoking a role on just a whim is a very dangerous thing and I think that could be a costly mistake for the wiseguy. This role could be used in places other than stored procedures as well.I consider revoking a role and revoking an explicit privilege the same level of mischief and

Re: Deadlock

2002-12-25 Thread garg
ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: garg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: sql with bind variable in stored procedure doesnt use

2002-12-13 Thread Shaleen Garg
: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaleen Garg INET: [EMAIL PROTECTED] Fat City Network Services

Re: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],

2002-12-12 Thread Shaleen Garg
Trace - Is there any solution for this problem? TIA Satish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaleen Garg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: sql with bind variable in stored procedure doesnt use stored

2002-12-12 Thread Shaleen Garg
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaleen Garg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Listener problem in Oracle 8.1.5 for RH 6.2

2002-05-10 Thread Nandu Garg
and review jobs in India or Abroad http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: RE: Move index to another tablespace

2002-04-01 Thread Nandu Garg
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: RE: CASE under Oracle8i

2002-03-25 Thread Nandu Garg
outout as just 'KING' here using CASE? Also what are the other usage of CASE functionality? NG -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Calling a Stored procedure from Java which returns cursor value

2002-03-21 Thread Nandu Garg
from java , but I think there must be some way out in Java for calling SP) NG P.S. I can call SP from java which is accepting parameter but not returnin value. Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network

Re: RE: what pl/sql construct can return multiple rows?

2002-03-20 Thread Nandu Garg
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Is Couchman book good for OCP SQL PLSQL

2002-03-19 Thread Nandu Garg
Hi I am using Oracle 8i SQL and PLSQL exam guide by Jason Couchman for my preparation of OCP. Is it good or do I need any other Book (for e.g. Advance PLSQL by Oracle Press OR Exam Cram) Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET

Handling Exception in query outputting refcursor block

2002-03-14 Thread Nandu Garg
://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

which query is ok in different environment

2002-03-06 Thread Nandu Garg
: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

Any Oracle Tool

2002-03-05 Thread Nandu Garg
it makes easier even to taste functions and Enter Data. I ll be very much glad if any information is passed . Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Which Book should I use for SQL/PLSQL OCP

2002-03-05 Thread Nandu Garg
Hi All Can anyone recommend me the book for SQL/PLSQL OCP exam paper. I would like to know the book which will be guiding me thoroughly Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858