RE: Renumber a set of grupped rows?
Not pretty but it should work: SQL> create or replace procedure emprec 2 is 3cursor empcursor is 4 select empno, recno from emptest order by empno for update of recno; 5v_empno number := 9; 6v_count number := 0; 7 begin 8for x in empcursor loop 9 if x.empno <> v_empno then v_count:=1; 10 v_empno := x.empno; 11 end if; 12 update emptest 13 set recno = v_count 14 where current of empcursor; 15 v_count:=v_count+1; 16end loop; 17 end emprec; 18 / Procedure created. SQL> execute emprec; PL/SQL procedure successfully completed. SQL> commit; Commit complete. SQL> drop procedure emprec; Procedure dropped. --Jeff -Original Message- Sent: Tuesday, January 20, 2004 3:24 PM To: Multiple recipients of list ORACLE-L I have a 1-rows table with 2 columns, Emp_ID and Req_ID. There are about 150 different emp_ids in these 1+ records. What I want to do is the following: For every different Emp_id, I need the Rec_ids that corresponds to it to be updated/renumbered starting from 1 and keep going up by 1. So I want it to look something like this: Emp_ID Req_ID 10001 001 10001 002 10001 003 10001 004 10001 005 10001 006 10001 007 10001 008 10002 001 10002 002 10002 003 10002 004 10002 005 10003 001 10004 001 10004 002 10004 003 10004 004 10004 005 10004 006 etc Any ideas? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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: Eberhard, Jeff 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: MS Access
You may want to look at the Oracle Migration workbench. http://otn.oracle.com/tech/migration/workbench/index.html <http://otn.oracle.com/tech/migration/workbench/index.html> I don't know if the slides are still available but there was a presentation at IOUG Live! 2002 titled "Migrating a Microsoft Access Database to Oracle -- Pain Free" by Debbie Pennell which gave a brief overview of the process. --Jeff -Original Message- Sent: Tuesday, January 20, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Thanks guys, for pointing to the right place for Access issues. Has some one got a document which you may have written for performing a conversion/migration from Access to Oracle, or for that matter any conversion. I want to look in the document, as to what issues are to be dealt with, what is the change that needs to take place in the new system, what is the actual thing in access and what is the desired effect going to be in Oracle. I know there will be different things customized for your company's case, but I want to just see how the whole document is structured, and therefore get a good idea as to what the conversion process will entail. You can write me direct at:- [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Please reply fast, as I need to see what are the different options I need to look at. Regards, Raja - Original Message - To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 12:19 AM ACCESS-L. For subscription/signoff info and archives, see http://peach.ease.lsoft.com/archives/access-l.html <http://peach.ease.lsoft.com/archives/access-l.html> . Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 618-622-4145 -Original Message- <mailto:SMTP:[EMAIL PROTECTED]> ] Hi all, I was wondering if any one out here knows if there is a good list (mailing list) for discussing MS Access problems. I am specifically looking for migrating/converting large Access database into Oracle database. I need to know what will be the steps to convert such a database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: dba interview questions
Category: Init.ora parameters points: 1000 Answer: It depends! Category: CBO points: 1000 Answer: It depends!
RE: Using ' in Update statement
Do you mean a single quote? like this?: SQL> update tablea set fielda = ' james''ste Camp ''first,''sec'' '; 1 row updated. SQL> select * from tablea; FIELDA james'ste Camp 'first,'sec' 1 row selected. or: SQL> update tablea set fielda = ' james'||chr(39)||'ste Camp '||chr(39)||'first,'||chr(39)||'sec'||chr(39)||' '; SQL> select * from tablea; FIELDA james'ste Camp 'first,'sec' 1 row selected. -Original Message- Sent: Thursday, October 09, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List, How can I user comma " ' " in my update statement? update tablea set fielda =' james'ste Camp 'first,'sec' ' Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Eberhard, Jeff 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: replace ' with '' ???
Janet, Sorry, I'm just going through the list. I've run into the same problem. Have you got any answers? I got it resolved by using the following code that I found but I don't remember where/who I found it from. Something like this: String FChar = request.getParameter("p_location_name").toUpperCase().trim(); StringBuffer lsNewStr = new StringBuffer(); int liFound = 0; int liLastPointer=0; do { liFound = FChar.indexOf('\'', liLastPointer); if ( liFound < 0 ) lsNewStr.append(FChar.substring(liLastPointer, FChar.length())); else { if (liFound > liLastPointer) lsNewStr.append(FChar.substring(liLastPointer,liFound)); lsNewStr.append('\''); lsNewStr.append('\''); liLastPointer = liFound + 1; } }while (liFound > -1); FChar = lsNewStr.toString(); Perhap you have received better answers than this that you could share with me. Thanks, Jeff Eberhard Database Administrator Rolls-Royce Gear Systems -Original Message- Sent: Tuesday, September 16, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Hi, I apologize it might be a wrong place to post the question, but since it's the only list I know ... You know when you insert a'b into db, you got to change it to a''b, our value is from jsp, so I have this request.getParameter("p_location_name").toUpperCase().trim(), in case there is ' in it, I need to replace it with ''. How to do this in jsp, I tried string.replace('\'','\'\''), replace("'","''"), replace("\'","\'\'"), all sorts stuff and doesn't work. We are using jdk 1.3.1. Any suggestion?? Thank you! Janet __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy 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: Eberhard, Jeff 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: Oracle 9iOAS install help needed
I installed our Oracle 9iAS on Win 2000 following "Oracle 9iAS Release 2 (9.0.2.0.1) Windows Installation Cookboook" (Note: 21469.1). It's been a few months so I don't recall exactly how it went. The document does mention to verify the SSO Login by going to http://:/pls/orasso, login using the 'orcladmin' username and the password for the 'ias_admin'. The port will be the HTTP Server port of your Infrastructure, (port by default). You most likely already tried this but thought I would post just in case. -Jeff -Original Message- Sent: Tuesday, September 09, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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:
whatever happened to "are you an idiot?" -Original Message- Sent: Tuesday, August 19, 2003 4:50 PM To: Multiple recipients of list ORACLE-L sorry, no help available. Benny Pei <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/19/2003 03:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: help __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Benny Pei 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: Eberhard, Jeff 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).
Consolidating Servers
Just got out of a meeting with my manager. He had just finished meeting with our Oracle rep and has finally figured out that we don't have enough licenses (I've always asked him what we have and he's never shared it with me, always just "I've gotten it taken care of"). We have 80 and with our current/potential configuration we are going to need 300. Anyways, to save money he decides that we need to take our databases and consolidate them to two or three servers (from 7). Most of the database are fairly small (100-300Meg) so shouldn't be too bad. Actually it should be pretty fun (if I didn't already have 5 full-time jobs to do). Anyone had to do the same thing? What are some concerns? Should I shoot for the moon and upgrade them all to 9i at the same time or have several versions (7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly appreciated. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: 9i-OCP Question
Perhaps it is a question which doesn't get scored (hopefully). I'm not sure if all the tests are like this but I took the 9i upgrade exam last week. It had 60 questions but only scores on 53 of them (it tosses out 7). Unfortunately you don't know which questions will be scored or not. --Jeff -Original Message- Sent: Monday, August 04, 2003 1:20 PM To: Multiple recipients of list ORACLE-L I took the 8i OCP upgrade exam this weekend. I was amazed at one question. It was asking about the OUI and installing third party software. Now I've been an Oracle DBA for many years, and I would have thought Oracle would be more concerned about the Oracle database and the way it works rather then third party software, but apparently that is an important enough piece of information to Oracle Education to make it into a 45 question exam. Tim Gorman <[EMAIL PROTECTED]> wrote: Experience with various flavors of storage technology plus a decade of DBA experience can't possibly prepare me for what I haven't read (i.e. "Oracle's recommendations"). In a multiple-choice test format, unlike real life, I can't possibly argue with what Oracle has recommended... No wonder I failed my first try at the 9iOCP upgrade exam. Yes, I'll try again, once the lobotomy scars heal... on 7/30/03 10:19 AM, Senthil Kumar at [EMAIL PROTECTED] wrote: > Hi all, > > What is the correct answer for this? > > Q> If you have 2 redo log groups with 4 members each, how many disks does > Oracle recommend > to keep the redo log files? > > 1. 8 > 2. 2 > 3. 1 > 4. 4 > > Which is the correct answer. > > TIA > Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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). _ Do you Yahoo!? The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> Yahoo! Search - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Change nuber.+# to number
One way that might work is to use the translate function. For Example: SQL>r 1* select translate('&numberstring',1||translate('&numberstring','0123456789',' '),'1') from dual Enter value for numberstring: 89_. Enter value for numberstring: 89_. old 1: select translate('&numberstring',1||translate('&numberstring','0123456789',' '),'1') from dual new 1: select translate('89_.',1||translate('89_.','0123456789',' '),'1') from dual TR -- 89 1 row selected. SQL>r 1* select translate('&numberstring',1||translate('&numberstring','0123456789',' '),'1') from dual Enter value for numberstring: 99,9 Enter value for numberstring: 99,9 old 1: select translate('&numberstring',1||translate('&numberstring','0123456789',' '),'1') from dual new 1: select translate('99,9',1||translate('99,9','0123456789',' '),'1') from dual TRA --- 999 1 row selected. HTH, Jeff -Original Message- Sent: Thursday, July 31, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Hi, I want to get rid or those special char in a number string to a pure number, for an instance, from 89_. or 99,9 to 89 and 999. Which function should I use in SqlPlus? Thanks a lot, Jack Change nuber.+# to number -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Tech meetings
I wish. I always get that question. I work at a gear box manufacturing plant which primarily manufactures gear boxes for jet engines. Rolls-Royce plc doesn't even make the cars anymore. In "1998 Rolls-Royce Motor Cars was sold by Vickers to Volkswagen, although BMW hold the rights to the name and the marque for use on Rolls-Royce cars, having acquired the rights from Rolls-Royce plc for £40m in 1998. BMW will take over responsibility for Rolls-Royce cars from the beginning of 2003." http://www.rolls-royce.com/history/timeline/default.htm Jeff Eberhard Database Administrator Rolls-Royce Gear Systems Park City, Utah This email message and any attachments are for the sole use of the intended recipients and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy the original message and any copies of the message as well as any attachments to the original message. -Original Message- Sent: Wednesday, July 09, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Hey Jeff, just out of curiousity, do you guys all get company cars? --Walt Weaver Bozeman, Montana > -Original Message- > From: Eberhard, Jeff [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 10:35 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Tech meetings > > When I first began working here years ago we had a scheduled lunch > meeting/training every Friday for the IS Department. Lunch was provided > and > someone was given the task to present some technical topic. A lot of > times > it was watching a training video, such as a training video for Visual > Basic. > Eventually it died because the guy scheduling the meetings had left the > company. Every once in a while we try to resurrect the "Weekly Training > Meeting". My current boss (which was an employee turned manager) wants to > have the meetings but doesn't want to provide the lunch. Guess what? No > one shows up after the first meeting. It's amazing what an incentive a > little bit of food is. > > --Jeff > > -Original Message- > Sent: Wednesday, July 09, 2003 1:39 AM > To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt 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: Eberhard, Jeff 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: Tech meetings
When I first began working here years ago we had a scheduled lunch meeting/training every Friday for the IS Department. Lunch was provided and someone was given the task to present some technical topic. A lot of times it was watching a training video, such as a training video for Visual Basic. Eventually it died because the guy scheduling the meetings had left the company. Every once in a while we try to resurrect the "Weekly Training Meeting". My current boss (which was an employee turned manager) wants to have the meetings but doesn't want to provide the lunch. Guess what? No one shows up after the first meeting. It's amazing what an incentive a little bit of food is. --Jeff -Original Message- Sent: Wednesday, July 09, 2003 1:39 AM To: Multiple recipients of list ORACLE-L I've found both as a manager in Oracle and in Miracle that if you schedule regular meetings with the guys (and girls), then they start not showing up after a while, or the meetings become boring. If you don't hold regular meetings they'll complain and wish for regular meetings. So I've come up with this model: 1st meeting 2nd meeting after a week 3rd meeting after two weeks 4th meeting after four weeks 5th meeting after eight weeks (around here or at next iteration they start complaining...) 6th meeting after a week... 7th meeting after two weeks... Mvh Mogens Babette Turner-Underwood wrote: >From time to time, we go through a series of "show and tell" where people do about an hour long presentation, question and answer on some usually technical topic. Occasionally these presentations are business related (eg explaining how the Canada Pension Plan international agreements affects the programs we are doing). They die off, then the director resurrects them by asking for volunteers. Occasionally, people are told to do a presentation on a specific work -related topic. - Babette -Original Message- mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ]On Behalf Of Rudy Zung Sent: Tuesday, July 01, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Don't know if what we do in our shop here qualifies for your question or not, but our dev groups do "stand-up meetings." Relatively quick meetings (that can be done standing up; no meeting rooms required) that are usually finished in about 20 minutes. In the stand-ups, we get heads-up for things and specifications that might be coming down the pipeline from the product management and design side. We get a quick update on the state of deployment (what version has rolled into production, what version is in the QA pipeline) and what the next impending set of changes are about to get pushed onto the dev servers. If there's any potential "gotcha"s that have been experienced (especially on the coding front) they get publicized in the stand-ups as well. The main point of our stand-ups are to make sure that all the developers are relatively aware of the scheduling and direction of the product, and to highlight any programming difficulties and workarounds that might arise so that when different developers hit those gotchas, they'll already know that a solution might already. These stand-up meetings are basically within a development team/group. Project leads have their own meetings with the product management group. So essentially, the product manager has his own meetings; then the product manager has meetings with the dev project leads to convey what they want in the next iteration of the product; the project leads then present these to the dev group in a stand-up meeting. -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Tuesday, July 01, 2003 12:30 PM To: Multiple recipients of list ORACLE-L List, Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are? I've been asked about this, and was wondering if there is a quick list out there any where. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Windohs - monthly at job
Just for fun right?!? Actually years ago I wrote a C++ program which took the current time and added fifteen minutes to it and submitted the at command. At the end of each batch file which I wanted to run every fifteen minutes I would add a line calling the C++ program passing the name of my program for the parameter ( atplus15 "c:\myJob.bat"). It's crude but has working for years now. I'm sure the Perl gurus here could probably whip something up similiar if they wanted to. --Jeff -Original Message- Sent: Tuesday, July 08, 2003 2:10 PM To: Multiple recipients of list ORACLE-L at 06:00 /every:M C:\myJob.bat at 06:15 /every:M C:\myJob.bat at 06:30 /every:M C:\myJob.bat at 06:45 /every:M C:\myJob.bat
RE: Windohs - monthly at job
:00 PM C:\myJob.bat 2 Each 15 11:00 PM C:\myJob.bat Do not specify \\%ComputerName% - and the job is scheduled locally. The above is also visible from GUI Task Scheduler. Other way (to do the same): == By leveraging WMI (hideously complex & ugly COM object hierarchy) that Win2K comes equipped with and by using "scripting for 21st century" the VB Script. For how to it (use M$ scripting) do - see the TechNet Script Centerr http://www.microsoft.com/technet/treeview/default.asp?url=/technet/scriptcen ter/schedule/Scrsch04.asp <http://www.microsoft.com/technet/treeview/default.asp?url=/technet/scriptce nter/schedule/Scrsch04.asp> Section on "Task Scheduling": http://www.microsoft.com/technet/treeview/default.asp?url=/technet/scriptcen ter/schedule/default.asp <http://www.microsoft.com/technet/treeview/default.asp?url=/technet/scriptce nter/schedule/default.asp> Now, let's talk abt. virtual pint... ;-) Branimir -Original Message- Sent: July 8, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Why didn't datafile autoextend?
duh. I feel so stupid! It seems that I used OEM to set the MAXSIZE for the datafile and set it to 1900 K Bytes instead of the intended 1900 M Btyes. Thanks!!! -Original Message- Sent: Monday, June 30, 2003 11:16 AM To: Multiple recipients of list ORACLE-L Looks like the size of your datafile is already higher than your MAXBYTES. In additional to setting AUTOEXTEND ON, you should also give it a sufficient MAXSIZE for the datafile. Oracle will autoextend the datafile only up to the max size specified for the datafile. In your case, the max size for your datafile is a little less than 2 megs, which means that once your datafile is at 2 megs, Oracle will never AUTOextend it beyond the 2 meg size, although it can be extended beyond 2 meg by hand, as you have done. ...Rudy -Original Message- Sent: Monday, June 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L This morning I started getting "ORA-1654: unable to extend index CIMXDBIN.CIMX_SESSION_STATE_PK by 128 in tablespace CAPP_IDX " in my alert log (8.1.7 on Windows 2000). I checked my tablespace is has one datafile with autoextend enabled. FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUSRELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS -- -- -- -- -- - --- -- -- -- --- E:\ORACLE\ORADATA\CIMX\CAPP_IDX.ORA 4 CAPP_IDX 314572800 38400 AVAILABLE4 YES1949696238 3200 314564608 38399 To resolve the error I manually resized the datafile to 300M. Any ideas on why the autoextend didn't work? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Rudy Zung 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: Eberhard, Jeff 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).
Why didn't datafile autoextend?
This morning I started getting "ORA-1654: unable to extend index CIMXDBIN.CIMX_SESSION_STATE_PK by 128 in tablespace CAPP_IDX " in my alert log (8.1.7 on Windows 2000). I checked my tablespace is has one datafile with autoextend enabled. FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUSRELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS -- -- -- -- -- - --- -- -- -- --- E:\ORACLE\ORADATA\CIMX\CAPP_IDX.ORA 4 CAPP_IDX 314572800 38400 AVAILABLE4 YES1949696238 3200 314564608 38399 To resolve the error I manually resized the datafile to 300M. Any ideas on why the autoextend didn't work? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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).
SQL Query -- List of managers
Using the EMP table as an example I want to create a query that will show a list of employees and the mgrs above them. Like this: ENAME MGRS --- -- SMITH SMITH SMITH FORD SMITH JONES SMITH KING ALLEN ALLEN ALLEN BLAKE ALLEN KING WARDWARD WARDBLAKE WARDKING JONES JONES JONES KING MARTIN MARTIN MARTIN BLAKE MARTIN KING BLAKE BLAKE BLAKE KING CLARK CLARK CLARK KING SCOTT SCOTT SCOTT JONES SCOTT KING KINGKING TURNER TURNER TURNER BLAKE TURNER KING ADAMS ADAMS ADAMS SCOTT ADAMS JONES ADAMS KING JAMES JAMES JAMES BLAKE JAMES KING FORDFORD FORDJONES FORDKING MILLER MILLER MILLER CLARK MILLER KING So far I've got it to this: 1 select lpad(' ',3*level-3)||ename org_char, leve 2 empno, mgr 3 from emp 4* connect by prior mgr = empno ORG_CHAR LEVEL EMPNOMGR --- -- -- -- SMITH1 7369 7902 FORD 2 7902 7566 JONES 3 7566 7839 KING4 7839 ALLEN1 7499 7698 BLAKE 2 7698 7839 KING 3 7839 WARD 1 7521 7698 BLAKE 2 7698 7839 KING 3 7839 JONES1 7566 7839 KING 2 7839 MARTIN 1 7654 7698 BLAKE 2 7698 7839 KING 3 7839 BLAKE1 7698 7839 KING 2 7839 CLARK1 7782 7839 KING 2 7839 SCOTT1 7788 7566 JONES 2 7566 7839 KING 3 7839 KING 1 7839 TURNER 1 7844 7698 BLAKE 2 7698 7839 KING 3 7839 ADAMS1 7876 7788 SCOTT 2 7788 7566 JONES 3 7566 7839 KING4 7839 JAMES1 7900 7698 BLAKE 2 7698 7839 KING 3 7839 FORD 1 7902 7566 JONES 2 7566 7839 KING 3 7839 MILLER 1 7934 7782 CLARK 2 7782 7839 KING 3 7839 39 rows selected. Which brain cell am I missing today that will help me get what I want? Thanks, Jeff Eberhard Database Administrator Rolls-Royce Gear Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Script to check for errors
Here's what I use. Pretty basic (crappy) but may be a starting point for you. You'll have to go through and change where you alert files are stored and to whom to send the email. I schedule them to run about every 15 minutes. blat is a mail utility you can downloaded from the internet. HP-UX: if [ -s "ORAerr.tmp" ] then exit fi grep ORA- /u01/app/oracle/admin/orcl/bdump/alert_sid.log > ORAerr.tmp if [ -s "ORAerr.tmp" ] then cat crlf.txt /u01/app/oracle/ORAerr.tmp | /usr/sbin/sendmail -CsendmailORA.cf -F"Oracle dbsrv1 alert error" username @company.com <mailto:[EMAIL PROTECTED]> fi WINdoze: find "ORA-" c:\orant\rdbms80\trace\*ALRT.LOG* > e:\dbwork\alerts.txt if errorlevel 1 goto NEXT rem net send dba "An ORACLE error has been found in the alert file. Please check the alerts.txt file on dbsrv2" blat e:\dbwork\alerts.txt -t dba @company.com <mailto:[EMAIL PROTECTED]> -s "Oracle (dbsrv2) alert" :NEXT find "ORA-" c:\orant\rdbms80\trace\orcl\*ALRT.LOG* > e:\dbwork\alertsorcl.txt if errorlevel 1 goto END rem net send dba "An ORACLE error has been found in the ORCL alert file. Please check the alerts.txt file on dbsrv2" blat e:\dbwork\alertsorcl.txt -t dba @company.com <mailto:[EMAIL PROTECTED]> -s "Oracle ORCL alert" erase c:\orant\rdbms80\trace\orcl\orclalrt.tmp rename c:\orant\rdbms80\trace\orcl\orclalrt.log orclalrt.tmp :END -Original Message- Sent: Friday, March 21, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Anyone have a "simple" script to scan an alert log for errors and email a report if found? Customer wants something to run "often", but only email when an error is found. I've got something that does a bit of that and runs twice a day, but always sends out. Thanks. Maks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Dealing with 3rd Party Applications
ww.EvDBT.com/tools.htm. You can use that trigger to initiate SQL Tracing immediately upon connection by the user. Are you familiar with SQL Trace and TKPROF? Hopefully, the parameter TIMED_STATISTICS is set to TRUE in this database; if it isn't, you can enable it in the TRACETRG trigger for the session (i.e. "execute immediate 'alter session set timed_statistics = true';") or using ALTER SYSTEM to set it to TRUE for the instance. If you can set TIMED_STATISTICS to TRUE, then please use the "sort=prsela,exeela,fchela" clause with the TKPROF command; if it is FALSE, then please use "sort=exeqry,execu,fchqry,fchcu" clause. This way, the worst SQL statements will percolate to the top of the TKPROF report... If you can get a TKPROF report, would you like to paste the relevant section for the offending SQL statement back to the list? That way, you'll get lots of ideas from the best tuning folks in the world. And don't forget to DISABLE or DROP that trigger when you've gotten your trace! Coming from personal experience, it is *VERY* embarrassing to have to explain why the file-system housing the USER_DUMP_DEST keeps filling up... :-( > Also how do you usually deal with 3rd party application issues like this? > 95% of our databases/applications are from 3rd party vendors and it's a pain > trying to get them performing better. We never have "control" over the application and it is always a pain. However, don't neglect the possibility that the application is somehow misconfigured or configured inappropriately somehow. It's not easy to ask questions about this without triggering the knee-jerk "No! Everything's fine!" response, but is it reasonable that an application session would need to perform those several-thousand queries at each login? Is it a two-tier (a.k.a. "client-server") application where every user session spawns a corresponding database session, or is it an N-tier application where the app-server is creating a "pool" of database connections. A huge up-front load like you describe is more characteristic of the N-tier app-server, and less characteristic of "client-server" connections. Just some food for thought... > Thanks, > Jeff Eberhard Good luck! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: Eberhard, Jeff 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).
Dealing with 3rd Party Applications
Hi, So my boss comes over this morning and tells me that the users are having a performance problem with a 3rd party application that have recently began using. This is an oracle database where they bought the software and had the system admin install the software which included the vendors instruction of creating and setting up the database (basically use the defaults). It is an Oracle 8.1.7 database on Windows 2000. He wants me to find out "if you can create some indexes or something", etc. (he likes to give solutions before the cause if discovered). Anyway, I decide to take a look at it. The performance they are complaining about is when they log into the application it takes about a minute for their initial screen (which includes a list of values) to appear. I use the tool that someone posted here a while ago, SQL Monitor from www.fastalgo.com, and find that during the time the user is waiting for the first screen the application is executing a sql statement about 2200 times. The SQL is: SELECT PARENTID FROM PROC_ WHERE PROCEDUREID=:1 The bind variable is different for each execution with appears to be the procedureid values from the table proc_. Table proc_ has 2203 rows. I check the executions for the sql text in v$sqlarea. Executions = 58,825. (aha, I think this is the problem). I explain plan the query and find that it is using the primary key index. My tuning skills are still pretty basic. Since I have no control over the application is there anything I can do to increase the performance of running the query thousands of times? Also how do you usually deal with 3rd party application issues like this? 95% of our databases/applications are from 3rd party vendors and it's a pain trying to get them performing better. Thanks, Jeff Eberhard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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: Statspack recomendations.
Forgot to mention 9.2.0.1.0 on Win2000 I got data when I changed the join as follows: select a.file_name, b.* from dba_temp_files a, v$tempstat b where b.file#=to_number(a.file_id); --Jeff -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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: Statspack recomendations.
I get the same results. Strange!?!? -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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).
MS Access from Oracle
Can someone tell me where to start to find out how to access an MS Access table from Oracle. Basically what I want to do is be connected to an Oracle database in SQL*Plus and execute a query against an MS-Access table. Is this possible? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff 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: Special characters once again !
SQL> insert into sc values ('''1234''','''guest''') 1 row created. SQL> select * from sc; PART_NO NAME - - '1234''guest' SQL> select * from sc where part_no = '''1234''' and name = '''guest'''; PART_NO NAME - - '1234''guest' JE -Original Message- Sent: Thursday, August 01, 2002 9:19 AM To: Multiple recipients of list ORACLE-L I told that i want to insert the following where part_no='1234' and name='guest' but i tried as u people said ( ' Where part_no="1234" and name="guest" ' ) but the result was, which is as follows where part_no="1234" and name="guest" but what i need is as follows... where part_no='1234' and name='guest' Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff 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: Location of tnsnames.ora on client
If the tnsnames.ora file isn't in the default location it needs to specified using the TNS_ADMIN environment variable. Had a problem once where a software vendor decided they needed to use their own tnsnames.ora file and created the TNS_ADMIN environment variable set to their file. Of course their tnsnames.ora only including their database and none of the other databases for our other applications. HTH --Jeff -Original Message- Sent: Friday, July 12, 2002 2:29 PM To: Multiple recipients of list ORACLE-L On a Windows client installation, does anyone know what controls the location of tnsnames.ora? Is it some registry variable? We have a Windows install that can't seem to find its tnsnames.ora. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Eberhard, Jeff 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: Null value is string
Not sure what you are asking. I tried what I think you meant and it works fine. This is what I did: SQL> create table student (student_id number, student_name varchar2(10) default 'null'); Table created. SQL> insert into student (student_id) values ('28'); 1 row created. SQL> select * from student; STUDENT_ID STUDENT_NA -- -- 28 null SQL> alter table student add ( student_name2 varchar2(10) default 'null' ); Table altered. SQL> insert into student (student_id,student_name) values ('43','Peter Pan'); 1 row created. SQL> select * from student; STUDENT_ID STUDENT_NA STUDENT_NA -- -- -- 28 null null 43 Peter Pan null --Jeff -Original Message- Sent: Tuesday, July 09, 2002 4:13 PM To: Multiple recipients of list ORACLE-L All, I need to know if there is a way to insert a character value of 'null' as a default for a column: example: student_name varchar2(10) default 'null' I have tried this and it works if I update the column values to the string 'null' later: example: update student set student_name = 'null' where student_name is null I know that null is a reserved word but I though that I saw it used somewhere like this before and just thought I would check with the group on this. thanks. Joseph Hway [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: donald.holloway 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: Eberhard, Jeff 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: Delete query
To delete the oldest record for each userid (keep record if there is only one) delete from table a where created = (select min(created) from table b where b.user_id = a.user_id having count(*) > 1); --Jeff -Original Message- Sent: Tuesday, July 09, 2002 11:00 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone help me with this delete statement? I have the following table: Name Null?Type - - USER_ID NOT NULL NUMBER(15) PASSWORD VARCHAR2(30) CREATEDDATE What I need to do is delete the oldest record for a particular user_id. And its doing my head in. Any help appreciated! Thanks, Steve. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: Eberhard, Jeff 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).