Home » SQL & PL/SQL » SQL & PL/SQL » Order of SQL execution
Order of SQL execution [message #305071] Sat, 08 March 2008 01:25 Go to next message
Messages: 7
Registered: February 2008
Junior Member
Could any one tell me what is the order of SQL execution? or could guide me with correct article.

For example:

select ID, name , phone, (select statement) address, Age
from user_Profile
where (Where condition)

1) Is the inner 'select statement' inside the main 'select statement' executes first or vice versa?

2) I think the Where condition will be determined first and then the rest.

3) Can I use a table alias in the where clause that is used in 'Inner select statement'.
Re: Order of SQL execution [message #305072 is a reply to message #305071] Sat, 08 March 2008 01:54 Go to previous messageGo to next message
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
useful link


Re: Order of SQL execution [message #305073 is a reply to message #305071] Sat, 08 March 2008 02:00 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

3) If you meant the query that is in the select clause, the answer is no.


[Updated on: Sat, 08 March 2008 02:03]

Report message to a moderator

Previous Topic: How to List all parameters in a procedure
Next Topic: Questions about to_char and Assigning date to a DATE datatype variable
Goto Forum:

Current Time: Mon Oct 24 17:53:21 CDT 2016

Total time taken to generate the page: 0.11532 seconds