Hi,
I have a table which hasthree triggers :
1)before update - statement
2)after update - on each row
3) after update - statement
I assume the order of execution is 1,2 then 3. Does it do any processing in parallel? Is it safe to assume that after the last line on trigger2 it will execute
Title: RE: What is a large database?
I think there are many *poorly skilled* Oracle DBA's in Australia.
I had one of my clients sugest increasing the Oracle log_buffer to 10MB.
His claim is since the box has sufficient amount of memory why not use a very large log buffer.
I do not think
We recently wanted to use OiD for sign-on to a new app. I asked Oracle
about the licencing and they said it was *only* available as part of IAS,
even when used as a replacement for ONAMES. I didn't entirely believe the
answer, so I asked again, and got the same reply. Since the app does not
need
Pity not the tree. Pity the twig.
Thank God he didn't use too many colors.
Wolfgang Breitling wrote:
Download it for yourself from
https://www.oracleworld2003.com/published/36849/36849_Kolk.ppt
and see for yourself. But you better have a high speed connection.
At 05:19 AM 9/22/2003 -0800, you
I'm way beyond the simple RAID-F systems these days. I now want mirrored
RAID-F systems! We could call them RAID-F1, and they're unique. You
might waste parity disks in the first place ... but then you mirror them.
Mladen Gogala wrote:
Files are kept safe simply by RAID-5 mechanism. RAID-5
Dale Carnegie ? ! My - that dates you! (Unless it has recently been
reprinted - after 50 years!)
peter
edinburgh
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Offshore
Hi,
I have a doubt,please clarify.
All we know about x$tables(fixed tables) and
these all are in-memory table.When instance startup the data will be brought
back in this tables ,
when Instance off data will go,correct?
My question is since data is not stored in datafiles for this tables how it
Hi!
You souldn't look at seconds_in_wait only, because it's contents depend on
wait_time/status as well. If session is currently waiting (wait_time=0),
then seconds_in_wait show how long the session has been waiting for the
current wait, but if wait_time is not 0, then seconds_in_wait shows
Hi!
Search for "surrogate key" in google for example.
You have to modify your generated primary key valuesto not hit the same
index blocks consecutively. For example, add another high-cardinality column to
your primary key, or if using meaningless primary keys then just have your
primary
swear not to order anything from Amazon again, so help me Codd.
This was a good one ;)
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
- Original Message -
Do you really think the standard of database administrators in Australia is
low? What is it that you are expecting?
When projects sponsored and supported by such large
companies as IBM and Oracle get 27 DBAs and 30 developers,
one has to start asking EXACTLY
- Original Message -
Surpising enough the write cache on the disk array was set to 0 and 100% for
the read cache on this particular
RAID 5 system which does lots of small writes for the application making
things even worse.
Hehehe! Can never win, eh? :)
The DBA also sugested
control file
-Original Message-
Sent: Tuesday, September 23, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have a doubt,please clarify.
All we know about x$tables(fixed tables) and
these all are in-memory table.When instance startup the data will be brought
back in this
My age is the answer to the question of life, universe and everything.
Unfortunately, I'm no longer in my twenties.
On 2003.09.23 05:13, Robson, Peter wrote:
Dale Carnegie ? ! My - that dates you! (Unless it has recently been
reprinted - after 50 years!)
peter
edinburgh
-Original Message-
The grueling method is...
grab the header, copy paste it into notepad.exe. That strips the weird
formatting out of it.
Grab the body text, but not all the way down, try to guess where the body
text frame ends and stop just before that. It may take a few tries to find
exactly where.
copy paste
and I got the notice it was shipped.. which means I'll have it by
Friday. Now, since I read the online first chapter, I don't feel so
far behind
I know what my reading list will be for the weekend!
--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
I got my book... I got my book! From
How does oracle handle bit errors creeping into datafiles which could flip a '1' value
in a field to a '2'. I noticed checksum parameter. is that what its used for?
if that isnt enabled what does oracle do?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
To
anybody using Oracle8i and failsafe,
After
implementing 8.1.7.4 patchset 12 on my Windows 2000 adv server failsafe
configuration failsafe (and MS Cluster administrator) stopped being able to
control the Oracle service (it can stop it but not start it again - saying
things like "file
Thanks for the feedback - nothing like trying to cover
three thousand slides in 60 mins. My speaker
evaluations tended run along the lines of... Man,
that guy just never shuts up!
Although my favourite piece of feedback was:
Take a breath, man
:-)
Cheers
Connor
--- Jesse, Rich [EMAIL
you can trace it using sql_trace=true;
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 !
One-bit error can flip a 1 only to 3, 5, 9, 17 and so on.
Flipping a 1 to 2, requires 2 bits to be flipped :)
If you already noticed the checksum parameter, then just go to
tahiti.oracle.com , click parameters link and search a short description
from there.
Tanel.
- Original Message -
Title: RE: X$tables
x$tables/views are nothing but a clever implementation of SGA C structures as virtual tables. This is also in line with the RDBMS that all metadata etc should be accessible from tables.
Raj
Good
question, it's an Oracle8i patchset not a Windows one.
_ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service
Provider Tel:
+44.1684.312364 http://www.speechmachines.com
-Original
The
latest service pack for Win2K is SP4.
Patrice.
-Original Message-From: Tim Onions
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23,
2003 9:55 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle8i, Failsafe and patchset
12
Good
question, it's an
Title: RE: Cary's book -- Out of stock !
Mine came in the mail yesterday as well. First couple of chapters are out of the way. Reading a technical book and football games are a wonderful thing.
greg
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent:
B***ards! They killed Kenny!
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tanel Poder
Sent: Tuesday, September 23, 2003 6:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: Cary's book -- Out of
Hee hee hee!
Then make the most of that erudite reply - you only have one year to indulge
it!
ps - just bought the CDs
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L
Subject:
So the story goes like this. We're a NT/W2K shop. We have various scripts
that run DB related jobs but these are in plain text and we'd like to hide
these passwords in some way to allow scripts to run but the passwords not be
visible to potential prying eyes. Has anyone cracked this one yet.
And there is a bug (#2803772) in 9.2.0.3 (may exist in all 9i, not sure). The
seconds_in_wait is
reset to 0 when the SEQ# in v$session_wait increments. A patch is available, and the
bug is fixed
in 9.2.0.4.
- Kirti
--- Cary Millsap [EMAIL PROTECTED] wrote:
Fyi, seconds_in_wait is not
Hi,
I can't believe I'm loosing that much time installing Oracle 9i on my pc at
home.
PC is AMD Athlon/windows 2000
I've downloaded Oracle 9i release 2 from technet.
When running setup.exe I have the following message
The Java RunTime Environment was nout found at:
I plan to select distinct data from table. anyone has
suggestion?
Thanks.
select distinct employee
from (select employee_id, lname, fname, mi, hiredate
, as employee from emp)
SQL
SQL /
from (select employee_id, lname, fname, mi, hiredate ,
as employee from emp)
I realize that it may be terrifying, but there is a great deal of value in becoming
indistinguishable. How many accounting/hr/finance jobs are going overseas? None that I
have heard of. There are a ton of managers I wish we could offshore (but only about 1
mile off shore...). Bear with me for a
I GOT it... in my hot little hand is Cary's book, from Amazon no less.
EXCELLENT READ SO FAR.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/23/2003 8:54 AM
B***ards! They killed Kenny!
--
Mladen Gogala
Oracle DBA
-Original Message-
From:
Why not just restrict access to these scripts using file permissions?
Oh, if your problem is that everyone can log on to this user under which all
of your server processes and scripts run, then forget it, you can't ever
achieve what you want if you don't have even basic security.
An alternative
Title: RE: [Q] need help on SQLplus select distinct !!
shouldn't that be
select distinct employee_id
from emp
/
??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
You got an extra comma in your statement.
Btw, check your statement construction, you probably want the subquery named
as employee not hiredate column..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 5:59 PM
I
Mike,
You really don't need to in-line view for this. I'm also not sure what
exactly you are trying to do.
You could:
select distinct employee_id, lname, fname, mi, hiredate
from emp
or
select distinct employee_id from emp
what exactly are your trying to get? Distinct employee_id's?
Peter
If you feel the being an experienced Oracle DBA will continue to be as
scarce a commodity as it was during the dot-com boom, then read no further.
If however, you feel that in the future you may no longer rely on being
treated like royalty, then I would argue that Dale has some very
Title: Message
The
Washington DC area has had up to 5 days of no power, plenty of river
flooding,
and lots of tree damage.
Up to
3 Million people in the Eastern seaboard area without power.
I only
lost power for 3 days, no flood damage, one 1 big tree and some small tree
damage.
As far as the non-standard part, I had the same feeling when working with
9.0.1, but I think technically Oracle Corp is correct when they say OiD is
LDAP V3 compliant. The got is that the LDIFs are under a different RFC,
and they are not directly transportable between OiD and another LDAP.
Are you doing homework...?
Shame on you
-Original Message-
Sent: Tuesday, September 23, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
I plan to select distinct data from table. anyone has
suggestion?
Thanks.
select distinct employee
from (select employee_id, lname,
There is a good discussion in asktom website on this topic.
Here is the link :
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:142212348066
Hth.
Best Regards,
Prasad
Title: RE: Re: Cary's book -- Out of stock !
Well
after thumbing through Cary and Jeff'sbook yesterday, I decided to set
aside the other 2 tuning books I was reading and plunge into this one.
Here's why:
Figure 9-14 shows an interesting situation in which a
single fast CPU out-performs
You can try creating a password table that stores encrypted passwords, then
use a simple procedure that uses the encryption routine in the Obfusication
Toolkit to get and set the password.
Or you can make the database userid to be identified externally, so no
passsword is needed.
RWB
DBA Interpersonal skills
Before Dale Carnegie:
What the HELL do you want NOW!!
SHUTUP!! Get OUT and don't come back until you do what I told you to last
time!
Stop wasting my TIME with your sh*tty code!
After Dale Carnegie:
Hi! Brad OdlandDamn glad to see you!
hand thrusting out, smiling
Hmmm, odd reply, Dennis.
I think you may just have inserted a perjorative complexion into the reading
of my email, which was most certainly not there! Or perhaps you were
confusing my reply with those from others on this thread? The 'winning of
friends and influencing people' as stated by DC is
RE: Re: Cary's book -- Out of stock !Hi!
Figure 9-14 shows an interesting situation in which a single fast CPU
out-performs a system with 4 slower CPUs, for a certain condition;
this is exactly the situation I am facing while testing the move of a DB
(9.0.1.3.0) from a 2-processor (600 MHz)
I cancelled my Amazon order, ordered at Barnes and Noble and, guess what:
Barnes and Noble
has shipped it today. I'll never again do business with Amazon if I don't
have to. I feel that
they've been playing me for a fool and I don't like the feeling. I left them
enough of my
money and they will
I think this is the classical issue with service quality of big and
leading hot-shot companies. They achieve a little profit after huge losses
and they think they are the reasons why customers exist and the service
quality goes down. Of course initially they don't even see that, because
they're so
If you are not in AZ, please feel free to press DEL now.
It is time for another great AZORA user group meeting. The next
meeting is Thursday October 2nd which if you haven't looked at a
calendar lately
is coming soon. For more information on times/location, please see our
web page at
Or, how about: http://www.oreilly.com/catalog/oracleregexpr/
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/22/2003 06:44 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Isnumeric question
Dan,
You said that very well (as usual). The problem is that Management doesn't
usually see the downside of their downsizing actions until the stuff hits
the fan. And Larry's statements about self-tuning databases are not helping
as well - they help apply pressure on a dwindling market, whether
22 CDs huh? Any one know where to get free trial software for Apps?
Anyone want to burn me 22 CDs? Just kidding...
I haven't work with Financials since 10.7 and feel like I am rapidly losing my
financials skills. I want to set this up at home. I figure I would use it for my
personal accounting
__
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: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services--
If I install statspack, I always 'fix' the STATS$IDLE_EVENT table, and also change the
varibale
top_n_events to 10 (from 5) in spreport.sql. Statspack is a very generic tool. One
must 'tune' it
to reflect ones environment...
:)
- Kirti
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Dan,
You could set up environment variables and then reference the environment variable in your script.
HTH
M.[EMAIL PROTECTED] wrote:
There is a good discussion in asktom website on this topic.Here is the link :http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:142212348066Hth.Best
Step 1: have your head examined!
Step 2: All components of Oracle Applications comes on the 22+ CD pack, ie, you don't
need to order
the DB or iAS.
Have fun!
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Can you elaborate on fixing the STATS$IDLE_EVENT table.
Thanks
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
I recommend against using iAS 1.0.2.2.2a, I tried to install it just
yesterday on a Windows2000 machine and had so many problems I went back to
trusty old 1.0.2.2.0. CD set.
Patrice.
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 2:55 PM
To: Multiple
Well, if we continue the trend, now allow me a little bit of SF here, then
we
will become a nation of indistinguishable bean counters while going to the
moon
and breaking the barriers in physics will be subcontracted to Bangalore and
Hyderabad.
USS Enterprise will have to be renamed to USS Utar
I remove from this table the events deemed not idle for the database and Application
supported by
it. SQL*Net message related events can be important in client/server type
environments.
HTH,
- Kirti
--- Stephane Paquette [EMAIL PROTECTED] wrote:
Can you elaborate on fixing the
That is not a problem! Use advanced security and accounts identified
globally.
As long as you're able to authenticate the process with RADIUS, Kerberos or
something
like that, you can work with oracle.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
You would be well advised to *not* install SP4.
It will destroy network performance.
Supposedly this can be corrected:
http://tinyurl.com/odlw
or
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q249/7/99.aspNoWebContent=1
Jared
Hi List
How to check whether i am running 32 or 64 bit Sun
Solaris?
Also how to check whether my DB is 32 or 64 bit
TIA
Sami
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official
At 1:00PM Seattle time I complained loudly via their online Contact Us
form and they got the shipment out before the end of the day and are
waiving shipping costs. They tried but were unable to explain why it
wasn't shipped out before more recent orders for the same item. They
obviously have a bug
Title: RE: Apps 11.5.8 and 9i
Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows.
Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has
Select distinct employee_id||lname|fname|mi||hiredate as employee from emp
-Original Message-
Sent: Tuesday, September 23, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
I plan to select distinct data from table. anyone has suggestion?
Thanks.
select distinct employee
And easier way is to use a Netscape browser and the Save Frame As... option.
Andy Rivenes
At 04:24 AM 9/23/2003 -0800, Boivin, Patrice J wrote:
The grueling method is...
grab the header, copy paste it into notepad.exe. That strips the weird
formatting out of it.
Grab the body text, but not all
negative
Oracle DBA wrote:
__
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: Joe Testa
INET: [EMAIL PROTECTED]
Fat City
To find out about oracle go to $ORACLE_HOME/bin
Type
File oracle
Hope this helps.
-Original Message-
Sent: Tuesday, September 23, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Hi List
How to check whether i am running 32 or 64 bit Sun
Solaris?
Also how to check whether my DB
Netscape has been banned from our workplace. It's not the corporate
standard.
Patrice.
-Original Message-
Sent: Tuesday, September 23, 2003 4:00 PM
To: Multiple recipients of list ORACLE-L
And easier way is to use a Netscape browser and the Save Frame As...
option.
Andy Rivenes
At
Hi,
I have following question?
Basically making a column type as Clob - instead of varchar2(4000) - how
much extra overhead (as far as bytes/size) will it add to the table size?
I have a table with 6000 rows, and about 500 of them have 1 column with more
that 4000 chars, so they need to go to
I was
talking about Windows2000 SP4, not NT Workstation / Server 4
SP4...
Patrice
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003
2:45 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle8i, Failsafe and
Title: RE: test
Whew! What a relief!!!
-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 23, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: test
negative
Oracle DBA wrote:
__
Do you
thanks
-Original Message-
Kirtikumar Deshpande
Sent: Tuesday, September 23, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
I remove from this table the events deemed not idle for the database and
Application supported by
it. SQL*Net message related events can be important in
hi
when i am trying to refresh mviews on a 9.2.0.3 database from 8i database i get 3113 end-of-file-comminication-channel.complete refresh also fails with the same error
the above refresh has been running fine for sometime and and today this problem has started coming up. i even tried dropping
It seems that DBA's with poor skills is not limited to any particular locale.
After all, people are pretty much the same in regards to personal
motivations, regardless of nationality.
We're all equally plagued by folks with a less than adequate skill set
and knowledge of systems they purport to
I can see it now.
2103 - Can you believe it! They just outsourced my job to a martian!
2203 - Can you believe it! They just outsourced my job to some guy from Alpha
Centauri
2303 - Can you believe it! They just outsourced my job to a being from a parallel
dimension!
2403 - Can you believe it!
This link may help.
http://www.oracleadvice.com/Tips/32or64bit.htm
-Original Message-
Sent: Tuesday, September 23, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Hi List
How to check whether i am running 32 or 64 bit Sun
Solaris?
Also how to check whether my DB is 32 or 64 bit
It looks like we are going to be getting COGNOS' Business Intelligence tools
to do our reports against both Oracle 9i and SQL Server. I don't know much
about this product but if anyone out there uses itin your shop, who's
role would it be to define the cubesa DBA, developer, end user?
How to check whether i am running 32 or 64
bit Sun Solaris?
$ isainfo -kv
64-bit sparcv9 kernel modules
Also how to check whether my DB is 32 or
64 bit
$ file $ORACLE_HOME/bin/oracle
/oracle/u01/8.1.7/bin/oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically
linked, not stripped
soapbox
That kind of mentality burns me to no end. I can *almost* see it from a
Support perspective, but if people would just use http://validator.w3.org
when making their webpages and leave off all the Real/Shock/Quick/Crap
plugins and go frameless, there'd be a helluva lot more usable pages on
Title: Message
I have
a hunch that I'll continue to use perl for a while. I don't know why, but I just
feel that way.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Tuesday, September 23,
Oh PLEASE PLEASE PLEASE do NOT run BO on your OLDB! Your BO universe or
universes will look awful, resulting in awful queries running an awfully
long time, if you don't run out of TEMP space because of the FTSing.
Then again, we have no normalization on the tables it's hittingit's not
IT - Database (Do Not Use),
(or whatever your name *really* is!!!)
We use COGNOS here against our 8i and 9i databases, OLTP's and Warehouses.
Cubes are created by the COGNOS administrators (not DBA's). The only thing
that DBA's do is provide access via Oracle Roles to the various database
Hello,
If you do that in Win2k, then you have
more env variables for 'authorized' people to see when they do a SET cr.
Now, to be frank, I have an ulterior
(a 'maxed-out' interior or exterior) motive in this reply. I have yet to
see an intelligent (never mind elegant) of protecting system
Paul,
It's
simple really. Do not allow them to log-on to the Win2k server - don't
give them an account; keep the passwords secret; and keep the machine in a
locked room.
Tom
Mercadante Oracle Certified
Professional
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Title: Message
Let's see:
Oracle Regular Expressions Pocket Reference is part tutorial and
part quick-reference. It's suitable for those who have never used regular
expressions before, as well as those who have experience with Perl and other
languages supporting regular expressions. The
Did
you check for tracefiles? I've often found them (usually with a different
error code) after receiving an ORA-3113 error.
-Original Message-From: Sai Selvaganesan
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003
2:10 PMTo: Multiple recipients of list
With permission from Jared:
'Needed' is kind of strong. We've got a position open, but we're not real
needy folks. We're a school district. The 37th (depending on the day of
the week) largest in the United States. If we were a business, it'd be
pretty good-sized. Our annual operating budget
Hi,
Could someone shed some light on this.
I'm trying to formulate a query to return distinct value on a column -
testid.
select * from testing;
TESTID NAME STATUS
-- ---
1 MIKE Y
1 JOE Y
Title: Message
Mladen,
While
I respect you and your ability with using Perl, if this capability with regular
expressions now exists directly within PL/SQL, then why would I want to use Perl
to do this?
Oracle
Magazine had a pretty good article describing the newly-renamed Oracle
I'll be happier when I see hi-tech workers arguing for a ban on Nike
footwear unless made in the US and a pledge to avoid oil from the
mid-east and an utmost commitment not to work for companies using
foreign imports - no SAP consultants for example.
:(
Niall
--
Please see the official
Tom,
As Dave Barry would say, Har!
Unfortunately, we are talking about
3rd-party people who have the 'right' to log in for support (debugging
their ^%(^#@ products, and installing updates). I've got them under local
admin accounts (as opposed to domain accounts), so they can only get to
their
is it possible to have a primary key that is enforced with a bitmap index?
if so what is the syntax?
--
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
Elain,
The query is returning the correct data. DISTINCT applies to the row as a
whole. Since the NAME adds a new element, DISTINCT finds that 1MIKEY is
different than 1JOEY.
How do you determine the 'first' row of the testid? Depending upon the
access path (table/index), this could be a
Try this (in 8i or above):
select * from (
select
testid,
name,
status,
rank() over(
partition by testid
order by rownum
) dup_rank
from testing
)
where dup_rank = 1
-Original Message-
Sent: Tuesday, September 23, 2003 1:40 PM
To:
I have already bumped that up quite a bit
as well, but I still get many waits.
Thanks,
Rick Stephenson
Oracle Database Administrator
Ovid Technologies, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Justin Cave
[mailto:[EMAIL PROTECTED]
Sent: Monday, September 22,
SELECT DISTINCT testid
, FIRST_VALUE(name) OVER (PARTITION BY testid ORDER BY ROWID) name
, FIRST_VALUE(status) OVER (PARTITION BY testid ORDER BY ROWID) status
FROM testing
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent
Daniel,
I need only 1 row for each testid, name,status combination. I can do a
distinct on testid but I need the name and status to be displayed as well.
thanks.
elain
From: Daniel Fink [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
1 - 100 of 156 matches
Mail list logo