RE: Creating sequences on the DUAL table?
Cherie, If you push F1 key from SqlPlus there will be a complete explanation called 'all about sequences and how to create them on dual table'. -Original Message- Sent: Tuesday, July 30, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Dan, Haven't heard the why yet but I think it may be just a poorly worded request. I suspect he wants the sequences created on another table and just wants to be able to select from dual. Maybe he never realized that the sequences were actually created on another table.Maybe he actually thought that the sequences were created on the DUAL table since he only ever used them by selecting from DUAL. Our developers run quite a wide gamut and I don't work very regularly with this one so it's hard to know where he's coming from. Still trying to get him on the phone. Thanks for this info about performance on DUAL. I will pass the info on. Thanks to everyone for getting us all on the same page. I'm sure that once I talk this out with him, it'll be straightened out quickly. Cherie Fink, Dan Dan.Fink@mdx. To: '[EMAIL PROTECTED]' [EMAIL PROTECTED], com '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc: 07/30/02 12:46 Subject: RE: Creating sequences on the DUAL table? PM Cherie, My first response is 'WHY?'. Do they mean that they want to create 2 new sequences and use the DUAL table to retrieve the values? It will cause performance problems and there are better solutions. I have some information on the performance implications of DUAL at http://www.optimaldba.com/internals/oraint_dual.html. Dan Fink -Original Message- Sent: Tuesday, July 30, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I have a request from one of our developers to create two new sequences on the DUAL table. This seems like a bad idea to me. I've never had such a request in the past. I asked for clarification on why this is needed and I didn't get a lot of details yet. Is this something that is standard operating procedure? My understanding that interfacing with the DUAL table is usually inviting poor performance. Plus, I don't like to mess around with system tables, in general. Under what circumstances would it be justified to create sequences on the DUAL table? Should I just flat-out refuse this request and if so, why? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska 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: How can I check the time when any table is updated under a sc
It is common situation. He/she is probably a GUI developer. Most front end
developers are not too familiar with dba tables.
Mandal, you can do run this query next time you have a similar queston:
1 select column_name, comments
2 from dba_col_comments
3 where table_name='DBA_OBJECTS'
4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED')
SQL /
COLUMN_NAME COMMENTS
---
---
CREATED Timestamp for the creation of the object
LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and
REVOKE) to the object
TIMESTAMP Timestamp for the specification of the object
Look for more help on TIMESTAMP column, if it is not what you are looking
for and there are only a few tables you need information about, may be
creating trigger would help.
SQL -Original Message-
Sent: Tuesday, July 23, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
I am surprised that the developer doesn't know the code s/he
wrote/maintains.
g
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
--- Mandal, Ashoke [EMAIL PROTECTED] wrote:
Hi,
One of my developer wants to know what are the tables or any other
objects being modified during the execution of his application.
dba_objects have following 3 date fields. But I am not sure if any of
these date fields will capture the last DML(update, insert or delete)
time.
CREATED
LAST_DDL_TIME
TIMESTAMP
Any idea?
Thanks in advance,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyuda Hoska
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: How can I check the time when any table is updated under a sc
Ops, I misread the statement:
during the execution of HIS application.
WOW... I would not let that developer to mess with dba tables...
-Original Message-
Sent: Tuesday, July 23, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
It is common situation. He/she is probably a GUI developer. Most front end
developers are not too familiar with dba tables.
Mandal, you can do run this query next time you have a similar queston:
1 select column_name, comments
2 from dba_col_comments
3 where table_name='DBA_OBJECTS'
4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED')
SQL /
COLUMN_NAME COMMENTS
---
---
CREATED Timestamp for the creation of the object
LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and
REVOKE) to the object
TIMESTAMP Timestamp for the specification of the object
Look for more help on TIMESTAMP column, if it is not what you are looking
for and there are only a few tables you need information about, may be
creating trigger would help.
SQL -Original Message-
Sent: Tuesday, July 23, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
I am surprised that the developer doesn't know the code s/he
wrote/maintains.
g
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
--- Mandal, Ashoke [EMAIL PROTECTED] wrote:
Hi,
One of my developer wants to know what are the tables or any other
objects being modified during the execution of his application.
dba_objects have following 3 date fields. But I am not sure if any of
these date fields will capture the last DML(update, insert or delete)
time.
CREATED
LAST_DDL_TIME
TIMESTAMP
Any idea?
Thanks in advance,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyuda Hoska
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: Lyuda Hoska
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: Had to get this off my chest
What are you upset about? He/his boss don't understand what you are talking about until he/they see pictures. Talk like you are talking to a five-year old... :) -Original Message- Sent: Tuesday, July 23, 2002 2:45 PM To: Multiple recipients of list ORACLE-L We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Lyuda Hoska 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: How to notify the password expiration in oracle?
Not sure it would be the best but... logically I would: 1. get sysdate 2. get expiration date 3. if expiration date - sysdate = 7 (let's say you wanted to warn them 7 days in advance) send them e-mail. I have not done e-mail from Oracle but there are plenty examples everywhere. Or, I think you could create a screen in your app. and display that screen for them any time they get close to expiration date. You can even let them change their password through that screen, too. -Original Message- Sent: Monday, July 22, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Greetings, As I understand that from Oracle 8 onward we have the feature of password management like account locking, password aging and expiration, password history and password complexity requirements. My understanding is that if the password is expired for an user then that user will be notified during his first attempt to login to the oracle database. Instead of waiting for the user to login and then know about his password expiration, we are trying to find out a way by which the oracle can automatically send an email to the respective user as it is close to the password expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Lyuda Hoska 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).
external authentication
Does anyone here have experience working with database that supports external authentication application users? My question is how would application know which database to connect to if there are multiple databases on the server? Does it have to be hard-coded in application? Thank you.
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
I think that test includes a polygraph exam. :-| -Original Message- Sent: Wednesday, June 26, 2002 11:16 PM To: Multiple recipients of list ORACLE-L That's what I was wondering too! Are there any Cram books for this one? Wonder if Oracle would offer that test too... some day ;-)) After OCM, they may need something new :)) -Original Message- Sent: Wednesday, June 26, 2002 10:34 PM To: Multiple recipients of list ORACLE-L Where can I take the Top Secret clearance certification exam At 03:53 PM 6/26/2002 -0800, you wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Lyuda Hoska 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: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
What do you think considered frequent job changes? Every 2 years, year, 6 months? -Original Message- Sent: Wednesday, June 26, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Position: Oracle DBA with Top Secret SCI Clearance (Please do not send your resume unless you have the required clearance) Location: Dayton, Ohio Salary Range: Depends on experience. Relocation Assistance is provided. PLEASE DO NOT send your resume for this position UNLESS you have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. Responsibilities/Requirements: Installation and maintenance of an Oracle database. Perform DBA duties for various projects within the company. Perform design, modeling and implementation of a data warehouse with data marts, including writing SQL scripts and stored procedures and using ETL tools. Will use Oracle products, utilities and third party tools. Familiarity with Unix and Windows system administration is required. Must also be capable of installing and configuring related applications and utilities. Experience/Education: Candidates should possess a Bachelors degree in Computer Science or equivalent field. Requires a minimum of 4 years experience using Oracle products and SQL scripting experience. -Must have an active or recently deactivated TS SCI Clearance For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Dayton TS DBA/Mike ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Lyuda Hoska 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: the ora certified masters cert, yet again
. Good investment, easy money, instant credibility to many hiring managers. jack silvey On 19 Jun 2002 at 4:38, Ron Rogers wrote: Date sent: Wed, 19 Jun 2002 04:38:18 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] It seems that our list has made mention in this report from Searchdatabase.com. And Oracle is trying to justify the $2000 expence. If I read this correct the $2000 is for 9i OCP. === LEAD STORY ORACLE FUELS CERTIFICATION CONTROVERSY | SearchDatabase Oracle has a new requirement for its potential certified professionals, and the price tag is about $2,000. Many DBAs aren't happy about the new policy but Oracle says the class makes their certification more valuable than ever. Read the details of the new mandate, and what DBAs and industry experts have to say about it. For the full details, click: http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht ml ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists === message truncated === __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Grabowy, Chris 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: Lyuda Hoska 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).
ocp exam/when?
Does anyone know at what point you need to take that class for $2000? Is it required even before you take your first exam or sometime alone the process? Thank you.
RE: AW: off topic: anyone form Amsterdam, Holland / other major e
Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Lyuda Hoska 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: AW: off topic: anyone form Amsterdam, Holland / other major e
It could have happened in America, too. All depends on the area. -Original Message- Sent: Tuesday, June 11, 2002 1:13 PM To: Multiple recipients of list ORACLE-L I had a friend who mistakenly left her purse on a bus stop bench somewhere in Switzerland (I'm not sure of the city). By the time she'd realized it and gotten back to the bus stop, 4 hours had passed. Her purse was still there, with everything and all the money still in it. Cheers!, JoJo -Original Message- Sent: Tuesday, June 11, 2002 10:39 AM To: Multiple recipients of list ORACLE-L e You're in for a surprise Rachel, The Swiss are well known jokers. Switzerland is often called the prank capital of Europe. Ladies toilets are labelled Gentlemen. Gentlemen's toilets are labelled Kodak moment photo opportunity. Cars drive on the left side of the road except for blue cars wich must drive on the left. Dogs and cats are, by convention, dyed red during the summer. BTW I lost my sunglasses in Switzerland in 1994 so if anyone found them can they get in touch. Mike PS You can probably tell that I'm between coffees right now. -Original Message- Sent: 11 June 2002 17:29 To: Multiple recipients of list ORACLE-L europ If you don't know local conventions ANYWHERE, you will be surprised however, now I'm curious. just what happens? --- Jan Pruner [EMAIL PROTECTED] wrote: Nicht nur in Zurich. No, they aren't. But if you don't know conventions in Switzerland you will be surprised. :-) JP This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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: JoJo Al-Zawawi 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: Lyuda Hoska 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: AW: off topic: anyone form Amsterdam, Holland / other major e
] 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Lyuda Hoska 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).
FW: DECODE HELP
Something like this would work. SELECT GREATEST(FIRST_DATE, NVL(SEC_DATE,THIRD_DATE),NVL(THIRD_DATE,SEC_DATE)) FROM your_table; Just an idea, you can explore it further.. -Original Message- Sent: Monday, May 20, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001 05/21/2001 JO001620L12/27/2000 05/16/2001 The first_date, sec_date and third_date may or may not exist; either one of the dates will be there. I need to come up with another column LATEST_DATE which will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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: Lyuda Hoska 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).
oracle graphics
Hi, I need to get a feeling for how Oracle graphics work. If someone can point me right direction I would appreciate it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska 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: Use of Orastaff
One thing I've noticed.. their positions always for local candidates only.. no relocation assistance.. -Original Message- Sent: Wednesday, March 20, 2002 1:21 PM To: Multiple recipients of list ORACLE-L I have tried 4 times to contact them over the last several years. All for jobs, skill sets, and locations that matched my personal profile. I have never even received a we received you email reply. Looks like a good quality organization to meNOT Brian P. MacLean Oracle DBA, OCP8i Donald Bricker To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.il.usSubject: Use of Orastaff Sent by: [EMAIL PROTECTED] m 03/20/02 10:18 AM Please respond to ORACLE-L I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you get interviews? Did you obtain a position? etc Thanks Don Bricker Database Administrator / System Administrator Illinois Environmental Protection Agency 1021 North Grand Avenue East Mail Code #32 Springfield, IL 62794-9276 [EMAIL PROTECTED] (217) 558-2290 -- 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: Lyuda Hoska 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: SPAM?? RE: Looking for a Web Application Development Suite???
I think we all need to send it back to [EMAIL PROTECTED] (that is where it came from). I sent mine there. If they overloading my mailbox with junk, I'll do the same to their. -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SPAM?? RE: Looking for a Web Application Development Suite??? Well on that note, let me forward the spam to you...anyone else want a copy of this garbage? -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 1:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SPAM?? RE: Looking for a Web Application Development Suite??? No, but thanks to your quoting it, we are all much happier now. -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 11:39 AMTo: Multiple recipients of list ORACLE-LSubject: SPAM?? RE: Looking for a Web Application Development Suite??? Did everyone get this spamming email?? -Original Message-From: Runner Technologies Human Resources [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 10:43 AMTo: Multiple recipients of list ORACLE-LSubject: Looking for a Web Application Development Suite??? Wouldn't it be great to build Oracle Web Enabled Applications directly in your browser with minimal skills??? Check out ORBIT, a web application development suite created by Runner Technologies. It is the most flexible and easiest way to build full featured web applications and reports. Sign up for a 30 Day FREE Trial at www.RunnerTechnologies.com.
lower case data
Anyone has an idea how to check all tables and all columns in the database and find if there is any data entered in lower case. Note: no correction needs to be applied.. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska 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: lower case data
Thank you Stephane. I am not as lucky as you. I don't work on Unix... i used to and i miss it. my os is NT. i ended up writing a query.. if someone has a better idea please let me know... p.s. hope this thread is not going to turn into one of the 'regular' topics: why unix is better. we all know that! :-) -Original Message- Sent: Thursday, March 14, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Lyuda Hoska wrote: Anyone has an idea how to check all tables and all columns in the database and find if there is any data entered in lower case. Note: no correction needs to be applied.. Thank you. Rather that the query of death, I'd export everything and work on the .dmp file with Unix tools. Oracle stuff is in uppercase, normally, the only lowercase characters you may find apart from data is in the text of stored objects (views, packages). Finding out *where* exactly the lowercase characters are located is likely to be a bit difficult, though. But I could probably do it with awk, as others (before I get flamed ;-)) could do it with perl. -- 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: Lyuda Hoska 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: Fav. Urban Legend...
1)they'll be a code to generate a code to generate a code to generate a code, and there'll be self-maintening databases, too. no developers and dba's will be needed. :-0 2)Y2K was turned out to be a myth, too. -Original Message- Sent: Wednesday, March 13, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Bigger is better. This is the best biggest myth. Say that fast 3 times. :-) -Original Message- Sent: Wednesday, March 13, 2002 5:18 AM To: Multiple recipients of list ORACLE-L That as Oracle software becomes larger, fewer DBAs are required. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 13, 2002 12:28 AM To: Multiple recipients of list ORACLE-L Subject:Re: Fav. Urban Legend... oh man, mine has to be what is probably Jeremiah's as well: the myth that Oracle doesn't write to the database files when you are in hot backup mode --- Freeman, Robert [EMAIL PROTECTED] wrote: I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I thought I'd ask here, before I put the presentation to bed, what your favorite (or the one you find the most irritating) Oracle Urban legend was RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Boivin, Patrice J 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: Orr, Steve 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: Lyuda Hoska 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
RE: Fav. Urban Legend...
do u have a link to that site? -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Fav. Urban Legend... Reading it right now. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 13, 2002 11:28 AM Subject: RE: Fav. Urban Legend... Hey Guys, Did anyone have a look at Gaja's new paper on myths and folklore about Oracle at Craig Shallahamer's site? Wonderful reading. Raj Hallas John [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/13/2002 06:28 AM PSTPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc: bcc: Subject: RE: Fav. Urban Legend... Patrice, Given the current state of the job market I am not sure if this is myth or fact John -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 12:18 To: Multiple recipients of list ORACLE-L Subject: RE: Fav. Urban Legend... That as Oracle software becomes larger, fewer DBAs are required. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 13, 2002 12:28 AM To: Multiple recipients of list ORACLE-L Subject: Re: Fav. Urban Legend... oh man, mine has to be what is probably Jeremiah's as well: the myth that Oracle doesn't write to the database files when you are in hot backup mode --- "Freeman, Robert " [EMAIL PROTECTED] wrote: I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I thought I'd ask here, before I put the presentation to bed, what your favorite (or the one you find the most irritating) Oracle Urban legend was RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Boivin, Patrice J 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 electronic message contains
RE: Fav. Urban Legend...
i thought this list has an active filter applied and it supposed to filter everything with a word 'manager' out. i guess it broke... or may be there are people on the exception list... :-) nothing personal...just a joke.. -Original Message-From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Fav. Urban Legend... Yes. Gaja will be presenting at our Detroit Oracle User Group meeting tomorrow. Come one Come all. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002 2:44 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Fav. Urban Legend... Also, tomorrow, I'll hear it from the "horse's mouth" (am I using the right wording?). Gaja will be presenting at DOUG spring conference. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 13, 2002 12:23 PM Subject: Re: Fav. Urban Legend... Reading it right now. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 13, 2002 11:28 AM Subject: RE: Fav. Urban Legend... Hey Guys, Did anyone have a look at Gaja's new paper on myths and folklore about Oracle at Craig Shallahamer's site? Wonderful reading. Raj Hallas John [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/13/2002 06:28 AM PSTPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc: bcc: Subject: RE: Fav. Urban Legend... Patrice, Given the current state of the job market I am not sure if this is myth or fact John -Original Message- style='color:blue'mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 12:18 To: Multiple recipients of list ORACLE-L color=black That as Oracle software becomes larger, fewer DBAs are required. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 13, 2002 12:28 AM To: Multiple recipients of list ORACLE-L Subject: Re: Fav. Urban Legend... oh man, mine has to be what is probably Jeremiah's as well: the myth that Oracle doesn't write to the database files when you are in hot backup mode --- "Freeman, Robert " [EMAIL PROTECTED] wrote: I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I thought I'd ask here, before I put the presentation to bed, what your favorite (or the one you find the most irritating) Oracle Urban legend was RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
RE: PL/SQL equivalent of pause
this may help you: dbms_lock.sleep -Original Message- Sent: Wednesday, March 13, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Anyone know how to have a PL/SQL program (anonymous block) pause, either indefinately or for a specified amount of time (x seconds)? THere's a proc in DBMS_LOCK, I know . . . but that suspends processing -- not exactly the same as Pausing it. thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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: Lyuda Hoska 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: cursor not closing
common developers problem. they forget to close it in powerbuilder, too. -Original Message- Sent: Friday, March 08, 2002 5:08 PM To: Multiple recipients of list ORACLE-L Java surely allows you to close the statement, ask your developers to do that. I told mine, and they are happy with it. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, March 08, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Hi, We have a Application that user JDBC thin client connecting to Oracle database. It seems like java code is opening the cursor , running some sql but not closing the cusrsor. Now the number of open_cursor reached 3568 . Is there any way we can close cursor from sqlplus. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Lyuda Hoska 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).
