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
Olivia
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.


Thanks
Olivia

[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: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.

Quote:
How is the main importance of using dual table?

Because Oracle does not support SELECT without FROM.

Quote:
How or why only Dual table?

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

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


Current Time: Fri Dec 09 17:50:14 CST 2016

Total time taken to generate the page: 0.19439 seconds