Hi,
I found Workflow 2.6.2 on the 9.2.0.1 Database cdrom set.
You get to it by picking
Enterprise Edition and then custom.
-moi
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please
Hi!
Oracle Performance Tuning 101 eBook (by Gaja, Kirti and John Kostelac) is
available to download in PDF from http://www.veritas.com/offer?a_id=3805
Btw, veritas has a free SQL Server tuning book on their site as well.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Dear All,
I need help on the following query, the following has been simplified to
show you the exact problem. Due to this error, the sql query is giving
unstable result which affects on production reporting in my company. I
wonder what's the real problem?
SQL SELECT COUNT(1) FROM
2 (SELECT
Hi!
Use SET TRANSACTION READ ONLY before your run the queries and run them again
(without any commits or rollbacks in the middle). That way you can be sure
that any hidden changes to data won't be reflected.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Something affordable. These are hot right now and
I'd like to learn how to use them. I cant find anything on the web.
Title: Re: any student versions of 'business objects' ab initio or informatica?
Probably best to contact them directly?
I suspect that Ab Initio in particular will be out of reach for this purpose. My understanding is that they choose their customers based on their capability to deliver a data
Title: Re: any student versions of 'business objects' ab initio or informatica?
does business objects = crystal reports? anyone can
use crystal reports?
why are employers picky about people with business
objects knowledge?
https://secure.businessobjects.com/default.asp
- Original
Ryan - Some more thoughts for your consideration.
1. Consider studying Data Warehousing. These tools are deliberately made
easy to use, so shouldn't take much effort, but understanding how to design
a star schema will make data more accessible to any tool. A good start can
be had at
Jay
That is a good one. The question is: How is the uniqueness constraint
being enforced when the index is nonunique? Offhand I would have assumed
your constraint would have been rejected since the index is nonunique --
nope. Then I would have guessed the index would have been converted to a
No.
It is coming in 10g (from Oracle World presentations I attended last year).
- Kirti
--- [EMAIL PROTECTED] wrote:
Is there anyway to rename tablespace in Oracle 9202. Thanks
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
Depends what you want to achieve.
A non-unique index enforcing a unique
constraint allows the constraint to be
deferrable - so you could load some
'nearly unique' data against it and find
the duplicates efficiently.
However, a non-unique index requires
one byte per entry more than the
Thanks a lot for your quick response Mr.Jonathan and Mr.Dennis.
One more silly question...
What is the difference(pros cons) between creating PK Vs (UK+NOT NULL) Vs
(UK+check constraint with Not null condition)?
1)
drop table constraint_test;
create table constraint_test(c1 number,c2
Jay,
Remember, both UK and PK are enforced by unique indexes. The important
difference between them is a null value is allowed in UK, not in PK.
In (1), your constraint is specifically named as ct_pk1. Oracle does the for
you:
a) create a unique index ct_pk for you in the default tablespace of
13 matches
Mail list logo
