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
Multiple recipients of list 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 i
-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... tru
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-To
th), 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
> returning more than one row. I remember well way way back in time before
I
> joined Oracle having th
L PROTECTED]>
cc:
Subject: RE: dual
Do you think it will work if it has no rows ?
Waleed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: dual
You may fin
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
'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
dv03>set echo on 10:42:05
dv03>
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&
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
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
Tech
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 of
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
:
[EMAIL PROTECTED] Subject: Re: Query on Dual
ity.com
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
izant)" <[EMAIL 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 u
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 and
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
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 stati
racle 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
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
Sent: 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 th
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 ...usin
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
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
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:
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 -
To: Multiple
TECTED]>
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 -
From: Jeremy Pulcifer
To: Multiple recipients of list ORACLE-L
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: M
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
> Su
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
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
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
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
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 du
PM
Subject: RE: select
.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 differe
Title: RE: select .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 sequ
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
/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
PROTECTED]>
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
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 yo
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 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 retu
-
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 us
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
su
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 Googl
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 requ
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
//
> 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 o
> DBA/Developer/
>
>
> 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 Post
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
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
> hav
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'
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
--
Au
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
t;
>
> -Original Message-
> Sent: 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 f
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
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
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
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
- Original 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.
: 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
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
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
Title: Message
Thanks
alot, that worked perfectly!
thank
you
bob
> You'd need to do something
like this under the SYS account:
SQL> create view v_$dual
2 as
3 select dummy
4 from x$dual
5 where inst_id =
userenv('INSTANCE&#
You'd need to do something like this 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;
Permissi
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
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
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
SQL>desc x$dual
ORA-04043: object x$dual does not exist
So how do I hook up x$d
.
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?
> 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 anoth
uest. 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 that the sequences were created on the DUAL tab
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 a
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 c
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
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.
C
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 act
] [mailto:[EMAIL 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.
&g
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 PROTEC
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 structural
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
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
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 DU
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
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
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 i
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 qu
Sent by: [EMAIL PROTECTED]
06/25/2002 08:03 AM
Please respond to ORACLE-L
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...
08:03 AM
Please respond to ORACLE-L
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.
-Origi
d one Steve.
Jared
On Tuesday 18 June 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 = &#
pond to ORACLE-L
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
une 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'
> /
>
> :-)
&
: having a double 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,
dua
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 sam
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
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
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 official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTE
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,
>
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 from dual", look at the
following link...
http://www.oracledba.co.uk/tips/dual_speed.htm
Regards
GOD.
> ( Jared since we ARE discussing DUAL this is not OT is
> it.?.;) )
>
> RS
>
> --- Alexandre Gorbatchev
>
> <[EMAIL PROTECTED]> wrote:
> > And one column :)))
> >
> > SQL> describe
1 - 100 of 150 matches
Mail list logo
