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
vinaycdm
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
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
useful link

http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_10002.htm

regards,
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using EXPLAIN PLAN

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

Regards
Michel

[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: Sat Dec 10 09:02:24 CST 2016

Total time taken to generate the page: 0.03925 seconds