Re: Dual table

Oradba Linux wrote:
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:13189451231851900629::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1562813956388
>
> I have reading through this link and it made me curious to find out if there
> are sites out there having your own version of dual
> instead of sys.dual.

It can be useful for applications where you can't change the code - we had an app where a myriad of things did a 'select .. from dual' (even to be basic assignments to variables). The options we had were:

1. shoot the vendor (my preference)
2. have a local version of dual in the relevant schemas

Be careful - you'll be amazed what it can affect. We tried an IOT local version of dual, and suddenly our fast-refresh-single-table-aggregate materialised views stopped working...!!! We compromised with a heap (local) dual with an index on it.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"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"

------------------------------------------------------------