Home » RDBMS Server » Server Administration » How Oracle works internally (Oracle 9i/10g)
How Oracle works internally [message #359984] Wed, 19 November 2008 01:54 Go to next message
Messages: 519
Registered: June 2008
Senior Member
A few questions that I want to know:

How oracle works internally?

How is the main importance of using dual table? How or why only Dual table?

I did search in Google [ http://oreilly.com/catalog/orinternals/chapter/ch01.html ] and got some information. But is there any link from where I can have more information.


[Updated on: Wed, 19 November 2008 01:57]

Report message to a moderator

Re: How Oracle works internally [message #359994 is a reply to message #359984] Wed, 19 November 2008 02:52 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How oracle works internally?

Quite well.
I think it is not the first I point you to the Database Concepts, you really should read it.

How is the main importance of using dual table?

Because Oracle does not support SELECT without FROM.

How or why only Dual table?

Explain question.
How what?
Why what?
Why "only"?

Previous Topic: User wihtout Create user command
Next Topic: Oracle 64bit Windows to 32bit Windows
Goto Forum:

Current Time: Sun Oct 23 09:16:39 CDT 2016

Total time taken to generate the page: 0.11387 seconds