RE: How to remove PL/SQL successfully completed Message

action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Any known problems using NOT IN ?

Siddharth, The NOT IN query fails to return rows, if the inner sub-query returns NULL values. It is always recommended to use the NOT EXISTS clause, unless you are sure that the inner query will not return any NULLs. Regards, Charu. -Original Message-From: [EMAIL PROTECTED]

SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?

, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET

RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?

ideas. HTH SF - --- Original Message --- - From: Charu Joshi [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 05 Nov 2003 04:04:38 Hello all, I am calling SQL*Plus from a unix shell script and storing the results of the query executed

RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected

$database; XXX } | while read DOINK LINE; do if [ $DOINK = DOINK ]; then DBNAME=$LINE fi done Now, if one is proficient in sed and awk, more elegant and robust means can be devised. -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Wednesday

RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected

]; then DBNAME=$LINE fi done Now, if one is proficient in sed and awk, more elegant and robust means can be devised. -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 6:05 AM To: Multiple recipients of list ORACLE-L Subject

RE: Finding overlapping time periods - suggestions please

Title: Finding overlapping time periods - suggestions please Hi, I remember reading a similar problem in 'Joe Celko's SQL Puzzles Answers'. The solution he provided was excellent and very innovative, but I can't recollect the method right now. See if you can find it somewhere; it might be

RE: dynamic sql problem

Siddharth, All roles are disabled in any named PL/SQL block (stored procedure, function, or trigger) that executes with definer rights. The SESSION_ROLES view shows all roles that are currently enabled. If a named PL/SQL block that executes with definer rights queries SESSION_ROLES, the

Oracle 7.3 client and NLS_LANG anomalies

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Good small reference !

on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Oracle on Win2000

Citrixcould another option worth evaluating. (I personally find it better than PCAnywhere.) Regards, Charu. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, September 04, 2003 3:25 AMTo: Multiple recipients of

RE: how to do a variable in-list of numbers?

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: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: how to do a variable in-list of numbers?

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ORA-03115 (TOAD question!!)

to just run the Oracle Home Selector that appears in the Startup-Programs-Oracle Installation Products menu. It has the benefit of also modifying the PATH variable. Jared On Thu, 2003-07-31 at 07:54, Charu Joshi wrote: RE: ORA-03115 (TOAD question!!)Hi, It worked!! As suggested by Raj, I

RE: Viewing the trigger source code - Piggyback Qu.

a line containing: 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.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City

RE: ORA-03115 (TOAD question!!)

y clod can have facts, having an opinion is an art ! -----Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, O

ORA-03115 (TOAD question!!)

SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: a simple xml output using stylsheet

Hi Rahul, Have a look at http://otn.oracle.com/tech/xmland also 'Oracle Application Developers Guide - XML'. There is a utility called XSQL which does this for you. Here's an example of that utility cut from the above mentioned guide (for 8i): declare queryCtx DBMS_XMLquery.ctxType;

Using the 9i version of UTL_HTTP in 8i

so? Will licensing be an issue here? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Using the 9i version of UTL_HTTP in 8i

it is to do so? Will licensing be an issue here? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: PLSQL stored procedure

disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu

RE: Testing database links

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Testing database links

session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL

Testing database links

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Testing database links

and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: GRRRRR OWS

Title: Message in general since they moved most support to India you get analysts that are more interested in playing the blame game than solving problems. Being an Indian I am sad to hear this, but I have to admit there's some truth in it. It is difficult to analyze why it should be

RE: [Q] how to check object or role grant to public?

on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Sql query

, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL

RE: Initial User Login

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL question

prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

SQL question

disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi

RE: Database tracking

of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City

RE: SQLPlus Substitution Variables

. * Visit us at http://www.mahindrabt.com begin 500 begin ` end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Urgent PDF to TXT Convert

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Some of you may find this useful

, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network

RE: invalid procedure/trigger

Depending on the interdependencies among the modules, youMAY have to run the creator scriptand the created script several times before all the objects become 'VALID'. I think it would be better to write a PL/SQL scriptwhich repeats the two steps (1. Find Invalid 2. Compile Invalid) until

RE: invalid procedure/trigger

Errata.. steps (1. Find Invalid 2. Compile Invalid) until all the packages are invalid. It should have been... until all the objects become valid. Regards, Charu -Original Message-From: Charu Joshi [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 1:55 PMTo

RE: columns with primary key constraint

, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET

RE: Dynamic select query

, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi

RE: Dynamic select query

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Debugging ORA-2042 error

://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Debugging ORA-2042 error

be the query?) 3. Find out which of these transactions are distributed (query??) 4. Kill some such transactions depending on who is running them (How?) Had a quick look at the distributed databases guide but it doesn't mention anything on any of the above tasks. Thanks regards, Charu Joshi

Urgent: ORA-02067 transaction or savepoint rollback required (Distributed transaction)

, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET

RE: Urgent: ORA-02067 transaction or savepoint rollback required (Distributed transaction)

of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat

RE: Urgent: ORA-02067 transaction or savepoint rollback required (Distributed transaction)

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: [Q] MS ODBC for ORACLE driver connection problem!!

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Trivia question - not of any practical use.

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Trivia question - not of any practical use.

at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to get the count of all tables using dbms_sql

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Any way to see the currently running SQL in one session.

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Elementary question about triggers

of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City

Elementary question about triggers

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web