List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ
If you did not commit the inserts to dual, then everyone will only see one
row.
If you committed the data and still one row appeared, then you must have a
row defined for dual.
Suggestion: Don't add more rows to dual if you value your dba life.
Thank You
Stephen P. Karniotis
Technical
It's because we designed it that way. In earlier releases (can't remember
the specific version we brought this in with), you could put more than one
row in DUAL and then select them all, but all the things that should have
returned only one row then failed with a 1403 (?) error - single row query
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo
rownum = 1' is always imposed on dual. Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a
trashable test database. Jared === 10:42:04 dv03@dt 10:42:05 dv03 10:42:05
dv03set echo on 10:42:05
dv03 10:42:05 dv03create table
I have seen many databases crash, yes crash, when
dual had more than one row or less than one?
Why you say?
As someone pointed out, this was an internal table to the kernel so
Oracle used it as they felt. It
was and still is considered a heartbeat mechanism within the kernel. In other
Didn't try no rows. I imagine all kinds of things would break.
Khedr, Waleed [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 11:04 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: dual
Do you
in DUAL and then select them all, but all the things that should have
returned only one row then failed with a 1403 (?) error - single row query
returning more than one row. I remember well way way back in time before
I
joined Oracle having the fun of trying to debug why all our clients apps
failed
I have observed 2 rows in dual till version 7.3.4. All application using
dual in their logic having more than 2 rows were giving wrong results. Quick
fix was to track it and delete more than one row(s). Duplicate import of
sys/system stuff were known to be culprit.
Regards
Rafiq
Reply
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003
3:09 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: dual
Didn't try no rows. I imagine all
kinds of things would break. [Shrek]
yes
they will... trust me
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: dual
I have observed 2 rows in dual till version 7.3.4. All application using
dual in their logic having more than 2 rows were giving wrong results. Quick
fix was to track it and delete more than one row(s). Duplicate import of
sys
Refer to
http://asktom.oracle.com/pls/ask/f?p=4950:8:5481819534388360937::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1562813956388,
for the answers to some of your questions below. I think it's safe to say
that DUAL is a rather 'magic' table. The normal rules for DML don't work
on it; I'd
Hi
all,
Can anyone tell me the performance issues related to the excessive usage of the
DUAL table in pl/sql procedures?
I remember reading
an article about this ( I dont remember if it was in ASKTOM site ) wherein it
was told that excessive usage of DUAL comes with a cost
PROTECTED]Sent by: [EMAIL PROTECTED]06/10/2003 11:24 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Query on Dual Hi all, Can anyone tell me the performance issues related to the excessive usage of the DUAL table in pl/sql procedures
Kesh,
I have some information on my website (http://www.optimaldba.com/internals/oraint_dual.html). It is a pretty terse discussion of the topic. I know that Cary Millsap has tested and written a paper on this as well. IIRC, there is mention of DUAL in his paper on reducing Logical I/Os. You
http://www.ixora.com.au/scripts/cache.htm
replace_dual.sql
In some cases the data block for SYS.DUAL can be a hot block in cache. This
script replaces the SYS.DUAL table with a view onto X$DUAL, thereby
eliminating the cache access entirely.
Please note: This is not a normal, supported
yield .00 52
setitimer .01 46
pread .04 162
--- ---
sys totals: 1.63 40305 0
usr time: 11.89
elapsed: 129.88
Also, from somewhere , i see someone's trick about xdual vs dual, and i did a
benchmark:
with dual:
SQL select * from v$mystat where statistic#=12
I see you've started two threads on SYSDATE at once.
A couple of thoughts (rhetorical questions, not criticisms)
a) Does your benchmark actually mean anything to YOU ?
Are you really doing lots of
select sysdate from dual
in your application ?
If so why do you want
Hi,
Is the link misspelled? It says Page cannot be found..
Jai
Yechiel Adar [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/17/02 11:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: DUAL
So listen
recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: DUAL
So listen up: For better April 1'st - add another record to dual. That is
known to cause a deteriorating effect on developers.
:-)
Yechiel Adar
Mehish
- Original Message
Title: RE: DUAL
That's
it. I'm inventing my own dummy table.
CREATE
TABLE dummy (DUAL varchar2(20));
-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 10:04
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
DUAL
So
I've seen that when I was a developper ...using
Oracle 6/vax vms and Sql*Forms 2.3.
There was 2 rows in dual.
Since dual was heavily used when programming in
Forms2.3, it cause a big problem as no users were able
to log in (the menu was using dual). It was in the
stock exchange department
I remember when you had a weird application problem, one of the
first thing Oracle support ask you to check is the dual table to
see if it's got more than one row in it.
Don't know if they are still doing that.
Richard Ji
-Original Message-
Sent: Tuesday, December 17, 2002 1:26 PM
you to check is the dual table to
see if it's got more than one row in it.
Don't know if they are still doing that.
Richard Ji
-Original Message-
Sent: Tuesday, December 17, 2002 1:26 PM
To: Multiple recipients of list ORACLE-L
I've seen that when I was a developper ...using
Oracle 6/vax
: Tuesday, December 17, 2002 1:40 PM
To: Multiple recipients of list ORACLE-L
I remember when you had a weird application problem, one of the
first thing Oracle support ask you to check is the dual table to
see if it's got more than one row in it.
Don't know if they are still doing that.
Richard Ji
The same thing happened to me as well.
There were 2 rows in dual, and it caused some really
strange problems with Oracle Financials.
The support tech and Oracle knew his stuff, and had
me check it. I have no idea how 2 rows came to be
in dual, but it sure was a mess.
Jared
Stephane
support ask you to check is the dual table to
see if it's got more than one row in it.
Don't know if they are still doing that.
Richard Ji
-Original Message-
Sent: Tuesday, December 17, 2002 1:26 PM
To: Multiple recipients of list ORACLE-L
I've seen that when I was a developper ...using
Title: RE: DUAL
Careful. We are listening.
;-)
(that woulda messed me up for a while)
-Original Message-
From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DUAL
Thanks
Title: RE: DUAL
So listen up: For better April 1'st - add another
record to dual. That is known to cause a deteriorating effect on
developers.
:-)
Yechiel AdarMehish
- Original Message -
From:
Jeremy Pulcifer
To: Multiple recipients of list ORACLE-L
Sent: Monday
Thanks for the great suggestion!
I will remember to use that one when
those developers start getting too lippy ;-)
Babette
-Original Message-
Richard
Sent: Thursday, December 12, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Howdy,
I believe that truncating DUAL has also been
Hallo,
Problems with dual, please read link
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html
TIA,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Hallo,
Dave- what is, Dual for Dummies?
-Original Message-
Sent: Thursday, December 12, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Hallo,
Problems with dual, please read link
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html
TIA,
Dave
--
Please
Howdy,
I believe that truncating DUAL has also been known to leave developers
scratching their head. Of course I could never recommend that anyone try
it though
Most commonly this is due to poor coding, where poor
means the sequence value is obtained explicitly in a
trigger or before the insert/update/etc is done.
Certainly plain old insert into xxx values
(bbb.nextval, ... )
is a lot faster than
a) select nextval from dual
b) do insert
/sec. Based
upon the information I get back, I can see that the following query...
SELECT STAGE_DATA_SEQ.NEXTVAL FROM DUAL;
Seems to use a significant amount of resource when you take into account the
number of times it is executed. The query plan shows a full scan of
sys.dual and it uses
Ken,
Thanks for adding one more example to the history of the poor
performance of dual. I have a discussion on my website at
www.optimaldba.com/internals/oraint_dual.html.
Why does the app need to select just the nextval? I presume it will
be used to insert a value into a table
Title: RE: select sequence.nextval from dual contributes to poor performan
you might want to try increasing the 'cache' size of the sequence.
If order is not important, and it is being used so often that it's having locking issues, you may want to create a couple different sequences
Subject: RE: select
sequence.nextval from dual contributes to poor perfo
you might want to try increasing the 'cache' size of the
sequence.
If order is not important, and it is being used so often that
it's having locking issues, you may want to create a couple different
]
cc:
Subject: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
If X is fixed for all sessions, do a step increase of X so that you only have
to select 1 row from dual.
Anjo.
On Friday 27 September 2002 00:18, you wrote:
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
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
-
Sent: Friday, September 27, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
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
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
Gary Chambers wrote:
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
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
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
Gary Chambers wrote:
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
As well as in MySQL
There is no need for such table in SQL Server.
If you need, you do just:
select 'whatever'
without from clause.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Ditto for PostgreSQL. For portability you can create a dual table but you
have to ensure that it only has one row. ;-) I finding that portability
between PostgreSQL and Oracle is easier than most... same to_date, to_char
functions, and stuff. Seems like that's part of Postgres' strategy
We are using PostgreSQL, but still have problems with statistics.
Sometimes after VACUUM ANALYZE optimizer doesn't use indexes
and performance goes down.
JP
On Friday 20 September 2002 18:43, you wrote:
Ditto for PostgreSQL. For portability you can create a dual table but you
have to ensure
VACUUM ANALYZE optimizer doesn't use indexes
and performance goes down.
JP
On Friday 20 September 2002 18:43, you wrote:
Ditto for PostgreSQL. For portability you can create a dual table but you
have to ensure that it only has one row. ;-) I finding that portability
between PostgreSQL and Oracle
, but still have problems with statistics.
Sometimes after VACUUM ANALYZE optimizer doesn't use indexes
and performance goes down.
JP
On Friday 20 September 2002 18:43, you wrote:
Ditto for PostgreSQL. For portability you can create a dual table but you
have to ensure that it only has one
indexes
and performance goes down.
JP
On Friday 20 September 2002 18:43, you wrote:
Ditto for PostgreSQL. For portability you can create a dual table but
you
have to ensure that it only has one row. ;-) I finding that
portability
between PostgreSQL and Oracle is easier than most... same
Oracle Developers, DBAs, Managers
You are cordially invited to attend the first Dual Track meeting of
the Ohio Oracle Users Group
When:Thursday, October 24, 2002
8:00am - 4:00pm.
Happy Hour following the meeting
Where: Dublin Community Recreation
Title: Message
Thanks
alot, that worked perfectly!
thank
you
bob
You'd need to do something
likethis under the SYS account:
SQL create view v_$dual
2 as
3 select dummy
4 from x$dual
5 where inst_id =
userenv('INSTANCE');
View created.
SQL
I've been reading the thread on DUAL vs X$DUAL, read the referenced article
and tried some testing on our system. I do a simple select from DUAL and I
get the same statistics as were in the article, but sometimes I also get 1
memory sort. Does anyone know why this would be? And if this is true
I followed the instructions but I get the error below. I do not get the same error
when I select from dual. And yes I did to the public grant. And other clues? DB
8.1.7.3
Thanks Kathy
Execution Plan
: Friday, August 02, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
I've been reading the thread on DUAL vs X$DUAL, read the referenced article
and tried some testing on our system. I do a simple select from DUAL and I
get the same statistics as were in the article, but sometimes I also get 1
Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 11:15 AM
I followed the instructions but I get the error below. I do not get the
same error when I select from dual. And yes I did to the public grant. And
other clues? DB 8.1.7.3
Thanks Kathy
But I don't get this error when I query from dual just from the new v$dual.
Kathy
-Original Message-
Sent: Friday, August 02, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
...if you're going to query from an account other than SYS, then please SET
AUTOTRACE TRACEONLY
Title: RE: DUAL revisited
-Original Message-
From: Kathy Duret [mailto:[EMAIL PROTECTED]]
But I don't get this error when I query from dual just from
the new v$dual.
That's because your v$dual view is assessing a SYS.X$ table. To do an explain plan on a SYS.X$ table you have
Correct. DUAL is a table owned by SYS for which SELECT permissions have
been granted to PUBLIC. V$DUAL is a view on a special fixed table named
X$DUAL. The SELECT permissions here are granted on the *view*; they cannot
be granted on a fixed table (i.e. X$ table). So, you're queries succeed
Sorry brain dead. Been working day and night for 5 days. Not much sleep. Makes
perfect sense now.
Kathy
-Original Message-
Sent: Friday, August 02, 2002 4:38 PM
To: Multiple recipients of list ORACLE-L
Correct. DUAL is a table owned by SYS for which SELECT permissions have
been
Hello All
Im looking to experiment with using x$dual opposed to dual.
from my reading
http://www.optimaldba.com/internals/oraint_dual.html
Which refers to using the memort structure of X$DUAL
if I
SQLdesc x$dual
ORA-04043: object x$dual does not exist
So how do I hook up x$dual
It is visible from user sys only.
-Original Message-
Sent: Thursday, August 01, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Hello All
Im looking to experiment with using x$dual opposed to dual.
from my reading
http://www.optimaldba.com/internals/oraint_dual.html
x$dual is owned by sys and is not visible to others (without sys granting
permissions). This is why you use sys to create the view and synonym. In
looking at what is posted, I did not indicate which user to login as for the
view creation. My apologies...I'll fix it shortly.
Thanks for the catch
You'd need to do something likethis under the
SYS account:
SQL create view v_$dual
2 as
3 select dummy
4 from x$dual
5 where inst_id =
userenv('INSTANCE');
View created.
SQL grant select on v_$dual to
public;
Permission granted.
SQL create public synonym v
I have a request from one of our developers to create two new sequences on
the DUAL table.
This seems like a bad idea to me. I've never had such a request in the
past. I asked for clarification on why this is needed and I didn't get a
lot of details yet.
Is this something that is standard
H? Sequences are not created on the dual table. Sequences exist as independent
entities. Ofttimes, sequence values are selected using the dual table (e.g., select
seqname.nextval from dual) -- this is a coding choice. Performance of queries that
select from the dual table are generally
Title: RE: Creating sequences on the DUAL table?
answer below
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a request from one of our developers to create two new
sequences on
the DUAL table.
This seems like a bad idea to me. I've never had
Cherie,
My first response is 'WHY?'. Do they mean that they want to create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some information
on the performance implications of DUAL at
http
Communication gap and ignorance. The developers proably want to create new
sequences. And they are used to writing queries as Select
sequencename.nextval from dual; So they call it sequences on the dual
table
Sounds like your developer hangs out with some of our developers! ;)
I am sorry to say but, I guess the syntax ...from dual could be confusing
to the developer.
Your understanding is just fine. Don't do anything with dual..
May be briefly explaining to the developer how sequence number
Title: RE: Creating sequences on the DUAL table?
Sequences are DB objects independent of any tables including dual (not
possible to create a sequence on a table. Sequences are sometimes used
to populate the PK of a table, but the actual sequence and the table are
not structurally related
PROTECTED]]
Sent: Tuesday, July 30, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Creating sequences on the DUAL table?
I have a request from one of our developers to create two new
sequences on
the DUAL table.
This seems like a bad idea to me. I've never had
Cherie,
You don't create sequences on a table, they are objects in and of
themselves.
So you can create the sequences for the developers but I'm
wondering where they got the notion that sequences were created on a
table. And why they want to use DUAL.
Rachel
--- [EMAIL PROTECTED] wrote
Dan,
Haven't heard the why yet but I think it may be just a poorly worded
request. I suspect he wants the sequences created on another table and
just wants to be able to select from dual. Maybe he never realized that
the sequences were actually created on another table.Maybe he actually
Kevin,
Thanks for the suggestion on select statements. I will pass them on. I
think it's just a misunderstanding on his part as to where the sequences
are actually created. Apparently he only uses them in a select from dual
so he thinks they reside there.
Cherie
Cherie,
If you push F1 key from SqlPlus there will be a complete explanation called
'all about sequences and how to create them on dual table'.
-Original Message-
Sent: Tuesday, July 30, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
Dan,
Haven't heard the why yet but I think
I would think they probably saw something like
select sequence_name.nextval from dual;
Maybe they thought the sequence and dual were connected in some manner.
-Original Message-
Sent: Tuesday, July 30, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L
Cherie,
You don't create
Mladen,
Thanks for everyone's response on this.
I think that this is just a misperception on the part of the developer. I
took the phrase verbatim from his change request. I suspect that he has
only ever used sequences in the SELECT from DUAL statement so he thinks
that they are actual
the sequences created on another table
and
just wants to be able to select from dual. Maybe he never realized
that
the sequences were actually created on another table.Maybe he
actually
thought that the sequences were created on the DUAL table since he
only
ever used them by selecting
the why yet but I think it may be just a poorly worded
request. I suspect he wants the sequences created on another table
and
just wants to be able to select from dual. Maybe he never realized
that
the sequences were actually created on another table.Maybe he
actually
thought
.
Jared
Fink, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 01:31 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Creating sequences on the DUAL table?
To be more accurate, a sequence
an example of what to read:
http://www.ultratech-llc.com/KB/?File=BootMgr.TXT
I have extensive notes on Win9x and Win2000 dual boot, but not
on Win2000 and WinXP dual boot.
On 28 Jul 2002 at 4:18, Dennis M. Heisler wrote:
Did you do any research yourself before asking? I did a quick
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: SEQ#, DUAL and Oracle literacy
I had to ponder this for a few seconds.
Economize synapses... paste and execute in SQL*Plus.
-Original Message-
Sent: Saturday, June 22, 2002 12:53 PM
To: Multiple
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: SEQ#, DUAL and Oracle literacy
I had to ponder this for a few seconds.
Economize synapses... paste and execute in SQL*Plus.
-Original Message-
Sent: Saturday, June 22, 2002 12:53
2002 14:23, Orr, Steve wrote:
Here's a performance tuning query to help identify the problem:
SELECT column_name The problem is the...
FROMdba_tab_columns
WHERE owner='SYS'
AND table_name = 'DUAL'
/
:-)
-Original Message-
Sent: Tuesday, June 18, 2002 3:07 PM
To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: SEQ#, DUAL and Oracle literacy
I had to ponder this for a few seconds.
Economize synapses... paste and execute in SQL*Plus.
-Original Message-
Sent: Saturday, June 22, 2002 12:53 PM
To: Multiple
tuning query to help identify the problem:
SELECT column_name The problem is the...
FROMdba_tab_columns
WHERE owner='SYS'
AND table_name = 'DUAL'
/
:-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City
character or
nature- du·al·ly
/-(l)-lE/ adverb
Main Entry: 2dualFunction: nounDate:
16501 : the dual number of a language2 : a
linguistic form in the dual
Entry Word: dualFunction: adjectiveText: 1
Synonyms TWOFOLD 1, bifold, binary, double, double-barreled,
dualistic, duple, duplex2 Synonyms TWIN
Well,
does this question get the same place in the 'hall of
oracle list' as the legendary 'are you an
idiot..?'...;)
--- Jared Still [EMAIL PROTECTED] wrote:
On Wednesday 19 June 2002 00:48, Farnsworth, Dave
wrote:
Hallo,
What is dual?
Are you a dummy? ;)
g
-Original
Ahem...
Are you an idiot?
;)
On Sunday 23 June 2002 11:38, Eric D. Pierce wrote:
HELP
On 23 Jun 2002 at 1:13, Sakthi , Raj wrote:
Well,
does this question get the same place in the 'hall of
oracle list' as the legendary 'are you an
idiot..?'...;)
...
--
Please see the
what is dual?
On 23 Jun 2002 at 14:45, Jared Still wrote:
Ahem...
Are you an idiot?
;)
On Sunday 23 June 2002 11:38, Eric D. Pierce wrote:
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City
HELP
-Original Message-
Sent: Sunday, June 23, 2002 7:48 PM
To: Multiple recipients of list ORACLE-L
Ahem...
Are you an idiot?
;)
On Sunday 23 June 2002 11:38, Eric D. Pierce wrote:
HELP
On 23 Jun 2002 at 1:13, Sakthi , Raj wrote:
Well,
does this question get the same
= 'DUAL'
/
:-)
-Original Message-
Sent: Tuesday, June 18, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
So did you fix it?
-Original Message-
Sent: Tuesday, June 18, 2002 3:07 PM
To: Multiple recipients of list ORACLE-L
Want to have a good laugh?... read
On Wednesday 19 June 2002 00:48, Farnsworth, Dave wrote:
Hallo,
What is dual?
Are you a dummy? ;)
g
-Original Message-
Sent: Tuesday, June 18, 2002 2:07 PM
To: Multiple recipients of list ORACLE-L
Want to have a good laugh?... read on... I don't think its OT :)
A few
we ARE discussing DUAL this is not OT is
it.?.;) )
RS
--- Alexandre Gorbatchev
[EMAIL PROTECTED] wrote:
And one column :)))
SQL describe dual
Name Null?
Type
Kinda neat.
Thanks!
Patrice.
-Original Message-
Sent: Saturday, June 22, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
For those who want to optimize select something from dual, look at the
following link...
http://www.oracledba.co.uk/tips/dual_speed.htm
Regards,
Vladimir
RS wrote: What kinda name is dual...sounds suspicious..;)
Especially when you consider that DUAL has ONE record only :-))
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 5:58 AM
While you are at it can
1 - 100 of 141 matches
Mail list logo