RE: SQLplus question unusual behavior
Possibly a FGAC policy with the UPDATE_CHECK flag set to FALSE. This would allow the current user to insert rows, but not necessarily view them. Are you connected to SQL*Plus as the table owner or a subordinate user? Check in the USER / DBA_POLICIES view where the OBJECT_NAME='FACILITY' -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: 20 January 2003 15:31To: Multiple recipients of list ORACLE-LSubject: SQLplus question unusual behavior I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - howeverthat doesn't really happen. Am I suffering from a severe lack of caffine oris this really odd? SQL select count(*) from facility; COUNT(*)-- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*)-- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*)-- 0 -- This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message. Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT.
Re: SQLplus question unusual behavior
Sony, In my post I mentioned that there could be two tables named facility (note the lowercase) and FACILITY. They can be created and then the data dictionary will have two tables. For Oracle they are two different names, not the same. However, I believe the diagnosis by Harvey Neil, that there could be a FGAC policy on the table is the correct one. John, could you let us know if that was the problem, please. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 20, 2003 10:38 PM If it is possible, how could two tables have the same name and structure in one tablespace ? I think you should check your data dictionary or your program documentation. Hope this helps. Rgrds, Sony -Original Message- From: Arup Nanda [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: SQLplus question unusual behavior Check if there are two taables named FACILTY in your database. As SYS, check SELECT OWNER, Object_name, Object_type FROM DBA_OBJECTS WHERE UPPER(OBJECT_NAME) = 'FACILITY' Note the use of upper(). Someone might have defined the table in lowercase using quotes. CREATE TABLE FACILITY is not the same as CREATE TABLE facility. HTH. Arup From: John Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 07:30:45 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: John Shaw [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D] I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- 0 _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: Sony kristanto 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL
RE: SQLplus question unusual behavior
although I am using fgac - I am exempt from the policy. [EMAIL PROTECTED] 01/21/03 02:49AM Possibly a FGAC policy with the UPDATE_CHECK flag set to FALSE. This would allow the current user to insert rows, but not necessarily view them. Are you connected to SQL*Plus as the table owner or a subordinate user? Check in the USER / DBA_POLICIES view where the OBJECT_NAME='FACILITY' -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: 20 January 2003 15:31To: Multiple recipients of list ORACLE-LSubject: SQLplus question unusual behavior I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - howeverthat doesn't really happen. Am I suffering from a severe lack of caffine oris this really odd? SQL select count(*) from facility; COUNT(*)-- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*)-- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*)-- 0--This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message.Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT.
Re: SQLplus question unusual behavior
I bounced the databases and just like rebooting a pc (even though this db is on solaris) it started working - one of the mysteries of Oracle - Maybe it was really windy and it was having sympathy pains with the yacht. [EMAIL PROTECTED] 01/20/03 08:44PM John Shaw wrote: I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility;1. FGAC? Connect as sys and check.2. Could you please show explain plan?3. What's in the trace file?-- Vladimir BegunThe statements and opinions expressed here are my own anddo not necessarily represent those of Oracle Corporation.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Vladimir Begun INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: SQLplus question unusual behavior
John Shaw wrote: I bounced the databases and just like rebooting a pc (even though this db is on solaris) it started working - one of the mysteries of Oracle - Maybe it was really windy and it was having sympathy pains with the yacht. Dunno, I think the policy was enabled, all myths and mysteries are in our minds, a piece of software is either working or getting glitches. The rule: never reboot anything (your car is included :) unless you know the root of the original problem. :) Regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: SQLplus question unusual behavior
Just a thought - is facility a table or is it some synonym/view pointing somewhere else.. Babu |-+--- | | John Shaw | | | John.Shaw@correctio| | | nscorp.com | | | Sent by:| | | [EMAIL PROTECTED]| | | | | | | | | 01/20/03 10:30 AM | | | Please respond to | | | ORACLE-L| | | | |-+--- ---| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: SQLplus question unusual behavior | ---| I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- 0 _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: SQLplus question unusual behavior
Check if there are two taables named FACILTY in your database. As SYS, check SELECT OWNER, Object_name, Object_type FROM DBA_OBJECTS WHERE UPPER(OBJECT_NAME) = 'FACILITY' Note the use of upper(). Someone might have defined the table in lowercase using quotes. CREATE TABLE FACILITY is not the same as CREATE TABLE facility. HTH. Arup From: John Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 07:30:45 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: John Shaw [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D] I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- 0 _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: SQLplus question unusual behavior
It's a table. [EMAIL PROTECTED] 01/20/03 11:04AM Just a thought - is facility a table or is it some synonym/view pointingsomewhere else..Babu|-+---| | John Shaw || | John.Shaw@correctio|| | nscorp.com || | Sent by: || | [EMAIL PROTECTED] || | || | || | 01/20/03 10:30 AM || | Please respond to || | ORACLE-L || | ||-+--- ---| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: SQLplus question unusual behavior | ---|I am trying to update a small table from a remote table with sqlplus9.2.0.2 .It seems to indicate that it has inserted 233 row into my local table -however that doesn't really happen.Am I suffering from a severe lack of caffine or is this really odd?SQL select count(*) from facility; COUNT(*)-- 0SQL insert into facility (select * from facility@dev);233 rows created.SQL select count(*) from facility; COUNT(*)-- 0SQL commit;Commit complete.SQL select count(*) from facility; COUNT(*)-- 0_This e-mail transmission and any attachments to it are intended solely forthe use of the individual or entity to whom it is addressed and may containconfidential and privileged information. If you are not the intendedrecipient, your use, forwarding, printing, storing, disseminating,distribution, or copying of this communication is prohibited. If youreceived this communication in error, please notify the sender immediatelyby replying to this message and delete it from your computer.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: SQLplus question unusual behavior
I wish it was -but that's not the case here. [EMAIL PROTECTED] 01/20/03 11:19AM Check if there are two taables named FACILTY in your database.As SYS, checkSELECT OWNER, Object_name, Object_typeFROM DBA_OBJECTSWHERE UPPER(OBJECT_NAME) = 'FACILITY'Note the use of upper(). Someone might have defined the table in lowercase using quotes.CREATE TABLE FACILITY is not the same as CREATE TABLE "facility".HTH.ArupFrom: "John Shaw" [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: SQLplus question unusual behaviorDate: Mon, 20 Jan 2003 07:30:45 -0800MIME-Version: 1.0Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST)Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800Message-ID: [EMAIL PROTECTED]X-Comment: Oracle RDBMS Community ForumX-Sender: "John Shaw" [EMAIL PROTECTED]Sender: [EMAIL PROTECTED]Errors-To: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, CaliforniaX-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. BergmanPrecedence: bulkReturn-Path: [EMAIL PROTECTED]X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D]I am trying to update a small table from a remote table with sqlplus 9.2.0.2 .It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen.Am I suffering from a severe lack of caffine or is this really odd?SQL select count(*) from facility; COUNT(*)-- 0SQL insert into facility (select * from facility@dev);233 rows created.SQL select count(*) from facility; COUNT(*)-- 0SQL commit;Commit complete.SQL select count(*) from facility; COUNT(*)-- 0_STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Arup Nanda INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: SQLplus question unusual behavior
Arup, How about select * instead of select count... Maybe the data is there but something is wrong with sql*plus set up (numwidth) so that you don't see the count. ( I know that sounds stranger than the original question, but from the query you posted it looks like the count(*) is null which can't be...) John Shaw [EMAIL PROTECTED]@fatcity.com on 01/20/2003 03:39:43 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I wish it was - but that's not the case here. [EMAIL PROTECTED] 01/20/03 11:19AM Check if there are two taables named FACILTY in your database. As SYS, check SELECT OWNER, Object_name, Object_type FROM DBA_OBJECTS WHERE UPPER(OBJECT_NAME) = 'FACILITY' Note the use of upper(). Someone might have defined the table in lowercase using quotes. CREATE TABLE FACILITY is not the same as CREATE TABLE facility. HTH. Arup From: John Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 07:30:45 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: John Shaw [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D] I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: SQLplus question unusual behavior
Chaim, It was posted by John Shaw. And the figures showed 0 (not null) in the original posting. Arup From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 13:23:54 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc5-f3.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 13:42:42 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA55682;Mon, 20 Jan 2003 13:40:58 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00535247; Mon, 20 Jan 2003 13:23:54 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 21:42:42.0304 (UTC) FILETIME=[DC619800:01C2C0CC] Arup, How about select * instead of select count... Maybe the data is there but something is wrong with sql*plus set up (numwidth) so that you don't see the count. ( I know that sounds stranger than the original question, but from the query you posted it looks like the count(*) is null which can't be...) John Shaw [EMAIL PROTECTED]@fatcity.com on 01/20/2003 03:39:43 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I wish it was - but that's not the case here. [EMAIL PROTECTED] 01/20/03 11:19AM Check if there are two taables named FACILTY in your database. As SYS, check SELECT OWNER, Object_name, Object_type FROM DBA_OBJECTS WHERE UPPER(OBJECT_NAME) = 'FACILITY' Note the use of upper(). Someone might have defined the table in lowercase using quotes. CREATE TABLE FACILITY is not the same as CREATE TABLE facility. HTH. Arup From: John Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 07:30:45 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: John Shaw [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D] I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
Re: SQLplus question unusual behavior
John Shaw wrote: I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; 1. FGAC? Connect as sys and check. 2. Could you please show explain plan? 3. What's in the trace file? -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: SQLplus question unusual behavior
If it is possible, how could two tables have the same name and structure in one tablespace ? I think you should check your data dictionary or your program documentation. Hope this helps. Rgrds, Sony -Original Message- From: Arup Nanda [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: SQLplus question unusual behavior Check if there are two taables named FACILTY in your database. As SYS, check SELECT OWNER, Object_name, Object_type FROM DBA_OBJECTS WHERE UPPER(OBJECT_NAME) = 'FACILITY' Note the use of upper(). Someone might have defined the table in lowercase using quotes. CREATE TABLE FACILITY is not the same as CREATE TABLE facility. HTH. Arup From: John Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 07:30:45 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: John Shaw [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D] I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- 0 _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: Sony kristanto 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: SQLplus question unusual behavior
in one tablespace? I think you mean in one schema. -Original Message- Sent: Monday, January 20, 2003 10:39 PM To: Multiple recipients of list ORACLE-L If it is possible, how could two tables have the same name and structure in one tablespace ? I think you should check your data dictionary or your program documentation. Hope this helps. Rgrds, Sony -Original Message- From: Arup Nanda [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: SQLplus question unusual behavior Check if there are two taables named FACILTY in your database. As SYS, check SELECT OWNER, Object_name, Object_type FROM DBA_OBJECTS WHERE UPPER(OBJECT_NAME) = 'FACILITY' Note the use of upper(). Someone might have defined the table in lowercase using quotes. CREATE TABLE FACILITY is not the same as CREATE TABLE facility. HTH. Arup From: John Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLplus question unusual behavior Date: Mon, 20 Jan 2003 07:30:45 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 2003 08:01:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 07:30:45 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: John Shaw [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) FILETIME=[40E1BF10:01C2C09D] I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- 0 _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: Sony kristanto 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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: Richard Ji 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Title: RE: sqlplus question SQLPlus outputs data in columns based on their Maximum length or the COLUMN format set in SQLPlus. Value of SQLPlus COLUMN attribute takes precedence. Even when you do a substr() based on length, SQLPlusdoesn't calculate the length of the maximum length value and format columns accordingly. It still looks at the column width until or unless u substring to a constant value like substr(column_name, 1, 10) Thebest way is to select the columns themselves concatenated with the column separatore.g SELECT col_1 || ',' || col_2 etc. If any of the columns is a CHAR column then you'll have to use trim() or ltrim(rtrim()) depending upon the oracle version regards naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, September 20, 2002 4:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: sqlplus question Use rtrim and ltrim are you sure data was loaded with spaces? -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus question Tried this. The field length is still 56. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 6:43 PM select substr(ename,1,length(ename)), job from emp; From: "Bob Metelsky" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sqlplus question Date: Thu, 19 Sep 2002 08:18:51 -0800 I am spooling my sqlplus output to a file with noheadings and all the fields separated by a delimiter. I havea field that is defined as varchar2(56), but typically only 4or 5 bytes are filled. Oracle recognizes that and if youselect length(fld1) from the table, you will get 4. But if Ispool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes sothat my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo offrecsep off feedback off heading off trimspool on colsep "|" Sounds to me like the trimspool should do it...Are you sure its set onME@DB1 - trimspool on SP2-0734: unknown command beginning "trimspool ..." - rest of line ignored. Try set trims on Or Set trimspool on bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Yechiel Adar 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
The only method I know of is to concatenate the fields together in one column. If there is a way to have variable sized SQL*Plus column formatting, I'd love to see it...seriously...it would be cool. Until then... 1 select substr(ename,1,length(rtrim(ename))), job 2* from emp SQL / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER MARTIN|SALESMAN SQL edit Wrote file afiedt.buf 1 select substr(ename,1,length(rtrim(ename)))||'|'||job 2* from emp SQL / SMITH|CLERK ALLEN|SALESMAN WARD|SALESMAN JONES|MANAGER MARTIN|SALESMAN -Original Message- Sent: Thursday, September 19, 2002 8:51 AM To: Fink, Dan; [EMAIL PROTECTED] I don't want just 4. It's variable length and I want the actual number of valid bytes. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
If you want only 4 bytes, us the SUBSTR function to take only what you need. SQL select ename, job 2 from emp; SMITH CLERK ALLEN SALESMAN WARD SALESMAN JONES MANAGER SQL set colsep '|' SQL / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER SQL select substr(ename,1,4), job 2 from emp; SMIT|CLERK ALLE|SALESMAN WARD|SALESMAN JONE|MANAGER -Original Message- Sent: Thursday, September 19, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Howdy, I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Fink, Dan 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
I don't want just 4. It's variable length and I want the actual number of valid bytes. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 9:51 AM To: '[EMAIL PROTECTED]'; Carle, William T (Bill), ALCAS Subject:RE: sqlplus question If you want only 4 bytes, us the SUBSTR function to take only what you need. SQL select ename, job 2 from emp; SMITH CLERK ALLEN SALESMAN WARD SALESMAN JONES MANAGER SQL set colsep '|' SQL / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER SQL select substr(ename,1,4), job 2 from emp; SMIT|CLERK ALLE|SALESMAN WARD|SALESMAN JONE|MANAGER -Original Message- Sent: Thursday, September 19, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Howdy, I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Carle, William T (Bill), ALCAS 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Bill couldn't you just concatenate the fields together with your delimiter between. e.g. select fld1||'|'||fld2||'|'||fld3 I think the trimspool is just trailing blanks so unless you made that the last field output you'll get this behaviour. Iain Nicoll -Original Message- Sent: Thursday, September 19, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Howdy, I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Nicoll, Iain \(Calanais\) 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | I see using the statement on one line sets all on or off Show trims Sounds like your column is getting padded with empty bytes ??? Dispite lentght reporting the actual data You might have to trim it yourself ?? bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Sounds to me like the trimspool should do it... Are you sure its set on ME@DB1 - trimspool on SP2-0734: unknown command beginning trimspool ... - rest of line ignored. Try set trims on Or Set trimspool on bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
select substr(ename,1,length(ename)), job from emp; From: Bob Metelsky [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sqlplus question Date: Thu, 19 Sep 2002 08:18:51 -0800 I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Sounds to me like the trimspool should do it... Are you sure its set on ME@DB1 - trimspool on SP2-0734: unknown command beginning trimspool ... - rest of line ignored. Try set trims on Or Set trimspool on bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Instead of using colsep, try this: select ename||'|'||job from emp; I was going to suggest - col emp form a4 but if it can be more than 4 positions, it will wrap. Jay [EMAIL PROTECTED] 09/19/02 11:53AM I don't want just 4. It's variable length and I want the actual number of valid bytes. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 9:51 AM To: '[EMAIL PROTECTED]'; Carle, William T (Bill), ALCAS Subject:RE: sqlplus question If you want only 4 bytes, us the SUBSTR function to take only what you need. SQL select ename, job 2 from emp; SMITH CLERK ALLEN SALESMAN WARD SALESMAN JONES MANAGER SQL set colsep '|' SQL / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER SQL select substr(ename,1,4), job 2 from emp; SMIT|CLERK ALLE|SALESMAN WARD|SALESMAN JONE|MANAGER -Original Message- Sent: Thursday, September 19, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Howdy, I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
set Trimspool on will only trim the empty spaces at the end of each line. The only way i know to trim in between the lines is to concatenate all the columns SELECT column_1 || '|' || column_2. FROM . Naveen -Original Message- Sent: Thursday, September 19, 2002 9:49 PM To: Multiple recipients of list ORACLE-L I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Sounds to me like the trimspool should do it... Are you sure its set on ME@DB1 - trimspool on SP2-0734: unknown command beginning trimspool ... - rest of line ignored. Try set trims on Or Set trimspool on bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Naveen Nahata 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question
Tried this. The field length is still 56. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 6:43 PM select substr(ename,1,length(ename)), job from emp; From: Bob Metelsky [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sqlplus question Date: Thu, 19 Sep 2002 08:18:51 -0800 I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Sounds to me like the trimspool should do it... Are you sure its set on ME@DB1 - trimspool on SP2-0734: unknown command beginning trimspool ... - rest of line ignored. Try set trims on Or Set trimspool on bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Yechiel Adar 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Title: RE: sqlplus question Use rtrim and ltrim are you sure data was loaded with spaces? -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus question Tried this. The field length is still 56. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 6:43 PM select substr(ename,1,length(ename)), job from emp; From: Bob Metelsky [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sqlplus question Date: Thu, 19 Sep 2002 08:18:51 -0800 I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. But if I spool this to a file, I always get the full 56 bytes padded with blanks. In other words, I get 4 bytes of data and 52 blanks for that field. I only want the four valid bytes so that my delimiter comes immediately after that 4th byte. My sqlplus options are as follows: set newpage 0 space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Sounds to me like the trimspool should do it... Are you sure its set on ME@DB1 - trimspool on SP2-0734: unknown command beginning trimspool ... - rest of line ignored. Try set trims on Or Set trimspool on bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Yechiel Adar 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 this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
Don't you know that Kimberly is The Lord Of The Rings. Prudo is already on his way with the Ring. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 29, 2002 8:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: sqlplus question What ring are you going to give to Kimberly? :-) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
OK, lets take poking fun at Kim back to the OT list please. Ross, I don't know how but I am going to get you back for this. -Original Message- Sent: Wednesday, January 30, 2002 4:30 AM To: Multiple recipients of list ORACLE-L Don't you know that Kimberly is The Lord Of The Rings. Prudo is already on his way with the Ring. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 29, 2002 8:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: sqlplus question What ring are you going to give to Kimberly? :-) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Kimberly Smith 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
Re: sqlplus question
And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. -Original Message- Faroult Sent: Tuesday, January 29, 2002 11:40 AM To: Multiple recipients of list ORACLE-L And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Rajesh Dayal 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
u can also create batch file if os is windows e.g. t.sql as set serveroutput on; select * from tab; exit; put this in some batch file eq bb.bat sqlplus fxsam/s@du @t and schedule bb.bat -Original Message- From: Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 11:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus question And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Ghadge,Sameer 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question
Rajesh Dayal wrote: I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. Look in the doc for the dbms_sql package. Hardly more complicated than 'execute immediate' for DDL (you declare a handler for the cursor, then it's done in two calls, parse and execute). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Thanks Stephan, Your suggestion had motivated me and I wrote the code, after RTFM. Sameer, I didn't scheduled the job on OS because this should an Oracle Job, log switching has nothing to do with OS (you don't trouble a company GM when the work should be done by a Normal Manager right??). And you need to handle the error conditions of OS when your DB is down, which is eliminated in this case. Any-way thanks to all, Rajesh And-yes, the code is like this: create or replace PROCEDURE SWITCH1 IS c number; d number; begin c := dbms_sql.open_cursor; dbms_sql.parse(c, 'alter system switch logfile', 1); d := dbms_sql.execute(c); dbms_sql.close_cursor(c); commit ; END; -Original Message- Faroult Sent: Tuesday, January 29, 2002 1:36 PM To: Multiple recipients of list ORACLE-L Rajesh Dayal wrote: I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. Look in the doc for the dbms_sql package. Hardly more complicated than 'execute immediate' for DDL (you declare a handler for the cursor, then it's done in two calls, parse and execute). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Rajesh Dayal 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: RE: sqlplus question
'dbms_output.put_job '? What the heck was this about? Please, check your answers before posting to the list! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 12:50 AM Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland Weaver, Walt [EMAIL PROTECTED]@fatcity.com den 2002-01-28 14:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Igor Neyman 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland Weaver, Walt [EMAIL PROTECTED]@fatcity.com den 2002-01-28 14:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
AFAIK, Kimberly does everything. (Except move to Dallas) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question
So true! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 10:05 AM Igor Neyman wrote: 'dbms_output.put_job '? What the heck was this about? Please, check your answers before posting to the list! Igor Neyman, OCP DBA [EMAIL PROTECTED] answers AND questions -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Igor Neyman 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: RE: sqlplus question
What ring are you going to give to Kimberly? :-) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Thanks Jared, that would be great and I did think about applying your suggestion. But there is a little detail I failed to mention. My rundays suppose to skip weekends( that is easy) and certain holidays. My OS is Windows NT. Any suggestion is greatly appreciated. -Original Message- Sent: Monday, January 28, 2002 6:09 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Yes, just run it on those days, skipping the days that you don't want it to run. ... But seriously, which platform? Unix, win32, OS/390, VMS? On unix use 'cron'. http://www.google.com/search?hl=enq=cron+tutorial On Win32 use the 'at' command: just type 'at /help' in a command window. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/02 02:21 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:sqlplus question Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Title: RE: sqlplus question -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. a) - Use the scheduling software for your OS to schedule an OS script/job. b) - Make your script into a stored procedure and use dbms_job to schedule it. c) - Run the script every day. Start your SQL*Plus script with the following statements: whenever sqlerror exit declare saturday constant pls_integer := 6 ; sunday constant pls_integer := 7 ; today pls_integer ; begin today := to_char (sysdate, 'D') ; if today = saturday or today = sunday then raise_application_error (-20001, 'Script should only run on weekday.') ; end if ; end ; /
Re: sqlplus question
Roland, No fair changing your name. UNIX cron, NT @scheduler, dbms_jobs, or a combination. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 lhoska@calibre sys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: sqlplus question om 01/28/2002 04:21 PM Please respond to ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Sure. Depending on your operating system, you can submit it through a scheduler (e.g., cron, submit, etc.). If you don't have a snazzy-dazzy scheduler, you can use as part of the where condition something like to_char(sysdate,'DAY') in ('MONDAY','WEDNESDAY','FRIDAY'); or whatever. Or you can class it up with whenevers. HTH, Bambi. -Original Message- Sent: Monday, January 28, 2002 4:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Bellows, Bambi 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question
The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Yes, just run it on those days, skipping the days that you don't want it to run. ... But seriously, which platform? Unix, win32, OS/390, VMS? On unix use 'cron'. http://www.google.com/search?hl=enq=cron+tutorial On Win32 use the 'at' command: just type 'at /help' in a command window. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/02 02:21 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:sqlplus question Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Or, if in NT, ask Jared. He has a nifty fix for AT. Or, schedule a job if you can wrap the thing as a package. -Original Message- Sent: Monday, January 28, 2002 5:45 PM To: Multiple recipients of list ORACLE-L Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Mohan, Ross 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question
Title: RE: sqlplus question -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] But there is a little detail I failed to mention. My rundays suppose to skip weekends( that is easy) and certain holidays. My OS is Windows NT. Any suggestion is greatly appreciated. Can you use dbms_job? If so, keep the list of holidays in a database table. Have the stored procedure re-submit the job at the beginning of the procedure, and skip week-ends by checking to_char (sysdate, 'D') and holidays by checking in your holiday table.
Ang: RE: sqlplus question
Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland Weaver, Walt [EMAIL PROTECTED]@fatcity.com den 2002-01-28 14:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Weaver, Walt 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question ???
Andrea Oracle wrote: Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea Yes : break on report -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question ???
Try with set pagesi 999 set linesi 100 col file_name forma a50 col bytes forma 999,999,999,999 break on dummy compute sum on dummy of bytes select file_name,bytes, null as dummy from sys.dba_data_files Also on 8.1.X with group by rollup you have another option. Regards. --- Andrea Oracle [EMAIL PROTECTED] wrote: Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question ???
you have to put break on report before compute sum Baskar -Original Message- Sent: 13 July 2001 09:50 To: Multiple recipients of list ORACLE-L Andrea Oracle wrote: Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea Yes : break on report -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Ramasamy, Baskar 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question ???
The Compute works hand in hand with the break function.Before the compute line you need to add break on report So, it should be set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 break on report compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; I ran it and it works -Original Message- Sent: Thursday, July 12, 2001 6:46 PM To: Multiple recipients of list ORACLE-L Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Kevin Lange 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question ???
Andrea: You need to ad 'break on report', as in set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report break on report == Here! select file_name, bytes from dba_data_files order by file_name; HTH, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message- Sent: Thursday, July 12, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
RE: sqlplus question ???
Add a break on report Linda -Original Message- Sent: Thursday, July 12, 2001 5:46 PM To: Multiple recipients of list ORACLE-L Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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.com -- Author: Seley, Linda 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).
Re: sqlplus question ???
Yes, there is. You'll get at least 5 replies for this, 'cause it's an easy one, but maybe I'll be first. Sum computes on breakpoints, so you have to set the sum (which you did) and also set the breakpoint (which you did not). Add break on report to the sql file. Good luck, yosi Andrea Oracle wrote: Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include 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).