RE: Silly SQL Question
Ok, guys I have to apologize twice,
First: the delay to answer your very kind emails, (you
know the urgent problems dont let you time for the
important ones)
Second: maybe my question was not clear enough,
ciertanly what Bambi says is what I need give me all
the usrs where there exists a record containing 1 AND
5 AND 7, the criteria was the list, not the records,
so it does not matter if the user has many more
records, but if he/she has those records that are in
the list, that is what I want, the solution is as
simple as Bambi's query.
I really really appreciate all the solutions provided
for you guys, I swear I tested every one.
Below I have a copy of my original email.
Thank you very much!
Gabriel Aragon
+++
I have a table like this:
Usr val
--
GAP 1
GAP 5
GAP 7
JKL 8
JKL 5
I need a query that returns the user (GAP o JKL) that
has ALL the values in a list. Example: Having the
list: 1,5,7 the result will be GAP, but with the
values 1,5 or 1,5,7,8 there will be no result.
select distinct usr from xxx
where val = All (1,3,5)
I was trying the ALL operator but it works with part
of the list, I need the user that has (exactly) all
the values in the list. Any idea?
Maybe it's a simple solution, but after several hours
I feel blocked.
Gabriel
+++
--- Bellow, Bambi [EMAIL PROTECTED] wrote:
Jacques --
Huh? I thought the question was, give me all the
usrs where there exists a
record containing a 1,5, and 7. How can that
return one record, when there
are two users -- and only two users -- who have the
1,5,7 combination? The
data provided shows that both GAP and GPA have a 1,
5 and 7 and that no
other users do. My query provides that answer. If
that wasn't the
question, then that won't be the answer; but if it
*was* the question, then
the query is correct.
HTH,
Bambi.
=
create table gab (usr char(3),val number);
insert into gab values ('GAP',1);
insert into gab values ('GAP',5);
insert into gab values ('GAP',5);
insert into gab values ('GAP',7);
insert into gab values ('PAG',1);
insert into gab values ('PAG',7);
insert into gab values ('PAG',2);
insert into gab values ('JKL',1);
insert into gab values ('JKL',5);
insert into gab values ('JKL',5);
insert into gab values ('GPA',1);
insert into gab values ('GPA',5);
insert into gab values ('GPA',7);
insert into gab values ('GPA',8);
select usr from gab
where val=1
intersect
select usr from gab
where val=5
intersect
select usr from gab
where val=7;
USR
---
GAP
GPA
-Original Message-
Sent: Friday, November 14, 2003 7:24 PM
To: Multiple recipients of list ORACLE-L
-Original Message-
Bellow, Bambi
Why not do it like this...
select usr from gab
where val=1
intersect
select usr from gab
where val=5
intersect
select usr from gab
where val=7;
Because that way you would get the wrong answer.
With the sample data as
kindly provided by Mr. Begun the correct query would
return one row, but
your query returns two rows.
SQL select * from gab ;
USR VAL
-- -
GAP1
GAP5
GAP5
GAP7
PAG1
PAG7
PAG2
JKL1
JKL5
JKL5
GPA1
GPA5
GPA7
GPA8
14 ligne(s) sélectionnée(s).
SQL select usr from gab
2 where val=1
3 intersect
4 select usr from gab
5 where val=5
6 intersect
7 select usr from gab
8 where val=7;
USR
--
GAP
GPA
--
=
Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la
pena tener, es un sueño por el que vale la pena luchar)Charles Xavier
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gabriel Aragon
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).
Silly SQL Question
I have a table with like this: Usr val -- GAP 1 GAP 5 GAP 7 JKL 8 JKL 5 I need a query that returns the user (GAP o JKL) that has ALL the values in a list. Example: Having the list: 1,5,7 the result will be GAP, but with the values 1,5 or 1,5,7,8 there will be no result. select distinct usr from xxx where val = All (1,3,5) I was trying the ALL operator but it works with part of the list, I need the user that has (exactly) all the values in the list. Any idea? Maybe it's a simple solution, but after several hours I feel blocked. TIA Gabriel __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Third party application - how to begin performance tuning efforts?
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 Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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).
No more Oracle development here
My company it's moving all the development efforts to SQL Server because the customers don't want to pay Oracle licenses anymore.. Gabriel __ 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: Gabriel Aragon 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).
Oracle and QA
Hi guys, I'm looking for some orientation about Quality Assurance for Oracle and databases, anyone has experience with this? This issue about QA is completely new to me, I know the OFA document and how to aplly it, but don't know what else to do, maybe something about QA for SQL statements? Comments are welcome. Thanks Gabriel Aragon __ 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: Gabriel Aragon 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: LMT Migration
I use the A) strategy for medium BD's with good performance behavior, for the fragmentation issue a good guide is the document: How to stop fragmentation and start living. you can find it in metalink.. regards, Gabriel --- AK [EMAIL PROTECTED] wrote: At present we have one tablespace containign all indexes . Some indexes are big in size some are small . Currently tablespace is dict managed. This tablespace currently highly fragmented . Now I am planning to move the indexes to a LMT. Now how to decide what should be the extent size for uniform extents ? What is better approach to divide indexs A ) should I devide them that based on size ( big, small ) and create seperate tablespaces with different values for extent size . b)or seperate them based on modules sooo that accounting and manufactring related indexes goes to different tablespace. Does number of extents is a performance issue in LMT as well ? Any experience ? Thanks, -ak = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ 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: Gabriel Aragon 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: Interview Questions for a Unix Solaris System Admin
I've been in the same situation, I had to interview the company's sysadmin, though I am not one. Here you have a few points to start your list. Regards Gabriel The candidate must provide knolwedge about (how to's): 1. Start and stop a solaris system, including several levels of boot (1,2,3, etc). 2. Patch installation. 3. App's installation and configuration (kernel and semaphores). 4. Users creation. 5. Partitions creation. 6. Mount and unmount FileSystems. 7. DNS, IP configuration. 8. Monitoring and performance tuning (process, priorities, memory, disk, etc). 9. Services configuration SMTP, FTP, Internet, secure conections (HTTP, HTTPs). 10. Scripts programming. 11. Establish backup/recovery strategies. Plus: - Define Sun equipment architecture. --- M.Godlewski [EMAIL PROTECTED] wrote: I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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).
OEM tools
Hi, I'm using the OEM 92010 with oracle 92 when I look for the option SHOW TABLESPACE MAP I can't find it, I remember using the OEM with 806 oracle DB and that option was available choosing STORAGE-TABLESPACES-tb_name and then click right button, in the database's tree. What happened with the TS Map? Is it a problem with the OEM version or am I missing something? Any Ideas? TIA Gabriel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: OEM tools
mmm I dont have the Tuning Pack option in my Tools menu, I dont understand, it's supossed to be the last version: Oracle(R) Entrepise Manager Version 9.2.0.1.0 Production Copyright 1998,2002, Oracle Corporation maybe a bad installation? --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: Tools - Tuning Pack - Tablespace Map - Kirti --- Gabriel Aragon [EMAIL PROTECTED] wrote: Hi, I'm using the OEM 92010 with oracle 92 when I look for the option SHOW TABLESPACE MAP I can't find it, I remember using the OEM with 806 oracle DB and that option was available choosing STORAGE-TABLESPACES-tb_name and then click right button, in the database's tree. What happened with the TS Map? Is it a problem with the OEM version or am I missing something? Any Ideas? TIA Gabriel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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).
Microsoft VS Oracle (again)
FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a present, it's a 4 cd's kit called SQL Server 2000 for the Oracle Customer, the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other information, maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Microsoft VS Oracle (again)
mmm maybe I was not clear, my intention was to show you what I call the MS's desperated cry for help.. I love Oracle! for ever! I just want to hear some comments about the 'facts' they put there, I mean, how much is true? ;-) --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Aargh ... you must be very brave telling a Oracle cult to move to SQL Server ... How do we know you are not Billy G using an alias ... 8) Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a present, it's a 4 cd's kit called SQL Server 2000 for the Oracle Customer, the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other information, maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Microsoft VS Oracle (again)
This is what I wanted to hear.. tks! Gabriel --- Goulet, Dick [EMAIL PROTECTED] wrote: Well, I'll be a little more forgiving than Raj has been. Basically MicroSoft is just the pot calling the kettle black. On the issue of price, well yes MicroSoft does have an edge, but that's just how they've eliminated all of their other competition over the years. The product does not cost less than Oracle or DB2, it's just that MicroSoft can leverage the tremendous amounts of cash they have to offset the giveaway they're into. I believe that was one of the points of the Antitrust suit they were embroiled in. On RAC they really have a long way to go. If you want to do a federated database setup like MicroSoft states, just buy standard edition Oracle licenses toss in a pile of database links. Works the same way you don't have to pay extra for it. The whole idea of RAC is that when one node dies, for whatever reason, the data that node was hosting is not offline till you get it repaired. And actually you really do not need to do anything to your application to take advantage of RAC, except adjust your error handling to understand that a transaction needed to be resubmitted. Overall I think MicroSoft's Achilles heel is Windows. Their a one OS horse. Oracle is a multi OS horse that runs the same whatever the platform. And BTW, Oracle runs RAC on Red Hat without any additional software, never mind that it runs on Linux in the first place. Similar things can also be said for DB2, Sybase, and Informix. When, if ever, Microsoft has a version of Sql*Server that runs as multiple independent processes on Linux then I'll give them a second look. As long as their a single multi-threaded Windows only process they can stay in Redmond. Also, yes they are the fastest growing database on the market, take a look at that copy of Windows 2000 Advanced Server you've got. There's a copy of Sql*Server 2000 in there, and you can't uninstall it. Billy G is still up to his old tricks. The only solution to MicroSoft is forced divestiture. Too bad that judge could not stand up to King George. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 01, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Aargh ... you must be very brave telling a Oracle cult to move to SQL Server ... How do we know you are not Billy G using an alias ... 8) Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a present, it's a 4 cd's kit called SQL Server 2000 for the Oracle Customer, the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other information, maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: salary question
http://www.payscale.com/research/vid-18563 choose the personal payscale report, to have an idea about what you get and what you should be getting.. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Didn't someone earlier this week post another site besides salary.com? Something with the word pay in it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Whatever the figure may be, two things are certain if the salary is X: a) I probably don't deserve to get X b) I should be getting more than X :-) --- Helen J Mitchell [EMAIL PROTECTED] wrote: Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen J Mitchell 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: DENNIS WILLIAMS 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Index question
decreased performance then you have proved this for yourself. A couple of important points: * Using an index isn't always faster than scanning the table * If a database is correctly analyzed then the optimisor can determine when to use indexes or not automatically * Hints can force the optimisor to choose a non-optimal execution plan. If you are smarter than the optimisor this may be fine but in most cases the optimisor will make the right decision when all tables are analyzed * Hints have very specific formatting and object name rules. If you rename an index the hint will become invalid and be blissfully ignored - you won't even know. * There are some hints which can safely be used but it takes a good understanding of Oracle first. My advice would be don't use them. If you have a specific problem then post lot's of details here and someone might suggest trying a hint. * Until you really understand the implications of using a specific hint it can be dangerous in terms of performance - Stephane is not lying when he says you can do more harm than good. I have many cases where I can tune a query simply by removing the hints which someone included and letting Oracle do what it does best. Regards, Mark. Teresita Castro === message truncated === = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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).
DBA Salary in California
Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: DBA Salary in California
Interesting site, thank you very much. Maybe you want to try this one: http://www.payscale.com/research/vid-18563 I recommend you to check the different reports and also fill up the PERSONAL PayScale Report section, prepare yourself to be disappointed if the information doesn't match your actual jobs. Thank you for your responses. Gabriel --- [EMAIL PROTECTED] wrote: it was a government contract. not a government jobs. salaries are really down here. not quite $45k, but its a rough job market. From: [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 01:50:00 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: DBA Salary in California Of course, if it was a government job, which would seem very possible in DC, it wouldn't seem quite that unusual. Government jobs for experienced DBA's were advertised at 60k during the height of the tech boom. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DBA Salary in California in the DC area, salaries for jobs that do not require a security clearance have dropped a ton. I saw one DBA job that wanted 5 years experience advertised at $45k/year. I dont know if they filled it, but I have talked to quite a few people that turned them down. id be curious about salaries in california. Seems to me most advertised salaries are very low. Seems like most oracle jobs around here are short term contracts. It also seems like contracting companies are keeping alot more of the rate for themselves. This is evident sicne you often see 3-5 contracters advertising for the same exact job at different rates. The good thing about that is that contracts are no longer sole source bids, so you an negotiate your way up. but id bet if you did that... you would be blacklisted and they wouldnt call you again. From: Gabriel Aragon [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 12:29:50 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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
Why dbms_output is not working
I have a very simple code:
begin
dbms_output.enable(1000);
dbms_output.put('hello');
end;
but the dbms_output is not sending the output to the
screen. I've already stablished set serveroutput on
and also used set serverout on
and still not working, this is a very frequent
situation and suddenly it displays everything stored,
why is this happening? Is there some buffer that I
have to flush with a command? Do I miss something?
TIA
Gabriel Aragon
__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gabriel Aragon
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).
OT: PLSQL question, JAVA, JDBC
Hi list, this is a question for JAVA/PLSQL programmers. I need to pass an array object from my code in Java using JDBC to a stored procedure in Oracle. I do not know how to do that, could you give me a call example so I can figure out how to achieve this ? TIA Gabriel Aragon __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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).
How to document a DB
Hi, I'm looking for info about how to make the documentation (complete) of a DB. I'll appreciate if you can tell me where to start searching. Thank you. Gabriel __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: OT: OS/2 is officially dead as of Dec 10, 2002
Another one bites the dust.. I had to make a presentation in the university about the OS/2, in those times was amazing to format one disk in the A: drive, other disk in the B: drive and having many applications running, everything at the same time! I finished my presentation saying The experts are not sure about the future of the OS2, but maybe it will be in many of the desktop computers in the next years (sigh) Regards Gabriel --- Boivin, Patrice J [EMAIL PROTECTED] wrote: http://www.pcmag.com/article2/0,4149,767456,00.asp Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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: Slightly OT - Who would you take with you...
. Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert === message truncated === = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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).
Instances cannot be together LISTENER PROBLEM??
Hi, I have a Win2000 Server with a 8.1.7. ora database with an instance called XXX, after that I've created a new one, called YYY. I open both databases without problems but 45 min then both instances are down. I open the X instance, then the Y instance, checked the status of the listener: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Prod tion Start Date12-NOV-2002 17:06:22 Uptime0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\ora81\network\admin\listener.ora Listener Log File D:\oracle\ora81\network\log\listener.log Services Summary... PLSExtProchas 1 service handler(s) XXX has 1 service handler(s) YYY has 1 service handler(s) The command completed successfully Suddenly appears a DOS screen (at the server) executing several times the command: D:\jdk1.3.1\bin\javac Checking the status again: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Prod tion Start Date12-NOV-2002 17:06:22 Uptime0 days 0 hr. 9 min. 59 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\ora81\network\admin\listener.ora Listener Log File D:\oracle\ora81\network\log\listener.log Services Summary... PLSExtProchas 1 service handler(s) XXX has 1 service handler(s) YYYhas 1 service handler(s) YYYhas 2 service handler(s) The command completed successfully The databases are down 15 minutes after that. I am not sure if the problem is with the listener, is this a normal behavior? Its normal having 3 services for the same instance? I've never used the jrun machine, is normal that executes is this way several times every x minutes? I have the following error at the SQLNET.log every minute (almost at the same the time javac runs): Fatal NI connect error 12640, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 12-NOV-2002 17:29:26 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12640 TNS-12640: Authentication adapter initialization failed ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 What do I need to check to detect what is shutting down the DB's? TIA Gabriel __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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: Oracle9i client install problem
I've installed 9.2.0.1 client on 2000 with a previous 8.0.6. client and both are working perfectly. Gabriel --- Greg Faktor [EMAIL PROTECTED] wrote: Hi ALL! I tried install Oracle9i (9.2.0.1) client on Windows 2000 server (sp2). First screen (for installer) show up in grey color and after I press NEXT I get this: Can't find bundle for base name OUIVersion locale. This is first Oracle install on that box. Any ideas? Thanks. Greg. = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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).
Oracle FailOver Solutions
Hi List, I have to make a presentation to the company's CEO about several strategies to implement a FailOver for an Oracle Server, this is the environment: DB Server: Sun Enterprise 3500 Solaris 5.7 with an A1000 StoreEdge Array (0+1), Oracle 8.0.6 EE App Server: Sun Enterprise 3500 Solaris 5.7 running AribaBuyer 7.0 Any suggetions or ideas where I can find information about it? Thanks in advance Gabriel = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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 FailOver Solutions
Hi Dennis, at this moment I dont have users making conections directly to the DB, only the application connects to the DB, so the users access only the application and I'd have to shutdown the app first of all.. I think that something like the first option is what I need.. Gabriel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Gabriel - Are you just talking about failing the database over to a hot standby database, and the users would have to be notified to log off and log on the standby, or are you thinking about automatically failing their connections over as well? The latter depends on what access methods they use. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, September 12, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Hi List, I have to make a presentation to the company's CEO about several strategies to implement a FailOver for an Oracle Server, this is the environment: DB Server: Sun Enterprise 3500 Solaris 5.7 with an A1000 StoreEdge Array (0+1), Oracle 8.0.6 EE App Server: Sun Enterprise 3500 Solaris 5.7 running AribaBuyer 7.0 Any suggetions or ideas where I can find information about it? Thanks in advance Gabriel = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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: Recreate database script
ErWin is an excellent tool.. Gabriel --- ltiu [EMAIL PROTECTED] wrote: Hello, 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. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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: TOAD ?
Seema, you dont give us enough information, so I am not sure what your problem is, I think you dont have the configuration of your DB in your TNSNAMES.ora file in your desktop, look at your ORACLE_HOME dir and then in /net80/admin (oracle 8.0.x), just configure there your BD and then choose which one to use at TOAD SERVER LOGIN window, (the one that shows up when you open TOAD) I hope this helps you! Gabriel --- Seema Singh [EMAIL PROTECTED] wrote: Hi I want to use QUEST TOAD software free version.I have Databases on UNIX and I want to connect from my desk top to UNIX DB box but I am unable to.can Some one help me if they have? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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: compile invalid objects SCRIPT
order. So far, this capability eludes me. I use Oracle 8.0.5 - 8.1.7.4. Cheers, Mike -Original Message- Sent: Saturday, August 17, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Script gen_recompile.sql online at http://www.EvDBT.com/tools.htm... As written, it will not execute the generated run_recompile.sql script; you'll have to uncomment the HOST command at the bottom to do that. I like to leave it with it's teeth pulled however -- at least at first -- so I can review the generated script... Hope this helps... - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, August 16, 2002 4:28 PM I am feeling lazy today .. so if someone can give me script that compiles all invalid objects untill all objects are valid ... will be great . Yes I am looking for the one which does this in a loop so that i dont have to run this many times to get 0 invalid objects Thanks , -Bp = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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: PL/SQL Editor.
TOAD is a very good one with a lot of useful options like commands configuration: you type: crbl ctrlspace you get: DECLARE CURSOR c1 IS SELECT FROM WHERE; c1rec c1%ROWTYPE; BEGIN OPEN c1; LOOP FETCH c1 INTO c1rec; EXIT WHEN c1%NOTFOUND; END LOOP; CLOSE c1; END; also you can use sqlnavigator and sql-programmer, there are a lot of very good tools.. Gabriel --- [EMAIL PROTECTED] wrote: vi or vim. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Place for oracle [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject:PL/SQL Editor. Hello, I need a nice PL/SQL editor any advice ? Thx for any advice Regards W.B __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Place for oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon 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).
