Re: Syntax for foreign key
Dennis... > I'm trying to add a foreign key constraint to a table, and specify the > tablespace and pctfree. Here is the syntax I'm using: > > alter table jobproductoutrigger add ( >constraint fk_jobprodu_currjobfa_currjobf foreign key ( > jobnbr, sourcefiscalyear ) >references currjobfact (jobnbr, sourcefiscalyear) >using index tablespace index73 >pctfree 5) > / Check the length of the constraint name. I don't know what the limitation is (I haven't looked), but I recall having a similar problem, so I just shortened the name. Gary Chambers //-- // Lucent Technologies ITO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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:File Restoration/Recovery
Dick... Thanks very much for the reply! > Only if 1) The database is shutdown prior to the copy of the > datafiles, and everything else that compromises the database (online > redo, control files, etc...) I hate second-guessing myself, but this is what I've been trying to tell him. > or 2) the effected tablespaces are put into hot backup mode before the > copy, in which case when you restore the files Oracle will ask for the > archive redo to roll them forward to the rest of the database. Here's another direct quote on my admonition for not running the database with archive logging: "Thanks again for your help on this. we've [sic] not decided to run oracle in archive mode yet as content on this oracle [sic] instance will only be changed through replication and instead of recovering from archive logs it is easy to recover it from replication." The replication to which he is referring is through the application (Documentum). > As far as "returning the skeleton database based on these files" he's > smoking something good!! What I believe he's more likely asking for > is a schema export. I considered offering him that option, but that wouldn't solve his problem. The background (briefly) is that this server, until Wednesday, was being "administered" by an engineer -- it's part of someone's empire here at Lucent, and [WAS] outside of the scope of my Unix system administration team. On Wednesday, one of the hard drives failed, taking with it many of the datafiles Oracle finds useful. Not surprisingly, it quickly became in-scope. We replaced the failed drive, then discovered that the system wasn't even being backed-up. Now, this developer wants a way to recover without, again, having to manually recreate the database. Thanks again for the reply and the assistance!! Gary Chambers //-- // Lucent Technologies ITO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //------ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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).
File Restoration/Recovery
All... A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires a nightly backup (by simply copying them to a backup directory) of the datafiles of an active instance. I explain that it will be a waste of tape because the files will be corrupt and useless. He counters, "As long as these files are there, irrespective of their state, oracle [sic] provides the tools to restore the skeleton database based on these files." Will this be the case? I understand that there will [most likely] be some loss of data, but will Oracle "fix" itself to a point where it's useful again? TIA Gary Chambers //-- // Lucent Technologies ITO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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: interMedia Textkey (DRG-10826)
All... STUPID, STUPID, STUPID!!! > Will someone please help me understand the Textkey parameter in the > ctx_doc.themes function? I am receiving a DRG-10826 error on: I withdraw my question -- I was looking at it MANY layers too deeply, and absolutely overlooked the braindead obvious. Sorry for the noise. Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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).
interMedia Textkey (DRG-10826)
All... One more submission to see if there are any takers, then I'll stop nagging and keep looking... I'm running Oracle 8.1.6 on Solaris 8. Will someone please help me understand the Textkey parameter in the ctx_doc.themes function? I am receiving a DRG-10826 error on: exec ctx_doc.themes('ctx_webdocs', 1, 'MYTHEMES', 1, full_themes => TRUE); The index is on a BLOB column that, for the moment, contains only textual data (not that it really matters, anyway). I don't understand the relationship of the textkey to the table and/or index. Any help is greatly appreciated. TIA!! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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).
interMedia Textkey (DRG-10826)
All... I'm running Oracle 8.1.6 on Solaris 8. Will someone please help me understand the Textkey parameter in the ctx_doc.themes function? I am receiving a DRG-10826 error on: exec ctx_doc.themes('ctx_webdocs', 1, 'MYTHEMES', 1, full_themes => TRUE); The index is on a BLOB column that, for the moment, contains only textual data (not that it really matters, anyway). I don't understand the relation of the textkey to the table. TIA!! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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: Happy Holidays!!
> Well that is nice to hear - it is difficult to find out from names - I > always thought that Cary Millsap was a female .. :) Don't be so hard on yourself. There are probably several people that don't know Mohini, Jayashree, Vidya, and Gavoury are female names. ...and Sowmyanarayanan? Forget it!! ;) Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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: INIT 6 on Solaris not working with Oracle automated scripts?
> Has anyone encountered a problem rebooting a Solaris box using INIT 6 > with the Oracle dbstart/dbshut scripts enabled? My sysadmin seems to > feel the problem rests with the Oracle scripts - we issue INIT 6 and > nothing happens. Which version (and kernel patchlevel) of Solaris? Which version of Oracle? Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Import from FoxPro to Oracle
> Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7. If > yes how. Take a look at the Perl DBI. You'll need the DBI package, and the DBD modules for xBase and Oracle. There are many examples of use out there on the Internet. You may also want to investigate the [somewhat helpful] O'Reilly "Programming the Perl DBI" book. Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).
Join Query Question
All... I'm not even sure how to ask this question, but given three tables: pocs poc_id number primary key sn varchar2(32) poc_hrid varchar2(16) poctype_id number references poctypes(poctype_id) poctypes poctype_id number primary key tiernumber(2,0) description varchar2(64) pocgroup_id number references pocgroups(pocgroup_id) pocgroups - pocgroup_id number primary key description varchar2(16) I'm attempting to construct a single query that will provide the poc_hrid *AND* the pocgroup description to which that poc belongs. This is part of a web-based application which allows for many points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only members of a particular group to modify certain sections of the record. Any help will be greatly appreciated! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Selecting Next X Values From Dual
Stephane... Thanks for the reply. >> SELECT sequence.nextval FROM table WHERE ROWNUM < x >> It just seems too kludgy, and I didn't think creating a table with >> dummy data for the count would be a good way to go. Any suggestions? > Why 'too kludgy' ? If you are inside a PL/SQL package have you though > of a bulk collect into an array of numbers? It seems kludgy to me to have a table of n-rows of dummy data to grab a specific number of values from a sequence. Is this a common practice? Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Selecting Next X Values From Dual
> I created a package that would easily loop thru and select x number of > entries, but not return them in a select to you. This way, you can > make 1 simple call passing it X. Is that what you wanted ??? Or do you > have to have them as returned values of a select ? I would need the values returned through select, if I'm correctly understanding you (it's a web-based application). I thought of doing something like: SELECT sequence.nextval FROM table WHERE ROWNUM < x It just seems too kludgy, and I didn't think creating a table with dummy data for the count would be a good way to go. Any suggestions? Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Selecting Next X Values From Dual
Anjo... Thanks for the reply!! > If X is fixed for all sessions, do a step increase of X so that you > only have to select 1 row from dual. Unfortunately, I don't feel I can do that. I'm using the returned values as unique identifiers to protect against duplicate database submissions from a web-based application. I have implemented a workaround by selecting a row from dual X number of times. I wanted something a bit cleaner, and [seemingly] less database-intensive than querying in a loop. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).
Selecting Next X Values From Dual
All... Is there a method by which I can select the next x values from a sequence from dual? I've searched Google and OraFAQs.com, but I can't seem to make any hits on my search request. TIA Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Recreate database script
> Could anyone here suggest a software package that can create an ER > diagram by simply connecting to an Oracle database, reverse engineer > it to see the schema in an ER diagram - instead of in a file with > ddl/dml statements. I haven't tested it, but Microsoft Visio 2000 claims to be able to reverse engineer a database. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: ssh client for Windoze
> Has anyone used an Windows ssh client in a large environment (50 +/- > Unix servers, 300+ instances) that they would recommend? SecureCRT at http://www.vandyke.com. $50.00/license for 200 to 499 users. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).
Table Naming Conventions
Many thanks to all for your feedback and advice! As I suspected, naming conventions are really a matter of someone's personal preference, and what's really important is to keep it standard and consistent. One [hopefully] last question: What's the consensus (if there is such a thing) on plural vs. singular table names? Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).
Table Naming Conventions
All... Will some of you please provide some insight on your table naming conventions? I'm in the very early planning stages of what will likely be a large and complex schema (IT asset inventory). I have a chance to start it correctly. TIA Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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[2]:RE: Rant
>> Yeah? And there's a good reason we SAs keep root privileges away >> from you DBAs. :-)) > Since when? Since a couple weeks ago, when a "DBA" deleted the filesystem containing the system tablespace datafile? I was just returning some friendly stabs from a DBA to an SA -- but I could provide lots of examples. :) Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Rant
> hey - who is this SA and what is he doing here? this is where us'n > DBA's get to trash everybody else. go away! I come in peace -- honest!!! I'm an aspiring DBA, and I want to do it the right way... How's that? :-)) Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Rant
> um, I'd schedule step 6 AFTER the backup finishes... I've seen idiot > SA's who start the backup then shutdown the machine or kill the > process before it completes. Yeah? And there's a good reason we SAs keep root privileges away from you DBAs. :-)) Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Rant
> baffling and frustrating. Some of these folks claimed to have 5 years > experience!!! Unfortunately for most everyone, the only people that benefit from most "certification" programs are the "facilitators." They're cash cows for the purported issuers of such certifications. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).
SQL Join or Subquery
All... I have a question about a query over which I've been racking my brain for weeks, and I can't find a reference to adequately assist me. Given a table of temperature sensors, and a table of readings from those sensors, how might I grab the max (hence latest or current) temperature reading for each sensor? The relevant fields in the tables are timestamp and temp_c (temperature table), and sensorid (both temperature and sensor tables). I'm fairly certain that I'm overlooking something very elementary, and I feel it should be simple and straightforward, but I think I'm being stymied by the use of aggregate functions in my query. I can provide examples of my failed attempts, if you'd like. Thanks in advance for any assistance you can provide. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).