RE: Any known problems using NOT IN ?

Naveen, The column does have nulls and this was the problem. Thanks for the insight.   Thanks Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) #  : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]   -Original

RE: Any known problems using NOT IN ?

Charu,   Thanks for your explanation. It is perfectly valid for me.   Thanks Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) #  : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]   -Original Message- From

Any known problems using NOT IN ?

RE crs     WHERE crs.os_id_fk1 = csr.os_id_pk     AND crs.active_flag  = 'Y');      This above query works fine.       Thanks Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore

RE: dynamic sql problem

Thanks for all those who answered Using authid current_user in package has solved my problem.   With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) #  : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED

dynamic sql problem

leges ORA-06512: at "COMMADM.CT_REFRESH_PK", line 415 ORA-06512: at line 1   This line 415 is the execute immediate line.   Any clues why this is acting strangely.   Thanks in advance for your time in answering to my query     With Warm Regards Siddharth Haldankar Z

RE: Refresh option for Materialized view , want to use it during refresh - for Arup

Hi Arup,   Really appreciate for taking out time for answering to my query.   Thanks a ton for your solution. It fits perfectly for my problem.   Thanks once again   With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore

Refresh option for Materialized view , want to use it during refresh

#x27;,'NONORD')   Please note that the tables referenced are remote tables and Oracle Apps tables and not logging on it is possible. Please suggest an appropriate refresh mechanism to see the records even during refresh period.   Thanks in advance.   With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) #  : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]  

RE: Problem in dropping Materialized View

Hitchman Thanks a ton, Yes it is a bug. With Warm Regards _ Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- Hitchman, Peter Sent: Friday, October 17, 2003 3:04 PM To: Multiple

Problem in dropping Materialized View

obal_name AND   msi.auto_created_config_flag = 'N' AND   msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG SUB','FEATURE PACK','PRODUCT LIST>$0','PTO MODEL','SPARE') and   msi.inventory_item

RE: (long and boring) converting long to lob - the easiest and fastest way ?

Thanks a lot Tanel and GovindanK for answering to my query.     With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. #  : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: converting long to lob - the easiest and fastest way ?

One more thing my database is 8.1.7, think this alter table modify from long to clob is 9i feature   With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. #  : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From

RE: converting long to lob - the easiest and fastest way ?

Thanks Tanel,   But to_lob does not work in update clause, it only works in select clause, that is the restriction it has.   With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. #  : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED

converting long to lob - the easiest and fastest way ?

Hi Gurus,   How do I convert a long datatype to clob datatype. Say Table A No        number Col1     long Would like to convert to Table A No    number Col1  clob   Alter table A modify (col1 clob); Gives an error as inco

RE: How to Lock and unlock a table until SP completes

   EXCLUSIVE MODE    After mode you can put an additional clause of NOWAIT depending upon your need, like LOCK TABLE table IN EXCLUSIVE MODE NOWAIT   After you issue a commit on this table, the lock would be released.   Hope this helps.   With Warm Regards Siddharth

RE: Run Forms 9i

.   With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. #  : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Indy Johal Sent: Thursday, July 31, 2003 8:14 PM To

Run Forms 9i

erid=SCOTT/TIG [EMAIL PROTECTED]&buffer_records=NO&debug_messages=YES&array=YES&query_only=NO&qu iet=NO&RENDER=YES but it gives page not displayed. Do we need to set any parameters? Please advice. Thanks in advance. - Siddharth Haldankar -- Please see the

unlocking objects >

Title: RE: are fast refreshes really fast? Hi Gurus,   One of my object is locked. How do I unlock that object explicitly ? The session is already killed, but still the object appears in locked status.   Thanks in advance   With Warm Regards Siddharth Haldankar Cisco